upper / db

Data Access Layer (DAL) for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
https://upper.io/
MIT License
3.53k stars 234 forks source link

Update how to get the effected rows #660

Open wzhsh90 opened 2 years ago

wzhsh90 commented 2 years ago

Update method only return the error , how can i kown the update really effected rows?

func (r *Result) Update(values interface{}) error { query, err := r.buildUpdate(values) if err != nil { r.setErr(err) return err } _, err = query.Exec() r.setErr(err) return err }

my test case: 1、insert into person_info_t(id,name) values('1','1'); 2、update person_info_t set name='2' where id='1'; return nil 3、update person_info_t set name='2' where id='1'; return ni but the database dose not effect one row

only use the sql builder to sovle this problem ?