edb_data_ths.go 1.1 KB

1234567891011121314151617181920212223242526272829303132333435
  1. package data_manage
  2. import (
  3. "eta/eta_api/global"
  4. "eta/eta_api/utils"
  5. "time"
  6. )
  7. type EdbDataThs struct {
  8. //EdbDataId int `orm:"column(edb_data_id);pk"`
  9. EdbDataId int `gorm:"column:edb_data_id;primaryKey"`
  10. EdbInfoId int
  11. EdbCode string
  12. DataTime string
  13. Value float64
  14. Status int
  15. CreateTime time.Time
  16. ModifyTime time.Time
  17. DataTimestamp int64 `gorm:"column:data_timestamp"`
  18. }
  19. func GetEdbDataThsMaxOrMinDate(edbCode string) (min_date, max_date string, err error) {
  20. //o := orm.NewOrmUsingDB("data")
  21. //sql := ` SELECT MIN(data_time) AS min_date,MAX(data_time) AS max_date FROM edb_data_ths WHERE edb_code=? `
  22. //err = o.Raw(sql, edbCode).QueryRow(&min_date, &max_date)
  23. sql := ` SELECT MIN(data_time) AS minDate,MAX(data_time) AS maxDate FROM edb_data_ths WHERE edb_code=? `
  24. var maxAndMinDate MaxAndMinDate
  25. err = global.DbMap[utils.DbNameIndex].Raw(sql, edbCode).First(&maxAndMinDate).Error
  26. if err != nil {
  27. return
  28. }
  29. min_date = maxAndMinDate.MinDate.Format(utils.FormatDate)
  30. max_date = maxAndMinDate.MaxDate.Format(utils.FormatDate)
  31. return
  32. }