Method getUserProfile

api/mysql.go:747–761

get user profile

(username string)

// get user profile
func (d *db) getUserProfile(username string) *User {
	user := &User{}
	rawSQL := fmt.Sprintf("select id, username, password, display_name, phone, wechat, type, mail, role, "+
		"DATE_FORMAT(create_at,'%s') as create_at, DATE_FORMAT(update_at,'%s') "+
		"as update_at from user where username='%s'",
		timeFormat, timeFormat, username)
	log.Println(rawSQL)
	if err := d.Get(user, rawSQL); err != nil {
		if err != sql.ErrNoRows {
			log.Println(err)
		}
		return nil
	}
	return user
}

// 创建用户
func (d *db) createUser(user *User) (*User, error) {