model

type Student struct {
	Id         int64           `db:"id"`
	Class      string          `db:"class"`
	Name       string          `db:"name"`
	Age        sql.NullInt64   `db:"age"`
	Score      sql.NullFloat64 `db:"score"`
	CreateTime time.Time       `db:"create_time"`
	UpdateTime sql.NullTime    `db:"update_time"`
}

type StudentModel interface {
	Insert(data Student) (sql.Result, error)
	FindOne(id int64) (*Student, error)
	FindOneByClassName(class, name string) (*Student, error)
	Update(data Student) error
	// only for test
	Delete(id int64, className, studentName string) error
}

type User struct {
	ID         int64     `db:"id"`
	User       string    `db:"user"`     // user
	Name       string    `db:"name"`     // user name
	Password   string    `db:"password"` // user password
	Mobile     string    `db:"mobile"`   // user mobile
	Gender     string    `db:"gender"`   // male | female | unknown
	Nickname   string    `db:"nickname"` // user nickname
	CreateTime time.Time `db:"create_time"`
	UpdateTime time.Time `db:"update_time"`
}

type UserModel interface {
	Insert(data User) (sql.Result, error)
	FindOne(id int64) (*User, error)
	FindOneByUser(user string) (*User, error)
	FindOneByMobile(mobile string) (*User, error)
	FindOneByName(name string) (*User, error)
	Update(data User) error
	Delete(id int64) error
}