preload.go 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160
  1. package callbacks
  2. import (
  3. "reflect"
  4. "gorm.io/gorm"
  5. "gorm.io/gorm/clause"
  6. "gorm.io/gorm/schema"
  7. "gorm.io/gorm/utils"
  8. )
  9. func preload(db *gorm.DB, rel *schema.Relationship, conds []interface{}, preloads map[string][]interface{}) {
  10. var (
  11. reflectValue = db.Statement.ReflectValue
  12. tx = db.Session(&gorm.Session{NewDB: true}).Model(nil).Session(&gorm.Session{SkipHooks: db.Statement.SkipHooks})
  13. relForeignKeys []string
  14. relForeignFields []*schema.Field
  15. foreignFields []*schema.Field
  16. foreignValues [][]interface{}
  17. identityMap = map[string][]reflect.Value{}
  18. inlineConds []interface{}
  19. )
  20. db.Statement.Settings.Range(func(k, v interface{}) bool {
  21. tx.Statement.Settings.Store(k, v)
  22. return true
  23. })
  24. if rel.JoinTable != nil {
  25. var joinForeignFields, joinRelForeignFields []*schema.Field
  26. var joinForeignKeys []string
  27. for _, ref := range rel.References {
  28. if ref.OwnPrimaryKey {
  29. joinForeignKeys = append(joinForeignKeys, ref.ForeignKey.DBName)
  30. joinForeignFields = append(joinForeignFields, ref.ForeignKey)
  31. foreignFields = append(foreignFields, ref.PrimaryKey)
  32. } else if ref.PrimaryValue != "" {
  33. tx = tx.Where(clause.Eq{Column: ref.ForeignKey.DBName, Value: ref.PrimaryValue})
  34. } else {
  35. joinRelForeignFields = append(joinRelForeignFields, ref.ForeignKey)
  36. relForeignKeys = append(relForeignKeys, ref.PrimaryKey.DBName)
  37. relForeignFields = append(relForeignFields, ref.PrimaryKey)
  38. }
  39. }
  40. joinIdentityMap, joinForeignValues := schema.GetIdentityFieldValuesMap(reflectValue, foreignFields)
  41. if len(joinForeignValues) == 0 {
  42. return
  43. }
  44. joinResults := rel.JoinTable.MakeSlice().Elem()
  45. column, values := schema.ToQueryValues(clause.CurrentTable, joinForeignKeys, joinForeignValues)
  46. db.AddError(tx.Where(clause.IN{Column: column, Values: values}).Find(joinResults.Addr().Interface()).Error)
  47. // convert join identity map to relation identity map
  48. fieldValues := make([]interface{}, len(joinForeignFields))
  49. joinFieldValues := make([]interface{}, len(joinRelForeignFields))
  50. for i := 0; i < joinResults.Len(); i++ {
  51. for idx, field := range joinForeignFields {
  52. fieldValues[idx], _ = field.ValueOf(joinResults.Index(i))
  53. }
  54. for idx, field := range joinRelForeignFields {
  55. joinFieldValues[idx], _ = field.ValueOf(joinResults.Index(i))
  56. }
  57. if results, ok := joinIdentityMap[utils.ToStringKey(fieldValues...)]; ok {
  58. joinKey := utils.ToStringKey(joinFieldValues...)
  59. identityMap[joinKey] = append(identityMap[joinKey], results...)
  60. }
  61. }
  62. _, foreignValues = schema.GetIdentityFieldValuesMap(joinResults, joinRelForeignFields)
  63. } else {
  64. for _, ref := range rel.References {
  65. if ref.OwnPrimaryKey {
  66. relForeignKeys = append(relForeignKeys, ref.ForeignKey.DBName)
  67. relForeignFields = append(relForeignFields, ref.ForeignKey)
  68. foreignFields = append(foreignFields, ref.PrimaryKey)
  69. } else if ref.PrimaryValue != "" {
  70. tx = tx.Where(clause.Eq{Column: ref.ForeignKey.DBName, Value: ref.PrimaryValue})
  71. } else {
  72. relForeignKeys = append(relForeignKeys, ref.PrimaryKey.DBName)
  73. relForeignFields = append(relForeignFields, ref.PrimaryKey)
  74. foreignFields = append(foreignFields, ref.ForeignKey)
  75. }
  76. }
  77. identityMap, foreignValues = schema.GetIdentityFieldValuesMap(reflectValue, foreignFields)
  78. if len(foreignValues) == 0 {
  79. return
  80. }
  81. }
  82. // nested preload
  83. for p, pvs := range preloads {
  84. tx = tx.Preload(p, pvs...)
  85. }
  86. reflectResults := rel.FieldSchema.MakeSlice().Elem()
  87. column, values := schema.ToQueryValues(clause.CurrentTable, relForeignKeys, foreignValues)
  88. for _, cond := range conds {
  89. if fc, ok := cond.(func(*gorm.DB) *gorm.DB); ok {
  90. tx = fc(tx)
  91. } else {
  92. inlineConds = append(inlineConds, cond)
  93. }
  94. }
  95. db.AddError(tx.Where(clause.IN{Column: column, Values: values}).Find(reflectResults.Addr().Interface(), inlineConds...).Error)
  96. fieldValues := make([]interface{}, len(relForeignFields))
  97. // clean up old values before preloading
  98. switch reflectValue.Kind() {
  99. case reflect.Struct:
  100. switch rel.Type {
  101. case schema.HasMany, schema.Many2Many:
  102. rel.Field.Set(reflectValue, reflect.MakeSlice(rel.Field.IndirectFieldType, 0, 10).Interface())
  103. default:
  104. rel.Field.Set(reflectValue, reflect.New(rel.Field.FieldType).Interface())
  105. }
  106. case reflect.Slice, reflect.Array:
  107. for i := 0; i < reflectValue.Len(); i++ {
  108. switch rel.Type {
  109. case schema.HasMany, schema.Many2Many:
  110. rel.Field.Set(reflectValue.Index(i), reflect.MakeSlice(rel.Field.IndirectFieldType, 0, 10).Interface())
  111. default:
  112. rel.Field.Set(reflectValue.Index(i), reflect.New(rel.Field.FieldType).Interface())
  113. }
  114. }
  115. }
  116. for i := 0; i < reflectResults.Len(); i++ {
  117. elem := reflectResults.Index(i)
  118. for idx, field := range relForeignFields {
  119. fieldValues[idx], _ = field.ValueOf(elem)
  120. }
  121. for _, data := range identityMap[utils.ToStringKey(fieldValues...)] {
  122. reflectFieldValue := rel.Field.ReflectValueOf(data)
  123. if reflectFieldValue.Kind() == reflect.Ptr && reflectFieldValue.IsNil() {
  124. reflectFieldValue.Set(reflect.New(rel.Field.FieldType.Elem()))
  125. }
  126. reflectFieldValue = reflect.Indirect(reflectFieldValue)
  127. switch reflectFieldValue.Kind() {
  128. case reflect.Struct:
  129. rel.Field.Set(data, reflectResults.Index(i).Interface())
  130. case reflect.Slice, reflect.Array:
  131. if reflectFieldValue.Type().Elem().Kind() == reflect.Ptr {
  132. rel.Field.Set(data, reflect.Append(reflectFieldValue, elem).Interface())
  133. } else {
  134. rel.Field.Set(data, reflect.Append(reflectFieldValue, elem.Elem()).Interface())
  135. }
  136. }
  137. }
  138. }
  139. }