From 3e9a1a28b1283e40bc7edb94e2370c74e7fd68e0 Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期五, 17 五月 2024 15:54:29 +0800
Subject: [PATCH] 添加订阅查询接口
---
models/positions.go | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/models/positions.go b/models/positions.go
index db9a27a..b888f36 100644
--- a/models/positions.go
+++ b/models/positions.go
@@ -1,10 +1,13 @@
package models
+import "time"
+
type Positions struct {
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 +15,14 @@
}
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
+}
+
+func (d *Positions) FindPositionByTime(timestamp int64) error {
+ return db.Table(d.TableName()).Where("create_time <= ?", timestamp).Order("create_time desc").First(&d).Error
+}
+
+func (d *Positions) Clean() error {
+ timestamp := time.Now().Unix() - 3600
+ return db.Table(d.TableName()).Where("create_time <= ?", timestamp).Delete(&d).Error
}
--
Gitblit v1.8.0