service.go 7.6 KB

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