callback_create.go 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197
  1. package gorm
  2. import (
  3. "fmt"
  4. "strings"
  5. )
  6. // Define callbacks for creating
  7. func init() {
  8. DefaultCallback.Create().Register("gorm:begin_transaction", beginTransactionCallback)
  9. DefaultCallback.Create().Register("gorm:before_create", beforeCreateCallback)
  10. DefaultCallback.Create().Register("gorm:save_before_associations", saveBeforeAssociationsCallback)
  11. DefaultCallback.Create().Register("gorm:update_time_stamp", updateTimeStampForCreateCallback)
  12. DefaultCallback.Create().Register("gorm:create", createCallback)
  13. DefaultCallback.Create().Register("gorm:force_reload_after_create", forceReloadAfterCreateCallback)
  14. DefaultCallback.Create().Register("gorm:save_after_associations", saveAfterAssociationsCallback)
  15. DefaultCallback.Create().Register("gorm:after_create", afterCreateCallback)
  16. DefaultCallback.Create().Register("gorm:commit_or_rollback_transaction", commitOrRollbackTransactionCallback)
  17. }
  18. // beforeCreateCallback will invoke `BeforeSave`, `BeforeCreate` method before creating
  19. func beforeCreateCallback(scope *Scope) {
  20. if !scope.HasError() {
  21. scope.CallMethod("BeforeSave")
  22. }
  23. if !scope.HasError() {
  24. scope.CallMethod("BeforeCreate")
  25. }
  26. }
  27. // updateTimeStampForCreateCallback will set `CreatedAt`, `UpdatedAt` when creating
  28. func updateTimeStampForCreateCallback(scope *Scope) {
  29. if !scope.HasError() {
  30. now := scope.db.nowFunc()
  31. if createdAtField, ok := scope.FieldByName("CreatedAt"); ok {
  32. if createdAtField.IsBlank {
  33. createdAtField.Set(now)
  34. }
  35. }
  36. if updatedAtField, ok := scope.FieldByName("UpdatedAt"); ok {
  37. if updatedAtField.IsBlank {
  38. updatedAtField.Set(now)
  39. }
  40. }
  41. }
  42. }
  43. // createCallback the callback used to insert data into database
  44. func createCallback(scope *Scope) {
  45. if !scope.HasError() {
  46. defer scope.trace(NowFunc())
  47. var (
  48. columns, placeholders []string
  49. blankColumnsWithDefaultValue []string
  50. )
  51. for _, field := range scope.Fields() {
  52. if scope.changeableField(field) {
  53. if field.IsNormal && !field.IsIgnored {
  54. if field.IsBlank && field.HasDefaultValue {
  55. blankColumnsWithDefaultValue = append(blankColumnsWithDefaultValue, scope.Quote(field.DBName))
  56. scope.InstanceSet("gorm:blank_columns_with_default_value", blankColumnsWithDefaultValue)
  57. } else if !field.IsPrimaryKey || !field.IsBlank {
  58. columns = append(columns, scope.Quote(field.DBName))
  59. placeholders = append(placeholders, scope.AddToVars(field.Field.Interface()))
  60. }
  61. } else if field.Relationship != nil && field.Relationship.Kind == "belongs_to" {
  62. for _, foreignKey := range field.Relationship.ForeignDBNames {
  63. if foreignField, ok := scope.FieldByName(foreignKey); ok && !scope.changeableField(foreignField) {
  64. columns = append(columns, scope.Quote(foreignField.DBName))
  65. placeholders = append(placeholders, scope.AddToVars(foreignField.Field.Interface()))
  66. }
  67. }
  68. }
  69. }
  70. }
  71. var (
  72. returningColumn = "*"
  73. quotedTableName = scope.QuotedTableName()
  74. primaryField = scope.PrimaryField()
  75. extraOption string
  76. insertModifier string
  77. )
  78. if str, ok := scope.Get("gorm:insert_option"); ok {
  79. extraOption = fmt.Sprint(str)
  80. }
  81. if str, ok := scope.Get("gorm:insert_modifier"); ok {
  82. insertModifier = strings.ToUpper(fmt.Sprint(str))
  83. if insertModifier == "INTO" {
  84. insertModifier = ""
  85. }
  86. }
  87. if primaryField != nil {
  88. returningColumn = scope.Quote(primaryField.DBName)
  89. }
  90. lastInsertIDOutputInterstitial := scope.Dialect().LastInsertIDOutputInterstitial(quotedTableName, returningColumn, columns)
  91. var lastInsertIDReturningSuffix string
  92. if lastInsertIDOutputInterstitial == "" {
  93. lastInsertIDReturningSuffix = scope.Dialect().LastInsertIDReturningSuffix(quotedTableName, returningColumn)
  94. }
  95. if len(columns) == 0 {
  96. scope.Raw(fmt.Sprintf(
  97. "INSERT%v INTO %v %v%v%v",
  98. addExtraSpaceIfExist(insertModifier),
  99. quotedTableName,
  100. scope.Dialect().DefaultValueStr(),
  101. addExtraSpaceIfExist(extraOption),
  102. addExtraSpaceIfExist(lastInsertIDReturningSuffix),
  103. ))
  104. } else {
  105. scope.Raw(fmt.Sprintf(
  106. "INSERT%v INTO %v (%v)%v VALUES (%v)%v%v",
  107. addExtraSpaceIfExist(insertModifier),
  108. scope.QuotedTableName(),
  109. strings.Join(columns, ","),
  110. addExtraSpaceIfExist(lastInsertIDOutputInterstitial),
  111. strings.Join(placeholders, ","),
  112. addExtraSpaceIfExist(extraOption),
  113. addExtraSpaceIfExist(lastInsertIDReturningSuffix),
  114. ))
  115. }
  116. // execute create sql: no primaryField
  117. if primaryField == nil {
  118. if result, err := scope.SQLDB().Exec(scope.SQL, scope.SQLVars...); scope.Err(err) == nil {
  119. // set rows affected count
  120. scope.db.RowsAffected, _ = result.RowsAffected()
  121. // set primary value to primary field
  122. if primaryField != nil && primaryField.IsBlank {
  123. if primaryValue, err := result.LastInsertId(); scope.Err(err) == nil {
  124. scope.Err(primaryField.Set(primaryValue))
  125. }
  126. }
  127. }
  128. return
  129. }
  130. // execute create sql: lastInsertID implemention for majority of dialects
  131. if lastInsertIDReturningSuffix == "" && lastInsertIDOutputInterstitial == "" {
  132. if result, err := scope.SQLDB().Exec(scope.SQL, scope.SQLVars...); scope.Err(err) == nil {
  133. // set rows affected count
  134. scope.db.RowsAffected, _ = result.RowsAffected()
  135. // set primary value to primary field
  136. if primaryField != nil && primaryField.IsBlank {
  137. if primaryValue, err := result.LastInsertId(); scope.Err(err) == nil {
  138. scope.Err(primaryField.Set(primaryValue))
  139. }
  140. }
  141. }
  142. return
  143. }
  144. // execute create sql: dialects with additional lastInsertID requirements (currently postgres & mssql)
  145. if primaryField.Field.CanAddr() {
  146. if err := scope.SQLDB().QueryRow(scope.SQL, scope.SQLVars...).Scan(primaryField.Field.Addr().Interface()); scope.Err(err) == nil {
  147. primaryField.IsBlank = false
  148. scope.db.RowsAffected = 1
  149. }
  150. } else {
  151. scope.Err(ErrUnaddressable)
  152. }
  153. return
  154. }
  155. }
  156. // forceReloadAfterCreateCallback will reload columns that having default value, and set it back to current object
  157. func forceReloadAfterCreateCallback(scope *Scope) {
  158. if blankColumnsWithDefaultValue, ok := scope.InstanceGet("gorm:blank_columns_with_default_value"); ok {
  159. db := scope.DB().New().Table(scope.TableName()).Select(blankColumnsWithDefaultValue.([]string))
  160. for _, field := range scope.Fields() {
  161. if field.IsPrimaryKey && !field.IsBlank {
  162. db = db.Where(fmt.Sprintf("%v = ?", field.DBName), field.Field.Interface())
  163. }
  164. }
  165. db.Scan(scope.Value)
  166. }
  167. }
  168. // afterCreateCallback will invoke `AfterCreate`, `AfterSave` method after creating
  169. func afterCreateCallback(scope *Scope) {
  170. if !scope.HasError() {
  171. scope.CallMethod("AfterCreate")
  172. }
  173. if !scope.HasError() {
  174. scope.CallMethod("AfterSave")
  175. }
  176. }