1/trading-go/model/user.go

package model

import "trading-go/common"

type User struct {
	Uid    string `json:"uid" db:"uid"`
	Name   string `json:"name" db:"name"`
	Avatar string `json:"avatar" db:"avatar"`
	Email  string `json:"email" db:"email"`
	Phone  string `json:"phone" db:"phone"`
}

func (u User) Register() error {
	db := common.DB
	sqlStr := "INSERT INTO users(uid, name, avatar) values (:uid, :name, :avatar)"
	exec, err := db.NamedExec(sqlStr, u)
	if err != nil {
		return err
	}
	affected, err := exec.RowsAffected()
	if err != nil {
		return err
	}
	if affected != 1 {
		return common.InsertFailError
	}
	return nil
}