Group/Order分组与排序

Group方法用于查询分组,Order方法用于查询排序。使用示例:

  1. // SELECT COUNT(*) total,age FROM `user` GROUP BY age
  2. g.Model("user").Fields("COUNT(*) total,age").Group("age").All()
  3. // SELECT * FROM `student` ORDER BY class asc,course asc,score desc
  4. g.Model("student").Order("class asc,course asc,score desc").All()

同时,goframeORM提供了一些常用的排序方法:

  1. // 按照指定字段递增排序
  2. func (m *Model) OrderAsc(column string) *Model
  3. // 按照指定字段递减排序
  4. func (m *Model) OrderDesc(column string) *Model
  5. // 随机排序
  6. func (m *Model) OrderRandom() *Model

使用示例:

  1. // SELECT `id`,`title` FROM `article` ORDER BY `created_at` ASC
  2. g.Model("article").Fields("id,title").OrderAsc("created_at").All()
  3. // SELECT `id`,`title` FROM `article` ORDER BY `views` DESC
  4. g.Model("article").Fields("id,title").OrderDesc("views").All()
  5. // SELECT `id`,`title` FROM `article` ORDER BY RAND()
  6. g.Model("article").Fields("id,title").OrderRandom().All()

Having条件过滤

Having方法用于查询结果的条件过滤。使用示例:

  1. // SELECT COUNT(*) total,age FROM `user` GROUP BY age HAVING total>100
  2. g.Model("user").Fields("COUNT(*) total,age").Group("age").Having("total>100").All()
  3. // SELECT * FROM `student` ORDER BY class HAVING score>60
  4. g.Model("student").Order("class").Having("score>?", 60).All()