Documentation ¶
Index ¶
- Variables
- type UserDao
- func (d *UserDao) All(where ...interface{}) ([]*model.User, error)
- func (d *UserDao) And(where interface{}, args ...interface{}) *UserDao
- func (d *UserDao) Args(args ...interface{}) *UserDao
- func (d *UserDao) As(as string) *UserDao
- func (d *UserDao) Batch(batch int) *UserDao
- func (d *UserDao) Cache(duration time.Duration, name ...string) *UserDao
- func (d *UserDao) Chunk(limit int, callback func(entities []*model.User, err error) bool)
- func (d *UserDao) Ctx(ctx context.Context) *UserDao
- func (d *UserDao) Data(data ...interface{}) *UserDao
- func (d *UserDao) Fields(fieldNamesOrMapStruct ...interface{}) *UserDao
- func (d *UserDao) FieldsEx(fieldNamesOrMapStruct ...interface{}) *UserDao
- func (d *UserDao) Filter() *UserDao
- func (d *UserDao) FindAll(where ...interface{}) ([]*model.User, error)
- func (d *UserDao) FindOne(where ...interface{}) (*model.User, error)
- func (d *UserDao) Group(groupBy string) *UserDao
- func (d *UserDao) InnerJoin(table ...string) *UserDao
- func (d *UserDao) LeftJoin(table ...string) *UserDao
- func (d *UserDao) Limit(limit ...int) *UserDao
- func (d *UserDao) LockShared() *UserDao
- func (d *UserDao) LockUpdate() *UserDao
- func (d *UserDao) Master() *UserDao
- func (d *UserDao) Offset(offset int) *UserDao
- func (d *UserDao) OmitEmpty() *UserDao
- func (d *UserDao) One(where ...interface{}) (*model.User, error)
- func (d *UserDao) Option(option int) *UserDao
- func (d *UserDao) Or(where interface{}, args ...interface{}) *UserDao
- func (d *UserDao) Order(orderBy ...string) *UserDao
- func (d *UserDao) Page(page, limit int) *UserDao
- func (d *UserDao) RightJoin(table ...string) *UserDao
- func (d *UserDao) Slave() *UserDao
- func (d *UserDao) TX(tx *gdb.TX) *UserDao
- func (d *UserDao) Unscoped() *UserDao
- func (d *UserDao) Where(where interface{}, args ...interface{}) *UserDao
- func (d *UserDao) WherePri(where interface{}, args ...interface{}) *UserDao
Constants ¶
This section is empty.
Variables ¶
var ( // User is globally public accessible object for table user operations. User = &UserDao{ M: g.DB("default").Table("user").Safe(), Table: "user", Columns: userColumns{ Id: "id", Passport: "passport", Password: "password", Nickname: "nickname", CreateAt: "create_at", UpdateAt: "update_at", }, } )
Functions ¶
This section is empty.
Types ¶
type UserDao ¶
UserDao is the manager for logic model data accessing and custom defined data operations functions management.
func (*UserDao) All ¶
All does "SELECT FROM ..." statement for the model. It retrieves the records from table and returns the result as []*model.User. It returns nil if there's no record retrieved with the given conditions from table.
The optional parameter <where> is the same as the parameter of M.Where function, see M.Where.
func (*UserDao) Cache ¶
Cache sets the cache feature for the model. It caches the result of the sql, which means if there's another same sql request, it just reads and returns the result from cache, it but not committed and executed into the database.
If the parameter <duration> < 0, which means it clear the cache with given <name>. If the parameter <duration> = 0, which means it never expires. If the parameter <duration> > 0, which means it expires after <duration>.
The optional parameter <name> is used to bind a name to the cache, which means you can later control the cache like changing the <duration> or clearing the cache with specified <name>.
Note that, the cache feature is disabled if the model is operating on a transaction.
func (*UserDao) Ctx ¶
Ctx is a chaining function, which creates and returns a new DB that is a shallow copy of current DB object and with given context in it. Note that this returned DB object can be used only once, so do not assign it to a global or package variable for long using.
func (*UserDao) Data ¶
Data sets the operation data for the model. The parameter <data> can be type of string/map/gmap/slice/struct/*struct, etc. Eg: Data("uid=10000") Data("uid", 10000) Data(g.Map{"uid": 10000, "name":"john"}) Data(g.Slice{g.Map{"uid": 10000, "name":"john"}, g.Map{"uid": 20000, "name":"smith"})
func (*UserDao) Fields ¶
Fields sets the operation fields of the model, multiple fields joined using char ','. The parameter <fieldNamesOrMapStruct> can be type of string/map/*map/struct/*struct.
func (*UserDao) FieldsEx ¶
FieldsEx sets the excluded operation fields of the model, multiple fields joined using char ','. The parameter <fieldNamesOrMapStruct> can be type of string/map/*map/struct/*struct.
func (*UserDao) Filter ¶
Filter marks filtering the fields which does not exist in the fields of the operated table.
func (*UserDao) FindAll ¶
FindAll retrieves and returns Result by by M.WherePri and M.All. Also see M.WherePri and M.All.
func (*UserDao) FindOne ¶
FindOne retrieves and returns a single Record by M.WherePri and M.One. Also see M.WherePri and M.One.
func (*UserDao) InnerJoin ¶
InnerJoin does "INNER JOIN ... ON ..." statement on the model. The parameter <table> can be joined table and its joined condition, and also with its alias name, like: Table("user").InnerJoin("user_detail", "user_detail.uid=user.uid") Table("user", "u").InnerJoin("user_detail", "ud", "ud.uid=u.uid")
func (*UserDao) LeftJoin ¶
LeftJoin does "LEFT JOIN ... ON ..." statement on the model. The parameter <table> can be joined table and its joined condition, and also with its alias name, like: Table("user").LeftJoin("user_detail", "user_detail.uid=user.uid") Table("user", "u").LeftJoin("user_detail", "ud", "ud.uid=u.uid")
func (*UserDao) Limit ¶
Limit sets the "LIMIT" statement for the model. The parameter <limit> can be either one or two number, if passed two number is passed, it then sets "LIMIT limit[0],limit[1]" statement for the model, or else it sets "LIMIT limit[0]" statement.
func (*UserDao) LockShared ¶
LockShared sets the lock in share mode for current operation.
func (*UserDao) LockUpdate ¶
LockUpdate sets the lock for update for current operation.
func (*UserDao) Offset ¶
Offset sets the "OFFSET" statement for the model. It only makes sense for some databases like SQLServer, PostgreSQL, etc.
func (*UserDao) OmitEmpty ¶
OmitEmpty sets OPTION_OMITEMPTY option for the model, which automatically filers the data and where attributes for empty values.
func (*UserDao) One ¶
One retrieves one record from table and returns the result as *model.User. It returns nil if there's no record retrieved with the given conditions from table.
The optional parameter <where> is the same as the parameter of M.Where function, see M.Where.
func (*UserDao) Page ¶
Page sets the paging number for the model. The parameter <page> is started from 1 for paging. Note that, it differs that the Limit function start from 0 for "LIMIT" statement.
func (*UserDao) RightJoin ¶
RightJoin does "RIGHT JOIN ... ON ..." statement on the model. The parameter <table> can be joined table and its joined condition, and also with its alias name, like: Table("user").RightJoin("user_detail", "user_detail.uid=user.uid") Table("user", "u").RightJoin("user_detail", "ud", "ud.uid=u.uid")
func (*UserDao) Slave ¶
Slave marks the following operation on slave node. Note that it makes sense only if there's any slave node configured.
func (*UserDao) Where ¶
Where sets the condition statement for the model. The parameter <where> can be type of string/map/gmap/slice/struct/*struct, etc. Note that, if it's called more than one times, multiple conditions will be joined into where statement using "AND". Eg: Where("uid=10000") Where("uid", 10000) Where("money>? AND name like ?", 99999, "vip_%") Where("uid", 1).Where("name", "john") Where("status IN (?)", g.Slice{1,2,3}) Where("age IN(?,?)", 18, 50) Where(User{ Id : 1, UserName : "john"})
func (*UserDao) WherePri ¶
WherePri does the same logic as M.Where except that if the parameter <where> is a single condition like int/string/float/slice, it treats the condition as the primary key value. That is, if primary key is "id" and given <where> parameter as "123", the WherePri function treats the condition as "id=123", but M.Where treats the condition as string "123".