edb_refresh_mapping.go 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. package edb_refresh
  2. import (
  3. "errors"
  4. "eta/eta_api/global"
  5. "eta/eta_api/utils"
  6. "time"
  7. )
  8. // EdbRefreshMapping
  9. // @Description: 指标刷新时间配置关系表
  10. type EdbRefreshMapping struct {
  11. EdbRefreshMappingId int `orm:"column(edb_refresh_mapping_id);pk" gorm:"primaryKey" `
  12. Source int `description:"来源"`
  13. SubSource int `description:"来源名称"`
  14. EdbInfoId int `description:"指标id,如果是数据源(钢联、有色)的,那么就是数据源里面的id"`
  15. EdbRefreshConfigId int `description:"刷新配置id"`
  16. SysUserId int `description:"操作人id"`
  17. SysUserRealName string `description:"操作人真实姓名"`
  18. ModifyTime time.Time `description:"最晚一次的更新时间"`
  19. CreateTime time.Time `description:"添加时间"`
  20. }
  21. // Add
  22. // @Description: 添加
  23. // @author: Roc
  24. // @receiver m
  25. // @datetime 2023-12-14 16:11:10
  26. // @param cols []string
  27. // @return err error
  28. func (m *EdbRefreshMapping) Add() (err error) {
  29. if m.EdbRefreshMappingId > 0 {
  30. err = errors.New("该配置已存在")
  31. return
  32. }
  33. err = global.DbMap[utils.DbNameIndex].Create(m).Error
  34. return
  35. }
  36. // Update
  37. // @Description: 更新
  38. // @author: Roc
  39. // @receiver m
  40. // @datetime 2023-12-14 16:11:10
  41. // @param cols []string
  42. // @return err error
  43. func (m *EdbRefreshMapping) Update(cols []string) (err error) {
  44. err = global.DbMap[utils.DbNameIndex].Select(cols).Updates(m).Error
  45. return
  46. }
  47. // Delete
  48. // @Description: 删除
  49. // @author: Roc
  50. // @receiver m
  51. // @datetime 2023-12-14 16:11:10
  52. // @return err error
  53. func (m *EdbRefreshMapping) Delete() (err error) {
  54. sql := ` DELETE FROM edb_refresh_mapping WHERE edb_refresh_mapping_id=? `
  55. err = global.DbMap[utils.DbNameIndex].Exec(sql, m.EdbRefreshConfigId).Error
  56. return
  57. }