package models
|
|
import (
|
"github.com/astaxie/beego/orm"
|
)
|
|
type User struct {
|
Id string `orm:"pk;size(50);column(id)" json:"id"`
|
Username string `orm:"size(250);column(username)" json:"username"`
|
PhoneNum string `orm:"size(20);column(phoneNum)" json:"phoneNum"` //手机号
|
Password string `orm:"size(50);column(password)" json:"password"`
|
TrueName string `orm:"size(250);column(trueName)" json:"trueName"` //真实姓名
|
Gender int `orm:"size(1);column(gender)" json:"gender"` //性别
|
IdCard string `orm:"size(250);column(idCard)" json:"idCard"` //身份证号
|
Age int `orm:"size(8);column(age)" json:"age"` //年龄
|
Address string `orm:"size(200);column(address)" json:"gender"` //地址
|
|
Email string `orm:"size(200);column(email)" json:"email"` //邮箱
|
IsDelete bool `orm:"size(1);default(0);column(isDelete)" json:"isDelete"`
|
}
|
|
func (u *User) TableName() string {
|
return "sys_user"
|
}
|
|
func (u *User) TableUnique() [][]string {
|
return [][]string {
|
[]string{"phoneNum"},
|
}
|
}
|
|
func (u *User) Insert() (int64,error) {
|
o := orm.NewOrm()
|
return o.Insert(u)
|
}
|
|
func (u *User) SelectById(uid string) error {
|
o := orm.NewOrm()
|
err := o.Raw("select * from ? where id=?", u.TableName(), uid).QueryRow(u)
|
return err
|
}
|
|
func (u *User) SelectByPhoneNum(phoneNum string) error {
|
o := orm.NewOrm()
|
err := o.Raw("select * from ? where phoneNum=?", u.TableName(), phoneNum).QueryRow(u)
|
return err
|
}
|
|
func (u *User) GetAllUsers() (all []User,err error) {
|
o := orm.NewOrm()
|
_, err = o.Raw("select * from ?", u.TableName()).QueryRows(&all)
|
if err != nil {
|
return nil, err
|
}
|
return all,nil
|
}
|
|
func (u *User) Update() (int64, error) {
|
o := orm.NewOrm()
|
return o.Update(u)
|
}
|
|
func Login(username, password string) bool {
|
|
return false
|
}
|
|
func (u *User) DeleteById() (int64, error) {
|
o := orm.NewOrm()
|
return o.Update(u, "isDelete")
|
}
|
