create.go 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  1. package callbacks
  2. import (
  3. "reflect"
  4. "github.com/jinzhu/gorm"
  5. "github.com/jinzhu/gorm/clause"
  6. )
  7. func BeforeCreate(db *gorm.DB) {
  8. // before save
  9. // before create
  10. }
  11. func SaveBeforeAssociations(db *gorm.DB) {
  12. }
  13. func Create(db *gorm.DB) {
  14. db.Statement.AddClauseIfNotExists(clause.Insert{
  15. Table: clause.Table{Name: db.Statement.Table},
  16. })
  17. db.Statement.AddClause(ConvertToCreateValues(db.Statement))
  18. db.Statement.Build("INSERT", "VALUES", "ON_CONFLICT")
  19. result, err := db.DB.ExecContext(db.Context, db.Statement.SQL.String(), db.Statement.Vars...)
  20. if err == nil {
  21. if db.Statement.Schema != nil {
  22. if insertID, err := result.LastInsertId(); err == nil {
  23. switch db.Statement.ReflectValue.Kind() {
  24. case reflect.Slice, reflect.Array:
  25. for i := db.Statement.ReflectValue.Len() - 1; i >= 0; i-- {
  26. db.Statement.Schema.PrioritizedPrimaryField.Set(db.Statement.ReflectValue.Index(i), insertID)
  27. insertID--
  28. }
  29. case reflect.Struct:
  30. db.Statement.Schema.PrioritizedPrimaryField.Set(db.Statement.ReflectValue, insertID)
  31. }
  32. }
  33. }
  34. db.RowsAffected, _ = result.RowsAffected()
  35. } else {
  36. db.AddError(err)
  37. }
  38. }
  39. func SaveAfterAssociations(db *gorm.DB) {
  40. }
  41. func AfterCreate(db *gorm.DB) {
  42. // after save
  43. // after create
  44. }
  45. // ConvertToCreateValues convert to create values
  46. func ConvertToCreateValues(stmt *gorm.Statement) clause.Values {
  47. switch value := stmt.Dest.(type) {
  48. case map[string]interface{}:
  49. return ConvertMapToValues(stmt, value)
  50. case []map[string]interface{}:
  51. return ConvertSliceOfMapToValues(stmt, value)
  52. default:
  53. var (
  54. values = clause.Values{}
  55. selectColumns, restricted = SelectAndOmitColumns(stmt)
  56. curTime = stmt.DB.NowFunc()
  57. isZero = false
  58. )
  59. for _, db := range stmt.Schema.DBNames {
  60. if stmt.Schema.FieldsWithDefaultDBValue[db] == nil {
  61. if v, ok := selectColumns[db]; (ok && v) || (!ok && !restricted) {
  62. values.Columns = append(values.Columns, clause.Column{Name: db})
  63. }
  64. }
  65. }
  66. switch stmt.ReflectValue.Kind() {
  67. case reflect.Slice, reflect.Array:
  68. values.Values = make([][]interface{}, stmt.ReflectValue.Len())
  69. defaultValueFieldsHavingValue := map[string][]interface{}{}
  70. for i := 0; i < stmt.ReflectValue.Len(); i++ {
  71. rv := reflect.Indirect(stmt.ReflectValue.Index(i))
  72. values.Values[i] = make([]interface{}, len(values.Columns))
  73. for idx, column := range values.Columns {
  74. field := stmt.Schema.FieldsByDBName[column.Name]
  75. if values.Values[i][idx], isZero = field.ValueOf(rv); isZero {
  76. if field.DefaultValueInterface != nil {
  77. values.Values[i][idx] = field.DefaultValueInterface
  78. field.Set(rv, field.DefaultValueInterface)
  79. } else if field.AutoCreateTime > 0 || field.AutoUpdateTime > 0 {
  80. field.Set(rv, curTime)
  81. values.Values[i][idx], _ = field.ValueOf(rv)
  82. }
  83. }
  84. }
  85. for db, field := range stmt.Schema.FieldsWithDefaultDBValue {
  86. if v, ok := selectColumns[db]; (ok && v) || (!ok && !restricted) {
  87. if v, isZero := field.ValueOf(rv); !isZero {
  88. if len(defaultValueFieldsHavingValue[db]) == 0 {
  89. defaultValueFieldsHavingValue[db] = make([]interface{}, stmt.ReflectValue.Len())
  90. }
  91. defaultValueFieldsHavingValue[db][i] = v
  92. }
  93. }
  94. }
  95. }
  96. for db, vs := range defaultValueFieldsHavingValue {
  97. values.Columns = append(values.Columns, clause.Column{Name: db})
  98. for idx := range values.Values {
  99. if vs[idx] == nil {
  100. values.Values[idx] = append(values.Values[idx], clause.Expr{SQL: "DEFAULT"})
  101. } else {
  102. values.Values[idx] = append(values.Values[idx], vs[idx])
  103. }
  104. }
  105. }
  106. case reflect.Struct:
  107. values.Values = [][]interface{}{make([]interface{}, len(values.Columns))}
  108. for idx, column := range values.Columns {
  109. field := stmt.Schema.FieldsByDBName[column.Name]
  110. if values.Values[0][idx], isZero = field.ValueOf(stmt.ReflectValue); isZero {
  111. if field.DefaultValueInterface != nil {
  112. values.Values[0][idx] = field.DefaultValueInterface
  113. field.Set(stmt.ReflectValue, field.DefaultValueInterface)
  114. } else if field.AutoCreateTime > 0 || field.AutoUpdateTime > 0 {
  115. field.Set(stmt.ReflectValue, curTime)
  116. values.Values[0][idx], _ = field.ValueOf(stmt.ReflectValue)
  117. }
  118. }
  119. }
  120. for db, field := range stmt.Schema.FieldsWithDefaultDBValue {
  121. if v, ok := selectColumns[db]; (ok && v) || (!ok && !restricted) {
  122. if v, isZero := field.ValueOf(stmt.ReflectValue); !isZero {
  123. values.Columns = append(values.Columns, clause.Column{Name: db})
  124. values.Values[0] = append(values.Values[0], v)
  125. }
  126. }
  127. }
  128. }
  129. return values
  130. }
  131. }