12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- package models
- import "github.com/beego/beego/v2/client/orm"
- type BaseFromLyData struct {
- BaseFromLyDataId int `orm:"column(base_from_ly_data_id);pk"`
- CreateTime string `orm:"column(create_time)"`
- ModifyTime string `orm:"column(modify_time)"`
- BaseFromLyIndexId int `orm:"column(base_from_ly_index_id)"`
- IndexCode string `orm:"column(index_code)"`
- DataTime string `orm:"column(data_time)"`
- Value float64 `orm:"column(value)"`
- }
- func init() {
- orm.RegisterModel(new(BaseFromLyData))
- }
- func AddLyDataList(items []BaseFromLyData) (err error) {
- o := orm.NewOrmUsingDB("data")
- _, err = o.InsertMulti(len(items), items)
- return
- }
- func GetLyDataByIndexIdAndDataTime(indexId int, dataTime string) (items []BaseFromLyData, err error) {
- o := orm.NewOrmUsingDB("data")
- sql := `SELECT * FROM base_from_ly_data WHERE base_from_ly_index_id=? AND data_time=?`
- _, err = o.Raw(sql, indexId, dataTime).QueryRows(&items)
- return
- }
- func GetLyDataByIndexIdAndDataTimeYM(indexId int, dataTime string) (items []BaseFromLyData, err error) {
- o := orm.NewOrmUsingDB("data")
- sql := `SELECT * FROM base_from_ly_data WHERE base_from_ly_index_id=? AND data_time like ?`
- _, err = o.Raw(sql, indexId, dataTime+"%").QueryRows(&items)
- return
- }
- func UpdateLyDataById(dataId int, value float64) (err error) {
- o := orm.NewOrmUsingDB("data")
- sql := `UPDATE base_from_ly_data SET value=? WHERE base_from_ly_data_id=?`
- _, err = o.Raw(sql, value, dataId).Exec()
- return
- }
|