service.go 7.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. package value_object
  2. import (
  3. "git.sxidc.com/go-framework/baize/convenient/binding"
  4. "git.sxidc.com/go-framework/baize/convenient/binding/request"
  5. "git.sxidc.com/go-framework/baize/convenient/binding/response"
  6. "git.sxidc.com/go-framework/baize/framwork/api"
  7. "git.sxidc.com/go-framework/baize/framwork/domain"
  8. "git.sxidc.com/go-framework/baize/framwork/domain/value_object"
  9. "git.sxidc.com/go-framework/baize/framwork/infrastructure"
  10. "git.sxidc.com/go-framework/baize/framwork/infrastructure/database"
  11. "git.sxidc.com/go-framework/baize/framwork/infrastructure/database/sql"
  12. "git.sxidc.com/go-framework/baize/framwork/tag/sql/sql_mapping"
  13. "git.sxidc.com/service-supports/fserr"
  14. "reflect"
  15. )
  16. func Create(tableName string, callbacks *Callbacks[any]) binding.ServiceFunc[any] {
  17. return func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (any, error) {
  18. object := objects[0]
  19. if object == nil {
  20. return nil, fserr.New("领域实体为空")
  21. }
  22. dbExecutor := i.DBExecutor()
  23. valueObject, ok := objects[0].(value_object.ValueObject)
  24. if !ok {
  25. return nil, fserr.New("需要传递领域对象应该为值对象")
  26. }
  27. err := valueObject.ForCreate()
  28. if err != nil {
  29. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  30. }
  31. err = callbackBeforeDBOperate(callbacks, valueObject, i, dbExecutor)
  32. if err != nil {
  33. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  34. }
  35. err = database.InsertEntity(dbExecutor, tableName, valueObject)
  36. if err != nil {
  37. if database.IsErrorDBRecordHasExist(err) {
  38. err = fserr.New(valueObject.DomainCNName() + "已存在")
  39. }
  40. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  41. }
  42. err = callbackAfterDBOperate(callbacks, valueObject, i, dbExecutor)
  43. if err != nil {
  44. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  45. }
  46. return callbackOnSuccessReturn(callbacks, valueObject, i, nil)
  47. }
  48. }
  49. func Delete(tableName string, callbacks *Callbacks[any]) binding.ServiceFunc[any] {
  50. return func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (any, error) {
  51. object := objects[0]
  52. if object == nil {
  53. return nil, fserr.New("领域实体为空")
  54. }
  55. dbExecutor := i.DBExecutor()
  56. valueObject, ok := objects[0].(value_object.ValueObject)
  57. if !ok {
  58. return nil, fserr.New("需要传递领域对象应该为值对象")
  59. }
  60. err := valueObject.CheckKeyFields()
  61. if err != nil {
  62. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  63. }
  64. err = callbackBeforeDBOperate(callbacks, valueObject, i, dbExecutor)
  65. if err != nil {
  66. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  67. }
  68. err = database.DeleteEntity(dbExecutor, tableName, valueObject)
  69. if err != nil {
  70. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  71. }
  72. err = callbackAfterDBOperate(callbacks, valueObject, i, dbExecutor)
  73. if err != nil {
  74. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  75. }
  76. return callbackOnSuccessReturn(callbacks, valueObject, i, nil)
  77. }
  78. }
  79. type ConditionFieldCallback func(conditions *sql.Conditions, fieldName string, columnName string, value any) (hasDeal bool)
  80. func Query[O any](tableName string, callbacks *Callbacks[response.InfosData[O]], conditionFieldCallback ConditionFieldCallback) binding.ServiceFunc[response.InfosData[O]] {
  81. return func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (response.InfosData[O], error) {
  82. errResponse := response.InfosData[O]{
  83. Infos: make([]O, 0),
  84. }
  85. if params == nil {
  86. return errResponse, fserr.New("请求参数为空")
  87. }
  88. object := objects[0]
  89. if object == nil {
  90. return errResponse, fserr.New("领域实体为空")
  91. }
  92. dbExecutor := i.DBExecutor()
  93. queryParams, ok := params.(request.Query)
  94. if !ok {
  95. return errResponse, fserr.New("请求参数不是Query接口")
  96. }
  97. valueObject, ok := objects[0].(value_object.ValueObject)
  98. if !ok {
  99. return errResponse, fserr.New("需要传递领域对象应该为值对象")
  100. }
  101. conditions := sql.NewConditions()
  102. fields, err := sql_mapping.DefaultUsage(valueObject)
  103. if err != nil {
  104. return errResponse, err
  105. }
  106. for _, field := range fields {
  107. hasDeal := false
  108. if conditionFieldCallback != nil {
  109. hasDeal = conditionFieldCallback(conditions, field.FieldName, field.ColumnName, field.Value)
  110. }
  111. if !hasDeal {
  112. fieldValue := reflect.ValueOf(field.Value)
  113. if !fieldValue.IsZero() {
  114. conditions.Equal(field.ColumnName, field.Value)
  115. }
  116. }
  117. }
  118. err = callbackBeforeDBOperate(callbacks, valueObject, i, dbExecutor)
  119. if err != nil {
  120. return callbackOnErrorReturn(callbacks, valueObject, err, i, errResponse)
  121. }
  122. results, totalCount, err := database.Query(dbExecutor, &sql.QueryExecuteParams{
  123. TableName: tableName,
  124. Conditions: conditions,
  125. PageNo: queryParams.GetPageNo(),
  126. PageSize: queryParams.GetPageSize(),
  127. })
  128. if err != nil {
  129. return callbackOnErrorReturn(callbacks, valueObject, err, i, errResponse)
  130. }
  131. err = callbackAfterDBOperate(callbacks, valueObject, i, dbExecutor)
  132. if err != nil {
  133. return callbackOnErrorReturn(callbacks, valueObject, err, i, errResponse)
  134. }
  135. infos := make([]O, 0)
  136. err = sql.ParseSqlResult(results, &infos)
  137. if err != nil {
  138. return callbackOnErrorReturn(callbacks, valueObject, err, i, errResponse)
  139. }
  140. output := response.InfosData[O]{
  141. Infos: infos,
  142. TotalCount: totalCount,
  143. PageNo: queryParams.GetPageNo(),
  144. }
  145. return callbackOnSuccessReturn(callbacks, valueObject, i, output)
  146. }
  147. }
  148. func CreateTx(tableName string, callbacks *Callbacks[any]) binding.ServiceFunc[any] {
  149. return func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (any, error) {
  150. object := objects[0]
  151. if object == nil {
  152. return nil, fserr.New("领域实体为空")
  153. }
  154. dbExecutor := i.DBExecutor()
  155. valueObject, ok := objects[0].(value_object.ValueObject)
  156. if !ok {
  157. return nil, fserr.New("需要传递领域对象应该为值对象")
  158. }
  159. err := database.Transaction(dbExecutor, func(tx database.Executor) error {
  160. err := callbackBeforeDBOperate(callbacks, valueObject, i, tx)
  161. if err != nil {
  162. return err
  163. }
  164. err = database.InsertEntity(tx, tableName, valueObject)
  165. if err != nil {
  166. if database.IsErrorDBRecordHasExist(err) {
  167. err = fserr.New(valueObject.DomainCNName() + "已存在")
  168. }
  169. return err
  170. }
  171. err = callbackAfterDBOperate(callbacks, valueObject, i, tx)
  172. if err != nil {
  173. return err
  174. }
  175. return nil
  176. })
  177. if err != nil {
  178. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  179. }
  180. return callbackOnSuccessReturn(callbacks, valueObject, i, nil)
  181. }
  182. }
  183. func DeleteTx(tableName string, callbacks *Callbacks[any]) binding.ServiceFunc[any] {
  184. return func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (any, error) {
  185. object := objects[0]
  186. if object == nil {
  187. return nil, fserr.New("领域实体为空")
  188. }
  189. dbExecutor := i.DBExecutor()
  190. valueObject, ok := objects[0].(value_object.ValueObject)
  191. if !ok {
  192. return nil, fserr.New("需要传递领域对象应该为值对象")
  193. }
  194. err := valueObject.CheckKeyFields()
  195. if err != nil {
  196. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  197. }
  198. err = database.Transaction(dbExecutor, func(tx database.Executor) error {
  199. err = callbackBeforeDBOperate(callbacks, valueObject, i, tx)
  200. if err != nil {
  201. return err
  202. }
  203. err = database.DeleteEntity(tx, tableName, valueObject)
  204. if err != nil {
  205. return err
  206. }
  207. err = callbackAfterDBOperate(callbacks, valueObject, i, tx)
  208. if err != nil {
  209. return err
  210. }
  211. return nil
  212. })
  213. if err != nil {
  214. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  215. }
  216. return callbackOnSuccessReturn(callbacks, valueObject, i, nil)
  217. }
  218. }