associations.go 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380
  1. package callbacks
  2. import (
  3. "reflect"
  4. "strings"
  5. "gorm.io/gorm"
  6. "gorm.io/gorm/clause"
  7. "gorm.io/gorm/schema"
  8. )
  9. func SaveBeforeAssociations(db *gorm.DB) {
  10. if db.Error == nil && db.Statement.Schema != nil {
  11. selectColumns, restricted := db.Statement.SelectAndOmitColumns(true, false)
  12. // Save Belongs To associations
  13. for _, rel := range db.Statement.Schema.Relationships.BelongsTo {
  14. if v, ok := selectColumns[rel.Name]; (ok && !v) || (!ok && restricted) {
  15. continue
  16. }
  17. setupReferences := func(obj reflect.Value, elem reflect.Value) {
  18. for _, ref := range rel.References {
  19. if !ref.OwnPrimaryKey {
  20. pv, _ := ref.PrimaryKey.ValueOf(elem)
  21. db.AddError(ref.ForeignKey.Set(obj, pv))
  22. if dest, ok := db.Statement.Dest.(map[string]interface{}); ok {
  23. dest[ref.ForeignKey.DBName] = pv
  24. if _, ok := dest[rel.Name]; ok {
  25. dest[rel.Name] = elem.Interface()
  26. }
  27. }
  28. }
  29. }
  30. }
  31. switch db.Statement.ReflectValue.Kind() {
  32. case reflect.Slice, reflect.Array:
  33. var (
  34. objs []reflect.Value
  35. fieldType = rel.Field.FieldType
  36. isPtr = fieldType.Kind() == reflect.Ptr
  37. )
  38. if !isPtr {
  39. fieldType = reflect.PtrTo(fieldType)
  40. }
  41. elems := reflect.MakeSlice(reflect.SliceOf(fieldType), 0, 10)
  42. for i := 0; i < db.Statement.ReflectValue.Len(); i++ {
  43. obj := db.Statement.ReflectValue.Index(i)
  44. if reflect.Indirect(obj).Kind() == reflect.Struct {
  45. if _, zero := rel.Field.ValueOf(obj); !zero { // check belongs to relation value
  46. rv := rel.Field.ReflectValueOf(obj) // relation reflect value
  47. objs = append(objs, obj)
  48. if isPtr {
  49. elems = reflect.Append(elems, rv)
  50. } else {
  51. elems = reflect.Append(elems, rv.Addr())
  52. }
  53. }
  54. } else {
  55. break
  56. }
  57. }
  58. if elems.Len() > 0 {
  59. if saveAssociations(db, rel, elems.Interface(), selectColumns, restricted, nil) == nil {
  60. for i := 0; i < elems.Len(); i++ {
  61. setupReferences(objs[i], elems.Index(i))
  62. }
  63. }
  64. }
  65. case reflect.Struct:
  66. if _, zero := rel.Field.ValueOf(db.Statement.ReflectValue); !zero {
  67. rv := rel.Field.ReflectValueOf(db.Statement.ReflectValue) // relation reflect value
  68. if rv.Kind() != reflect.Ptr {
  69. rv = rv.Addr()
  70. }
  71. if saveAssociations(db, rel, rv.Interface(), selectColumns, restricted, nil) == nil {
  72. setupReferences(db.Statement.ReflectValue, rv)
  73. }
  74. }
  75. }
  76. }
  77. }
  78. }
  79. func SaveAfterAssociations(db *gorm.DB) {
  80. if db.Error == nil && db.Statement.Schema != nil {
  81. selectColumns, restricted := db.Statement.SelectAndOmitColumns(true, false)
  82. // Save Has One associations
  83. for _, rel := range db.Statement.Schema.Relationships.HasOne {
  84. if v, ok := selectColumns[rel.Name]; (ok && !v) || (!ok && restricted) {
  85. continue
  86. }
  87. switch db.Statement.ReflectValue.Kind() {
  88. case reflect.Slice, reflect.Array:
  89. var (
  90. fieldType = rel.Field.FieldType
  91. isPtr = fieldType.Kind() == reflect.Ptr
  92. )
  93. if !isPtr {
  94. fieldType = reflect.PtrTo(fieldType)
  95. }
  96. elems := reflect.MakeSlice(reflect.SliceOf(fieldType), 0, 10)
  97. for i := 0; i < db.Statement.ReflectValue.Len(); i++ {
  98. obj := db.Statement.ReflectValue.Index(i)
  99. if reflect.Indirect(obj).Kind() == reflect.Struct {
  100. if _, zero := rel.Field.ValueOf(obj); !zero {
  101. rv := rel.Field.ReflectValueOf(obj)
  102. if rv.Kind() != reflect.Ptr {
  103. rv = rv.Addr()
  104. }
  105. for _, ref := range rel.References {
  106. if ref.OwnPrimaryKey {
  107. fv, _ := ref.PrimaryKey.ValueOf(obj)
  108. db.AddError(ref.ForeignKey.Set(rv, fv))
  109. } else if ref.PrimaryValue != "" {
  110. db.AddError(ref.ForeignKey.Set(rv, ref.PrimaryValue))
  111. }
  112. }
  113. elems = reflect.Append(elems, rv)
  114. }
  115. }
  116. }
  117. if elems.Len() > 0 {
  118. assignmentColumns := []string{}
  119. for _, ref := range rel.References {
  120. assignmentColumns = append(assignmentColumns, ref.ForeignKey.DBName)
  121. }
  122. saveAssociations(db, rel, elems.Interface(), selectColumns, restricted, assignmentColumns)
  123. }
  124. case reflect.Struct:
  125. if _, zero := rel.Field.ValueOf(db.Statement.ReflectValue); !zero {
  126. f := rel.Field.ReflectValueOf(db.Statement.ReflectValue)
  127. if f.Kind() != reflect.Ptr {
  128. f = f.Addr()
  129. }
  130. assignmentColumns := []string{}
  131. for _, ref := range rel.References {
  132. if ref.OwnPrimaryKey {
  133. fv, _ := ref.PrimaryKey.ValueOf(db.Statement.ReflectValue)
  134. ref.ForeignKey.Set(f, fv)
  135. } else if ref.PrimaryValue != "" {
  136. ref.ForeignKey.Set(f, ref.PrimaryValue)
  137. }
  138. assignmentColumns = append(assignmentColumns, ref.ForeignKey.DBName)
  139. }
  140. saveAssociations(db, rel, f.Interface(), selectColumns, restricted, assignmentColumns)
  141. }
  142. }
  143. }
  144. // Save Has Many associations
  145. for _, rel := range db.Statement.Schema.Relationships.HasMany {
  146. if v, ok := selectColumns[rel.Name]; (ok && !v) || (!ok && restricted) {
  147. continue
  148. }
  149. fieldType := rel.Field.IndirectFieldType.Elem()
  150. isPtr := fieldType.Kind() == reflect.Ptr
  151. if !isPtr {
  152. fieldType = reflect.PtrTo(fieldType)
  153. }
  154. elems := reflect.MakeSlice(reflect.SliceOf(fieldType), 0, 10)
  155. appendToElems := func(v reflect.Value) {
  156. if _, zero := rel.Field.ValueOf(v); !zero {
  157. f := reflect.Indirect(rel.Field.ReflectValueOf(v))
  158. for i := 0; i < f.Len(); i++ {
  159. elem := f.Index(i)
  160. for _, ref := range rel.References {
  161. if ref.OwnPrimaryKey {
  162. pv, _ := ref.PrimaryKey.ValueOf(v)
  163. ref.ForeignKey.Set(elem, pv)
  164. } else if ref.PrimaryValue != "" {
  165. ref.ForeignKey.Set(elem, ref.PrimaryValue)
  166. }
  167. }
  168. if isPtr {
  169. elems = reflect.Append(elems, elem)
  170. } else {
  171. elems = reflect.Append(elems, elem.Addr())
  172. }
  173. }
  174. }
  175. }
  176. switch db.Statement.ReflectValue.Kind() {
  177. case reflect.Slice, reflect.Array:
  178. for i := 0; i < db.Statement.ReflectValue.Len(); i++ {
  179. obj := db.Statement.ReflectValue.Index(i)
  180. if reflect.Indirect(obj).Kind() == reflect.Struct {
  181. appendToElems(obj)
  182. }
  183. }
  184. case reflect.Struct:
  185. appendToElems(db.Statement.ReflectValue)
  186. }
  187. if elems.Len() > 0 {
  188. assignmentColumns := []string{}
  189. for _, ref := range rel.References {
  190. assignmentColumns = append(assignmentColumns, ref.ForeignKey.DBName)
  191. }
  192. saveAssociations(db, rel, elems.Interface(), selectColumns, restricted, assignmentColumns)
  193. }
  194. }
  195. // Save Many2Many associations
  196. for _, rel := range db.Statement.Schema.Relationships.Many2Many {
  197. if v, ok := selectColumns[rel.Name]; (ok && !v) || (!ok && restricted) {
  198. continue
  199. }
  200. fieldType := rel.Field.IndirectFieldType.Elem()
  201. isPtr := fieldType.Kind() == reflect.Ptr
  202. if !isPtr {
  203. fieldType = reflect.PtrTo(fieldType)
  204. }
  205. elems := reflect.MakeSlice(reflect.SliceOf(fieldType), 0, 10)
  206. joins := reflect.MakeSlice(reflect.SliceOf(reflect.PtrTo(rel.JoinTable.ModelType)), 0, 10)
  207. objs := []reflect.Value{}
  208. appendToJoins := func(obj reflect.Value, elem reflect.Value) {
  209. joinValue := reflect.New(rel.JoinTable.ModelType)
  210. for _, ref := range rel.References {
  211. if ref.OwnPrimaryKey {
  212. fv, _ := ref.PrimaryKey.ValueOf(obj)
  213. ref.ForeignKey.Set(joinValue, fv)
  214. } else if ref.PrimaryValue != "" {
  215. ref.ForeignKey.Set(joinValue, ref.PrimaryValue)
  216. } else {
  217. fv, _ := ref.PrimaryKey.ValueOf(elem)
  218. ref.ForeignKey.Set(joinValue, fv)
  219. }
  220. }
  221. joins = reflect.Append(joins, joinValue)
  222. }
  223. appendToElems := func(v reflect.Value) {
  224. if _, zero := rel.Field.ValueOf(v); !zero {
  225. f := reflect.Indirect(rel.Field.ReflectValueOf(v))
  226. for i := 0; i < f.Len(); i++ {
  227. elem := f.Index(i)
  228. objs = append(objs, v)
  229. if isPtr {
  230. elems = reflect.Append(elems, elem)
  231. } else {
  232. elems = reflect.Append(elems, elem.Addr())
  233. }
  234. }
  235. }
  236. }
  237. switch db.Statement.ReflectValue.Kind() {
  238. case reflect.Slice, reflect.Array:
  239. for i := 0; i < db.Statement.ReflectValue.Len(); i++ {
  240. obj := db.Statement.ReflectValue.Index(i)
  241. if reflect.Indirect(obj).Kind() == reflect.Struct {
  242. appendToElems(obj)
  243. }
  244. }
  245. case reflect.Struct:
  246. appendToElems(db.Statement.ReflectValue)
  247. }
  248. if elems.Len() > 0 {
  249. if v, ok := selectColumns[rel.Name+".*"]; !ok || v {
  250. saveAssociations(db, rel, elems.Interface(), selectColumns, restricted, nil)
  251. }
  252. for i := 0; i < elems.Len(); i++ {
  253. appendToJoins(objs[i], elems.Index(i))
  254. }
  255. }
  256. if joins.Len() > 0 {
  257. db.AddError(db.Session(&gorm.Session{NewDB: true}).Clauses(clause.OnConflict{DoNothing: true}).Session(&gorm.Session{
  258. SkipHooks: db.Statement.SkipHooks,
  259. DisableNestedTransaction: true,
  260. }).Create(joins.Interface()).Error)
  261. }
  262. }
  263. }
  264. }
  265. func onConflictOption(stmt *gorm.Statement, s *schema.Schema, selectColumns map[string]bool, restricted bool, defaultUpdatingColumns []string) clause.OnConflict {
  266. if stmt.DB.FullSaveAssociations {
  267. defaultUpdatingColumns = make([]string, 0, len(s.DBNames))
  268. for _, dbName := range s.DBNames {
  269. if v, ok := selectColumns[dbName]; (ok && !v) || (!ok && restricted) {
  270. continue
  271. }
  272. if !s.LookUpField(dbName).PrimaryKey {
  273. defaultUpdatingColumns = append(defaultUpdatingColumns, dbName)
  274. }
  275. }
  276. }
  277. if len(defaultUpdatingColumns) > 0 {
  278. var columns []clause.Column
  279. for _, dbName := range s.PrimaryFieldDBNames {
  280. columns = append(columns, clause.Column{Name: dbName})
  281. }
  282. return clause.OnConflict{
  283. Columns: columns,
  284. DoUpdates: clause.AssignmentColumns(defaultUpdatingColumns),
  285. }
  286. }
  287. return clause.OnConflict{DoNothing: true}
  288. }
  289. func saveAssociations(db *gorm.DB, rel *schema.Relationship, values interface{}, selectColumns map[string]bool, restricted bool, defaultUpdatingColumns []string) error {
  290. var (
  291. selects, omits []string
  292. onConflict = onConflictOption(db.Statement, rel.FieldSchema, selectColumns, restricted, defaultUpdatingColumns)
  293. refName = rel.Name + "."
  294. )
  295. for name, ok := range selectColumns {
  296. columnName := ""
  297. if strings.HasPrefix(name, refName) {
  298. columnName = strings.TrimPrefix(name, refName)
  299. } else if strings.HasPrefix(name, clause.Associations) {
  300. columnName = name
  301. }
  302. if columnName != "" {
  303. if ok {
  304. selects = append(selects, columnName)
  305. } else {
  306. omits = append(omits, columnName)
  307. }
  308. }
  309. }
  310. tx := db.Session(&gorm.Session{NewDB: true}).Clauses(onConflict).Session(&gorm.Session{
  311. SkipHooks: db.Statement.SkipHooks,
  312. DisableNestedTransaction: true,
  313. })
  314. db.Statement.Settings.Range(func(k, v interface{}) bool {
  315. tx.Statement.Settings.Store(k, v)
  316. return true
  317. })
  318. if len(selects) > 0 {
  319. tx = tx.Select(selects)
  320. }
  321. if len(omits) > 0 {
  322. tx = tx.Omit(omits...)
  323. }
  324. return db.AddError(tx.Create(values).Error)
  325. }