基本介绍

gdb链式操作使用方式简单灵活，是GoFrame框架官方推荐的数据库操作方式。链式操作可以通过数据库对象的db.Model方法或者事务对象的tx.Model方法，基于指定的数据表返回一个链式操作对象*Model，该对象可以执行以下方法。当前方法列表可能滞后于源代码，详细的方法列表请参考接口文档： https://pkg.go.dev/github.com/gogf/gf/v2/database/gdb#Model

  1. // 写入/更新/删除基本操作
  2. func (m *Model) Insert(data ...interface{}) (result sql.Result, err error)
  3. func (m *Model) InsertAndGetId(data ...interface{}) (lastInsertId int64, err error)
  4. func (m *Model) InsertIgnore(data ...interface{}) (result sql.Result, err error)
  5. func (m *Model) Replace(data ...interface{}) (result sql.Result, err error)
  6. func (m *Model) Save(data ...interface{}) (result sql.Result, err error)
  7. func (m *Model) Update(dataAndWhere ...interface{}) (result sql.Result, err error)
  8. func (m *Model) Delete(where ...interface{}) (result sql.Result, err error)
  10. // 基本查询操作
  11. func (m *Model) All(where ...interface{} (Result, error)
  12. func (m *Model) One(where ...interface{}) (Record, error)
  13. func (m *Model) Array(fieldsAndWhere ...interface{}) ([]Value, error)
  14. func (m *Model) Value(fieldsAndWhere ...interface{}) (Value, error)
  15. func (m *Model) Count(where ...interface{}) (int, error)
  16. func (m *Model) CountColumn(column string) (int, error)
  18. // 常用基本统计
  19. func (m *Model) Min(column string) (float64, error)
  20. func (m *Model) Max(column string) (float64, error)
  21. func (m *Model) Avg(column string) (float64, error)
  22. func (m *Model) Sum(column string) (float64, error)
  24. // 字段自增/自减
  25. func (m *Model) Increment(column string, amount float64) (sql.Result, error)
  26. func (m *Model) Decrement(column string, amount float64) (sql.Result, error)
  28. // 主键查询操作
  29. func (m *Model) FindAll(where ...interface{}) (Result, error)
  30. func (m *Model) FindOne(where ...interface{}) (Record, error)
  31. func (m *Model) FindArray(fieldsAndWhere ...interface{}) (Value, error)
  32. func (m *Model) FindValue(fieldsAndWhere ...interface{}) (Value, error)
  33. func (m *Model) FindCount(where ...interface{}) (int, error)
  34. func (m *Model) FindScan(pointer interface{}, where ...interface{}) error
  36. // 查询转换操作
  37. func (m *Model) Struct(pointer interface{}) error
  38. func (m *Model) Structs(pointer interface{}) error
  39. func (m *Model) Scan(pointer interface{}) error
  40. func (m *Model) ScanList(listPointer interface{}, attributeName string, relation ...string) (err error)
  42. // 联表查询方法
  43. func (m *Model) LeftJoin(table ...string) *Model
  44. func (m *Model) RightJoin(table ...string) *Model
  45. func (m *Model) InnerJoin(table ...string) *Model
  47. // 联合查询
  48. func (m *Model) Union(unions ...*Model) *Model
  49. func (m *Model) UnionAll(unions ...*Model) *Model
  51. // With关联查询
  52. func (m *Model) With(object interface{}) *Model
  53. func (m *Model) WithAll() *Model
  55. // 条件查询方法 
  56. func (m *Model) Where(where interface{}, args...interface{}) *Model
  57. func (m *Model) WherePri(where interface{}, args ...interface{}) *Model
  58. func (m *Model) WhereBetween(column string, min, max interface{}) *Model
  59. func (m *Model) WhereLike(column string, like interface{}) *Model
  60. func (m *Model) WhereIn(column string, in interface{}) *Model
  61. func (m *Model) WhereNull(columns ...string) *Model
  62. func (m *Model) WhereLT(column string, value interface{}) *Model
  63. func (m *Model) WhereLTE(column string, value interface{}) *Model
  64. func (m *Model) WhereGT(column string, value interface{}) *Model
  65. func (m *Model) WhereGTE(column string, value interface{}) *Model
  67. func (m *Model) WhereNotBetween(column string, min, max interface{}) *Model
  68. func (m *Model) WhereNotLike(column string, like interface{}) *Model
  69. func (m *Model) WhereNotIn(column string, in interface{}) *Model
  70. func (m *Model) WhereNotNull(columns ...string) *Model
  72. func (m *Model) WhereOr(where interface{}, args ...interface{}) *Model
  73. func (m *Model) WhereOrBetween(column string, min, max interface{}) *Model
  74. func (m *Model) WhereOrLike(column string, like interface{}) *Model
  75. func (m *Model) WhereOrIn(column string, in interface{}) *Model
  76. func (m *Model) WhereOrNull(columns ...string) *Model
  77. func (m *Model) WhereOrLT(column string, value interface{}) *Model 
  78. func (m *Model) WhereOrLTE(column string, value interface{}) *Model 
  79. func (m *Model) WhereOrGT(column string, value interface{}) *Model 
  80. func (m *Model) WhereOrGTE(column string, value interface{}) *Model
  82. func (m *Model) WhereOrNotBetween(column string, min, max interface{}) *Model
  83. func (m *Model) WhereOrNotLike(column string, like interface{}) *Model
  84. func (m *Model) WhereOrNotIn(column string, in interface{}) *Model
  85. func (m *Model) WhereOrNotNull(columns ...string) *Model
  87. // 分组排序方法
  88. func (m *Model) Group(group string) *Model
  89. func (m *Model) Order(order string) *Model
  90. func (m *Model) OrderAsc(column string) *Model
  91. func (m *Model) OrderDesc(column string) *Model
  92. func (m *Model) OrderRandom() *Model
  94. // 条件过滤方法
  95. func (m *Model) Fields(fields string) *Model
  96. func (m *Model) FieldsEx(fields string) *Model
  97. func (m *Model) Data(data...interface{}) *Model
  98. func (m *Model) Batch(batch int) *Model
  99. func (m *Model) Filter() *Model
  100. func (m *Model) Safe(safe...bool) *Model
  101. func (m *Model) Having(having interface{}, args ...interface{}) *Model
  102. func (m *Model) Offset(offset int) *Model
  103. func (m *Model) Limit(start int, limit int) *Model
  104. func (m *Model) OmitEmpty() *Model
  105. func (m *Model) Page(page, limit int) (*Model)
  106. func (m *Model) Distinct() *Model
  108. // 数据库/事务切换
  109. func (m *Model) DB(db DB) *Model
  110. func (m *Model) TX(tx *TX) *Model
  112. // 主从自定义切换
  113. func (m *Model) Master() *Model
  114. func (m *Model) Slave() *Model
  116. // 数据互斥锁操作
  117. func (m *Model) LockUpdate() *Model
  118. func (m *Model) LockShared() *Model
  120. // 常用工具方法
  121. func (m *Model) Ctx(ctx context.Context) *Model
  122. func (m *Model) Clone() *Model
  123. func (m *Model) Cache(duration time.Duration, name ...string) *Model 
  124. func (m *Model) As(as string) *Model
  125. func (m *Model) Chunk(limit int, callback func(result Result, err error) bool)
  126. func (m *Model) Schema(schema string) *Model
  127. func (m *Model) Option(option int) *Model
  128. func (m *Model) Args(args ...interface{}) *Model
  129. func (m *Model) Unscoped() *Model
  130. func (m *Model) HasField(field string) (bool, error)
  131. func (m *Model) GetFieldsStr(prefix ...string) string
  132. func (m *Model) GetFieldsExStr(fields string, prefix ...string) string

相关文档