service.go 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261
  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. dbExecutor := i.DBExecutor()
  151. valueObject, ok := objects[0].(value_object.ValueObject)
  152. if !ok {
  153. return nil, fserr.New("需要传递领域对象应该为值对象")
  154. }
  155. err := database.Transaction(dbExecutor, func(tx database.Executor) error {
  156. err := callbackBeforeDBOperate(callbacks, valueObject, i, tx)
  157. if err != nil {
  158. return err
  159. }
  160. err = database.InsertEntity(dbExecutor, tableName, valueObject)
  161. if err != nil {
  162. if database.IsErrorDBRecordHasExist(err) {
  163. err = fserr.New(valueObject.DomainCNName() + "已存在")
  164. }
  165. return err
  166. }
  167. err = callbackAfterDBOperate(callbacks, valueObject, i, tx)
  168. if err != nil {
  169. return err
  170. }
  171. return nil
  172. })
  173. if err != nil {
  174. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  175. }
  176. return callbackOnSuccessReturn(callbacks, valueObject, i, nil)
  177. }
  178. }
  179. func DeleteTx(tableName string, callbacks *Callbacks[any]) binding.ServiceFunc[any] {
  180. return func(c *api.Context, params request.Params, objects []domain.Object, i *infrastructure.Infrastructure) (any, error) {
  181. dbExecutor := i.DBExecutor()
  182. valueObject, ok := objects[0].(value_object.ValueObject)
  183. if !ok {
  184. return nil, fserr.New("需要传递领域对象应该为值对象")
  185. }
  186. err := valueObject.CheckKeyFields()
  187. if err != nil {
  188. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  189. }
  190. err = database.Transaction(dbExecutor, func(tx database.Executor) error {
  191. err = callbackBeforeDBOperate(callbacks, valueObject, i, tx)
  192. if err != nil {
  193. return err
  194. }
  195. err = database.DeleteEntity(dbExecutor, tableName, valueObject)
  196. if err != nil {
  197. return err
  198. }
  199. err = callbackAfterDBOperate(callbacks, valueObject, i, tx)
  200. if err != nil {
  201. return err
  202. }
  203. return nil
  204. })
  205. if err != nil {
  206. return callbackOnErrorReturn(callbacks, valueObject, err, i, nil)
  207. }
  208. return callbackOnSuccessReturn(callbacks, valueObject, i, nil)
  209. }
  210. }