client.go 2.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. package client
  2. import (
  3. "strings"
  4. "time"
  5. )
  6. const (
  7. columnCreateUserID = "create_user_id"
  8. columnLastUpdateUserID = "last_update_user_id"
  9. columnCreatedTime = "created_time"
  10. columnLastEventTime = "last_event_time"
  11. )
  12. func GetCreateUserID(dataMap map[string]any) string {
  13. return dataMap[columnCreateUserID].(string)
  14. }
  15. func GetLastUpdateUserID(dataMap map[string]any) string {
  16. return dataMap[columnLastUpdateUserID].(string)
  17. }
  18. func FormatCreatedTime(dataMap map[string]any, format string) string {
  19. return dataMap[columnCreatedTime].(time.Time).Format(format)
  20. }
  21. func FormatLastEventTime(dataMap map[string]any, format string) string {
  22. return dataMap[columnLastEventTime].(time.Time).Format(format)
  23. }
  24. func IsErrorDBRecordHasExist(err error) bool {
  25. return strings.Contains(err.Error(), "记录已存在")
  26. }
  27. func IsErrorDBRecordNotExist(err error) bool {
  28. return strings.Contains(err.Error(), "记录不存在")
  29. }
  30. type Client interface {
  31. AutoMigrate(request *AutoMigrateRequest) error
  32. Transaction(txFunc TransactionFunc) error
  33. Insert(request *InsertRequest) (string, error)
  34. InsertBatch(request *InsertBatchRequest) (string, error)
  35. Delete(request *DeleteRequest) (string, error)
  36. DeleteBatch(request *DeleteBatchRequest) (string, error)
  37. Update(request *UpdateRequest) (string, error)
  38. Replay(request *ReplayRequest) (string, error)
  39. QueryByWhereAndOrderBy(request *QueryByWhereAndOrderByRequest) (string, []map[string]any, int64, error)
  40. CommonQuery(request *CommonQueryRequest) (string, []map[string]any, int64, error)
  41. QueryOnlyByWhereAndOrderBy(request *QueryByWhereAndOrderByRequest) (string, []map[string]any, error)
  42. CommonQueryOnly(request *CommonQueryRequest) (string, []map[string]any, error)
  43. QueryByKeys(request *QueryByKeysRequest) (string, map[string]any, error)
  44. CountWhere(request *CountWhereRequest) (string, int64, error)
  45. CommonCount(request *CommonCountRequest) (string, int64, error)
  46. EventQueryByKeys(request *EventQueryByKeysRequest) (string, []EventInfo, int64, error)
  47. CommonEventQuery(request *CommonEventQueryRequest) (string, []EventInfo, int64, error)
  48. EventQueryOnlyByKeys(request *EventQueryByKeysRequest) (string, []EventInfo, error)
  49. CommonEventQueryOnly(request *CommonEventQueryRequest) (string, []EventInfo, error)
  50. CountEventByKeys(request *CountEventByKeysRequest) (string, int64, error)
  51. CommonCountEvent(request *CommonCountEventRequest) (string, int64, error)
  52. EventHistoryQueryByKeys(request *EventQueryByKeysRequest) (string, []EventInfo, int64, error)
  53. CommonEventHistoryQuery(request *CommonEventQueryRequest) (string, []EventInfo, int64, error)
  54. EventHistoryQueryOnlyByKeys(request *EventQueryByKeysRequest) (string, []EventInfo, error)
  55. CommonEventHistoryQueryOnly(request *CommonEventQueryRequest) (string, []EventInfo, error)
  56. CountEventHistoryByKeys(request *CountEventByKeysRequest) (string, int64, error)
  57. CommonCountEventHistory(request *CommonCountEventRequest) (string, int64, error)
  58. }