associations.go 11 KB

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