base_from_trade_index.go 341 B

123456789101112
  1. package data_manage
  2. import (
  3. "github.com/beego/beego/v2/client/orm"
  4. )
  5. func GetFirstBaseFromTradeIndexByDate(exchange string) (item *BaseFromTradeShanghaiIndex, err error) {
  6. o := orm.NewOrm()
  7. sql := "SELECT * FROM base_from_trade_" + exchange + "_index where rank < 50 order by data_time asc"
  8. err = o.Raw(sql).QueryRow(&item)
  9. return
  10. }