update.go 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261
  1. package callbacks
  2. import (
  3. "reflect"
  4. "sort"
  5. "gorm.io/gorm"
  6. "gorm.io/gorm/clause"
  7. "gorm.io/gorm/schema"
  8. )
  9. func SetupUpdateReflectValue(db *gorm.DB) {
  10. if db.Error == nil && db.Statement.Schema != nil {
  11. if !db.Statement.ReflectValue.CanAddr() || db.Statement.Model != db.Statement.Dest {
  12. db.Statement.ReflectValue = reflect.ValueOf(db.Statement.Model)
  13. for db.Statement.ReflectValue.Kind() == reflect.Ptr {
  14. db.Statement.ReflectValue = db.Statement.ReflectValue.Elem()
  15. }
  16. if dest, ok := db.Statement.Dest.(map[string]interface{}); ok {
  17. for _, rel := range db.Statement.Schema.Relationships.BelongsTo {
  18. if _, ok := dest[rel.Name]; ok {
  19. rel.Field.Set(db.Statement.ReflectValue, dest[rel.Name])
  20. }
  21. }
  22. }
  23. }
  24. }
  25. }
  26. func BeforeUpdate(db *gorm.DB) {
  27. if db.Error == nil && db.Statement.Schema != nil && !db.Statement.SkipHooks && (db.Statement.Schema.BeforeSave || db.Statement.Schema.BeforeUpdate) {
  28. callMethod(db, func(value interface{}, tx *gorm.DB) (called bool) {
  29. if db.Statement.Schema.BeforeSave {
  30. if i, ok := value.(BeforeSaveInterface); ok {
  31. called = true
  32. db.AddError(i.BeforeSave(tx))
  33. }
  34. }
  35. if db.Statement.Schema.BeforeUpdate {
  36. if i, ok := value.(BeforeUpdateInterface); ok {
  37. called = true
  38. db.AddError(i.BeforeUpdate(tx))
  39. }
  40. }
  41. return called
  42. })
  43. }
  44. }
  45. func Update(db *gorm.DB) {
  46. if db.Error == nil {
  47. if db.Statement.Schema != nil && !db.Statement.Unscoped {
  48. for _, c := range db.Statement.Schema.UpdateClauses {
  49. db.Statement.AddClause(c)
  50. }
  51. }
  52. if db.Statement.SQL.String() == "" {
  53. db.Statement.SQL.Grow(180)
  54. db.Statement.AddClauseIfNotExists(clause.Update{})
  55. if set := ConvertToAssignments(db.Statement); len(set) != 0 {
  56. db.Statement.AddClause(set)
  57. } else {
  58. return
  59. }
  60. db.Statement.Build(db.Statement.BuildClauses...)
  61. }
  62. if _, ok := db.Statement.Clauses["WHERE"]; !db.AllowGlobalUpdate && !ok {
  63. db.AddError(gorm.ErrMissingWhereClause)
  64. return
  65. }
  66. if !db.DryRun && db.Error == nil {
  67. result, err := db.Statement.ConnPool.ExecContext(db.Statement.Context, db.Statement.SQL.String(), db.Statement.Vars...)
  68. if err == nil {
  69. db.RowsAffected, _ = result.RowsAffected()
  70. } else {
  71. db.AddError(err)
  72. }
  73. }
  74. }
  75. }
  76. func AfterUpdate(db *gorm.DB) {
  77. if db.Error == nil && db.Statement.Schema != nil && !db.Statement.SkipHooks && (db.Statement.Schema.AfterSave || db.Statement.Schema.AfterUpdate) {
  78. callMethod(db, func(value interface{}, tx *gorm.DB) (called bool) {
  79. if db.Statement.Schema.AfterSave {
  80. if i, ok := value.(AfterSaveInterface); ok {
  81. called = true
  82. db.AddError(i.AfterSave(tx))
  83. }
  84. }
  85. if db.Statement.Schema.AfterUpdate {
  86. if i, ok := value.(AfterUpdateInterface); ok {
  87. called = true
  88. db.AddError(i.AfterUpdate(tx))
  89. }
  90. }
  91. return called
  92. })
  93. }
  94. }
  95. // ConvertToAssignments convert to update assignments
  96. func ConvertToAssignments(stmt *gorm.Statement) (set clause.Set) {
  97. var (
  98. selectColumns, restricted = stmt.SelectAndOmitColumns(false, true)
  99. assignValue func(field *schema.Field, value interface{})
  100. )
  101. switch stmt.ReflectValue.Kind() {
  102. case reflect.Slice, reflect.Array:
  103. assignValue = func(field *schema.Field, value interface{}) {
  104. for i := 0; i < stmt.ReflectValue.Len(); i++ {
  105. field.Set(stmt.ReflectValue.Index(i), value)
  106. }
  107. }
  108. case reflect.Struct:
  109. assignValue = func(field *schema.Field, value interface{}) {
  110. if stmt.ReflectValue.CanAddr() {
  111. field.Set(stmt.ReflectValue, value)
  112. }
  113. }
  114. default:
  115. assignValue = func(field *schema.Field, value interface{}) {
  116. }
  117. }
  118. updatingValue := reflect.ValueOf(stmt.Dest)
  119. for updatingValue.Kind() == reflect.Ptr {
  120. updatingValue = updatingValue.Elem()
  121. }
  122. if !updatingValue.CanAddr() || stmt.Dest != stmt.Model {
  123. switch stmt.ReflectValue.Kind() {
  124. case reflect.Slice, reflect.Array:
  125. var primaryKeyExprs []clause.Expression
  126. for i := 0; i < stmt.ReflectValue.Len(); i++ {
  127. var exprs = make([]clause.Expression, len(stmt.Schema.PrimaryFields))
  128. var notZero bool
  129. for idx, field := range stmt.Schema.PrimaryFields {
  130. value, isZero := field.ValueOf(stmt.ReflectValue.Index(i))
  131. exprs[idx] = clause.Eq{Column: field.DBName, Value: value}
  132. notZero = notZero || !isZero
  133. }
  134. if notZero {
  135. primaryKeyExprs = append(primaryKeyExprs, clause.And(exprs...))
  136. }
  137. }
  138. stmt.AddClause(clause.Where{Exprs: []clause.Expression{clause.Or(primaryKeyExprs...)}})
  139. case reflect.Struct:
  140. for _, field := range stmt.Schema.PrimaryFields {
  141. if value, isZero := field.ValueOf(stmt.ReflectValue); !isZero {
  142. stmt.AddClause(clause.Where{Exprs: []clause.Expression{clause.Eq{Column: field.DBName, Value: value}}})
  143. }
  144. }
  145. }
  146. }
  147. switch value := updatingValue.Interface().(type) {
  148. case map[string]interface{}:
  149. set = make([]clause.Assignment, 0, len(value))
  150. keys := make([]string, 0, len(value))
  151. for k := range value {
  152. keys = append(keys, k)
  153. }
  154. sort.Strings(keys)
  155. for _, k := range keys {
  156. kv := value[k]
  157. if _, ok := kv.(*gorm.DB); ok {
  158. kv = []interface{}{kv}
  159. }
  160. if stmt.Schema != nil {
  161. if field := stmt.Schema.LookUpField(k); field != nil {
  162. if field.DBName != "" {
  163. if v, ok := selectColumns[field.DBName]; (ok && v) || (!ok && !restricted) {
  164. set = append(set, clause.Assignment{Column: clause.Column{Name: field.DBName}, Value: kv})
  165. assignValue(field, value[k])
  166. }
  167. } else if v, ok := selectColumns[field.Name]; (ok && v) || (!ok && !restricted) {
  168. assignValue(field, value[k])
  169. }
  170. continue
  171. }
  172. }
  173. if v, ok := selectColumns[k]; (ok && v) || (!ok && !restricted) {
  174. set = append(set, clause.Assignment{Column: clause.Column{Name: k}, Value: kv})
  175. }
  176. }
  177. if !stmt.SkipHooks && stmt.Schema != nil {
  178. for _, dbName := range stmt.Schema.DBNames {
  179. field := stmt.Schema.LookUpField(dbName)
  180. if field.AutoUpdateTime > 0 && value[field.Name] == nil && value[field.DBName] == nil {
  181. if v, ok := selectColumns[field.DBName]; (ok && v) || !ok {
  182. now := stmt.DB.NowFunc()
  183. assignValue(field, now)
  184. if field.AutoUpdateTime == schema.UnixNanosecond {
  185. set = append(set, clause.Assignment{Column: clause.Column{Name: field.DBName}, Value: now.UnixNano()})
  186. } else if field.AutoUpdateTime == schema.UnixMillisecond {
  187. set = append(set, clause.Assignment{Column: clause.Column{Name: field.DBName}, Value: now.UnixNano() / 1e6})
  188. } else if field.GORMDataType == schema.Time {
  189. set = append(set, clause.Assignment{Column: clause.Column{Name: field.DBName}, Value: now})
  190. } else {
  191. set = append(set, clause.Assignment{Column: clause.Column{Name: field.DBName}, Value: now.Unix()})
  192. }
  193. }
  194. }
  195. }
  196. }
  197. default:
  198. switch updatingValue.Kind() {
  199. case reflect.Struct:
  200. set = make([]clause.Assignment, 0, len(stmt.Schema.FieldsByDBName))
  201. for _, dbName := range stmt.Schema.DBNames {
  202. field := stmt.Schema.LookUpField(dbName)
  203. if !field.PrimaryKey || (!updatingValue.CanAddr() || stmt.Dest != stmt.Model) {
  204. if v, ok := selectColumns[field.DBName]; (ok && v) || (!ok && (!restricted || (!stmt.SkipHooks && field.AutoUpdateTime > 0))) {
  205. value, isZero := field.ValueOf(updatingValue)
  206. if !stmt.SkipHooks && field.AutoUpdateTime > 0 {
  207. if field.AutoUpdateTime == schema.UnixNanosecond {
  208. value = stmt.DB.NowFunc().UnixNano()
  209. } else if field.AutoUpdateTime == schema.UnixMillisecond {
  210. value = stmt.DB.NowFunc().UnixNano() / 1e6
  211. } else if field.GORMDataType == schema.Time {
  212. value = stmt.DB.NowFunc()
  213. } else {
  214. value = stmt.DB.NowFunc().Unix()
  215. }
  216. isZero = false
  217. }
  218. if ok || !isZero {
  219. set = append(set, clause.Assignment{Column: clause.Column{Name: field.DBName}, Value: value})
  220. assignValue(field, value)
  221. }
  222. }
  223. } else {
  224. if value, isZero := field.ValueOf(updatingValue); !isZero {
  225. stmt.AddClause(clause.Where{Exprs: []clause.Expression{clause.Eq{Column: field.DBName, Value: value}}})
  226. }
  227. }
  228. }
  229. default:
  230. stmt.AddError(gorm.ErrInvalidData)
  231. }
  232. }
  233. return
  234. }