func (obj UserAccount) Search(m *Model,
query UserAccountQuery,
sort UserAccountSortBy,
page UserAccountPage) (total int64, results []UserAccount, err error) {
t := bsql.TABLE(obj.TableName())
t.PrimaryKey(obj.PrimaryKey())
t.Columns(obj.Columns()...)
SQL := bsql.NewQuerySQL(t)
query.SQL(SQL)
sort.SQL(SQL)
page.SQL(SQL)
count := SQL.CountStatment()
total, err = m.SelectInt(count.SQLFormat(), count.SQLParams()...)
if err != nil {
return
}
statment := SQL.Statment()
_, err = m.Select(&results, statment.SQLFormat(), statment.SQLParams()...)
return
}
func (obj UserAccount) Count(m *Model) int64 {
t := bsql.TABLE(obj.TableName())
SQL := bsql.NewQuerySQL(t)
stmt := SQL.CountStatment()
count, _ := m.SelectInt(stmt.SQLFormat(), stmt.SQLParams()...)
return count
}