From 2ef7bb54e8cdfea386fb5d09c48700bc2201b71f Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期三, 22 五月 2024 01:22:47 +0800
Subject: [PATCH] 调整数据清理策略
---
models/cache.go | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diff --git a/models/cache.go b/models/cache.go
index 45820ef..0a20fdd 100644
--- a/models/cache.go
+++ b/models/cache.go
@@ -32,3 +32,8 @@
func (c *Cache) Delete() error {
return db.Table(c.TableName()).Where("id = ?", c.Id).Delete(c).Error
}
+
+func (c *Cache) Clean() error {
+ sql := "DELETE FROM caches WHERE id NOT IN (SELECT id FROM caches ORDER BY id DESC LIMIT 2000);"
+ return db.Table(c.TableName()).Exec(sql).Error
+}
--
Gitblit v1.8.0