From 13a31b1caab8ffa0049dc8299cab8b8c4a31b6ed Mon Sep 17 00:00:00 2001 From: liuxiaolong <liuxiaolong@aiotlink.com> Date: 星期二, 11 八月 2020 15:32:06 +0800 Subject: [PATCH] test --- models/user.go | 35 ++++++++++++++++++++++++++++------- 1 files changed, 28 insertions(+), 7 deletions(-) diff --git a/models/user.go b/models/user.go index 5e2e8f0..43365e0 100644 --- a/models/user.go +++ b/models/user.go @@ -36,23 +36,35 @@ func (u *User) SelectById(uid string) error { o := orm.NewOrm() - err := o.Raw("select * from ? where id=?", u.TableName(), uid).QueryRow(u) + err := o.QueryTable(u.TableName()).Filter("id", uid).One(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) + err := o.QueryTable(u.TableName()).Filter("phoneNum", phoneNum).One(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 + //o := orm.NewOrm() + //_, err = o.QueryTable(u.TableName()).All(&all) + //if err != nil { + // return nil, err + //} + //return all,nil + return nil, nil +} + +func (u *User) GetAllMapByPhone() map[string]User { + m := make(map[string]User) + all, _ := u.GetAllUsers() + if all !=nil { + for _,p := range all { + m[p.PhoneNum] = p + } } - return all,nil + return m } func (u *User) Update() (int64, error) { @@ -60,6 +72,15 @@ return o.Update(u) } +func (u *User) SyncHikPersonId(phoneNum string, hikPersonId string) (int64, error) { + o := orm.NewOrm() + res, err := o.Raw("update sys_user set id=? where phoneNum=?", hikPersonId, phoneNum).Exec() + if err != nil { + return 0, err + } + return res.RowsAffected() +} + func Login(username, password string) bool { return false -- Gitblit v1.8.0