delete.go 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
  1. package callbacks
  2. import (
  3. "reflect"
  4. "strings"
  5. "gorm.io/gorm"
  6. "gorm.io/gorm/clause"
  7. "gorm.io/gorm/schema"
  8. "gorm.io/gorm/utils"
  9. )
  10. func BeforeDelete(db *gorm.DB) {
  11. if db.Error == nil && db.Statement.Schema != nil && !db.Statement.SkipHooks && db.Statement.Schema.BeforeDelete {
  12. callMethod(db, func(value interface{}, tx *gorm.DB) bool {
  13. if i, ok := value.(BeforeDeleteInterface); ok {
  14. db.AddError(i.BeforeDelete(tx))
  15. return true
  16. }
  17. return false
  18. })
  19. }
  20. }
  21. func DeleteBeforeAssociations(db *gorm.DB) {
  22. if db.Error == nil && db.Statement.Schema != nil {
  23. selectColumns, restricted := db.Statement.SelectAndOmitColumns(true, false)
  24. if !restricted {
  25. return
  26. }
  27. for column, v := range selectColumns {
  28. if !v {
  29. continue
  30. }
  31. rel, ok := db.Statement.Schema.Relationships.Relations[column]
  32. if !ok {
  33. continue
  34. }
  35. switch rel.Type {
  36. case schema.HasOne, schema.HasMany:
  37. queryConds := rel.ToQueryConditions(db.Statement.Context, db.Statement.ReflectValue)
  38. modelValue := reflect.New(rel.FieldSchema.ModelType).Interface()
  39. tx := db.Session(&gorm.Session{NewDB: true}).Model(modelValue)
  40. withoutConditions := false
  41. if db.Statement.Unscoped {
  42. tx = tx.Unscoped()
  43. }
  44. if len(db.Statement.Selects) > 0 {
  45. selects := make([]string, 0, len(db.Statement.Selects))
  46. for _, s := range db.Statement.Selects {
  47. if s == clause.Associations {
  48. selects = append(selects, s)
  49. } else if columnPrefix := column + "."; strings.HasPrefix(s, columnPrefix) {
  50. selects = append(selects, strings.TrimPrefix(s, columnPrefix))
  51. }
  52. }
  53. if len(selects) > 0 {
  54. tx = tx.Select(selects)
  55. }
  56. }
  57. for _, cond := range queryConds {
  58. if c, ok := cond.(clause.IN); ok && len(c.Values) == 0 {
  59. withoutConditions = true
  60. break
  61. }
  62. }
  63. if !withoutConditions && db.AddError(tx.Clauses(clause.Where{Exprs: queryConds}).Delete(modelValue).Error) != nil {
  64. return
  65. }
  66. case schema.Many2Many:
  67. var (
  68. queryConds = make([]clause.Expression, 0, len(rel.References))
  69. foreignFields = make([]*schema.Field, 0, len(rel.References))
  70. relForeignKeys = make([]string, 0, len(rel.References))
  71. modelValue = reflect.New(rel.JoinTable.ModelType).Interface()
  72. table = rel.JoinTable.Table
  73. tx = db.Session(&gorm.Session{NewDB: true}).Model(modelValue).Table(table)
  74. )
  75. for _, ref := range rel.References {
  76. if ref.OwnPrimaryKey {
  77. foreignFields = append(foreignFields, ref.PrimaryKey)
  78. relForeignKeys = append(relForeignKeys, ref.ForeignKey.DBName)
  79. } else if ref.PrimaryValue != "" {
  80. queryConds = append(queryConds, clause.Eq{
  81. Column: clause.Column{Table: rel.JoinTable.Table, Name: ref.ForeignKey.DBName},
  82. Value: ref.PrimaryValue,
  83. })
  84. }
  85. }
  86. _, foreignValues := schema.GetIdentityFieldValuesMap(db.Statement.Context, db.Statement.ReflectValue, foreignFields)
  87. column, values := schema.ToQueryValues(table, relForeignKeys, foreignValues)
  88. queryConds = append(queryConds, clause.IN{Column: column, Values: values})
  89. if db.AddError(tx.Clauses(clause.Where{Exprs: queryConds}).Delete(modelValue).Error) != nil {
  90. return
  91. }
  92. }
  93. }
  94. }
  95. }
  96. func Delete(config *Config) func(db *gorm.DB) {
  97. supportReturning := utils.Contains(config.DeleteClauses, "RETURNING")
  98. return func(db *gorm.DB) {
  99. if db.Error != nil {
  100. return
  101. }
  102. if db.Statement.Schema != nil {
  103. for _, c := range db.Statement.Schema.DeleteClauses {
  104. db.Statement.AddClause(c)
  105. }
  106. }
  107. if db.Statement.SQL.Len() == 0 {
  108. db.Statement.SQL.Grow(100)
  109. db.Statement.AddClauseIfNotExists(clause.Delete{})
  110. if db.Statement.Schema != nil {
  111. _, queryValues := schema.GetIdentityFieldValuesMap(db.Statement.Context, db.Statement.ReflectValue, db.Statement.Schema.PrimaryFields)
  112. column, values := schema.ToQueryValues(db.Statement.Table, db.Statement.Schema.PrimaryFieldDBNames, queryValues)
  113. if len(values) > 0 {
  114. db.Statement.AddClause(clause.Where{Exprs: []clause.Expression{clause.IN{Column: column, Values: values}}})
  115. }
  116. if db.Statement.ReflectValue.CanAddr() && db.Statement.Dest != db.Statement.Model && db.Statement.Model != nil {
  117. _, queryValues = schema.GetIdentityFieldValuesMap(db.Statement.Context, reflect.ValueOf(db.Statement.Model), db.Statement.Schema.PrimaryFields)
  118. column, values = schema.ToQueryValues(db.Statement.Table, db.Statement.Schema.PrimaryFieldDBNames, queryValues)
  119. if len(values) > 0 {
  120. db.Statement.AddClause(clause.Where{Exprs: []clause.Expression{clause.IN{Column: column, Values: values}}})
  121. }
  122. }
  123. }
  124. db.Statement.AddClauseIfNotExists(clause.From{})
  125. db.Statement.Build(db.Statement.BuildClauses...)
  126. }
  127. checkMissingWhereConditions(db)
  128. if !db.DryRun && db.Error == nil {
  129. ok, mode := hasReturning(db, supportReturning)
  130. if !ok {
  131. result, err := db.Statement.ConnPool.ExecContext(db.Statement.Context, db.Statement.SQL.String(), db.Statement.Vars...)
  132. if db.AddError(err) == nil {
  133. db.RowsAffected, _ = result.RowsAffected()
  134. }
  135. return
  136. }
  137. if rows, err := db.Statement.ConnPool.QueryContext(db.Statement.Context, db.Statement.SQL.String(), db.Statement.Vars...); db.AddError(err) == nil {
  138. gorm.Scan(rows, db, mode)
  139. db.AddError(rows.Close())
  140. }
  141. }
  142. }
  143. }
  144. func AfterDelete(db *gorm.DB) {
  145. if db.Error == nil && db.Statement.Schema != nil && !db.Statement.SkipHooks && db.Statement.Schema.AfterDelete {
  146. callMethod(db, func(value interface{}, tx *gorm.DB) bool {
  147. if i, ok := value.(AfterDeleteInterface); ok {
  148. db.AddError(i.AfterDelete(tx))
  149. return true
  150. }
  151. return false
  152. })
  153. }
  154. }