From 808ce8f0bfa59f6333c27391b6983bdd67fd0bd6 Mon Sep 17 00:00:00 2001 From: zhangzengfei <zhangzengfei@smartai.com> Date: 星期二, 16 四月 2024 14:37:18 +0800 Subject: [PATCH] 调整缓存的数据 --- models/positions.go | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/models/positions.go b/models/positions.go index db9a27a..5e61a07 100644 --- a/models/positions.go +++ b/models/positions.go @@ -4,7 +4,8 @@ Id uint `gorm:"column:id;primary_key;auto_increment;unique;not null;"` DeviceId string `gorm:"column:device_id;" json:"device_id"` Pos string `gorm:"column:pos" json:"pos"` - CreateTime int64 `gorm:"column:create_time;autoCreateTime;"` + CreateTime int64 `gorm:"column:create_time;"` + TimeString string `gorm:"column:time_string;"` } func (d *Positions) TableName() string { @@ -12,5 +13,5 @@ } func (d *Positions) FindDevicePosition(devId string, timestamp int64) error { - return db.Table(d.TableName()).Where(&d, "device_id = ? AND create_time < ?", devId, timestamp).Order("create_time desc").First(&d).Error + return db.Table(d.TableName()).Where("device_id = ? AND create_time <= ?", devId, timestamp).Order("create_time desc").First(&d).Error } -- Gitblit v1.8.0