create.go 3.8 KB

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