From 2fc94ba7b517125a7ed9771b48bb5d383021bc91 Mon Sep 17 00:00:00 2001
From: zhangzengfei <zhangzengfei@smartai.com>
Date: 星期日, 20 十月 2024 01:57:09 +0800
Subject: [PATCH] 优化楼层数据获取
---
models/cache.go | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/models/cache.go b/models/cache.go
index 0a20fdd..5c0dd44 100644
--- a/models/cache.go
+++ b/models/cache.go
@@ -12,6 +12,10 @@
return "caches"
}
+func (c *Cache) First() error {
+ return db.Table(c.TableName()).First(c).Error
+}
+
func (c *Cache) FindAll() ([]Cache, error) {
var caches []Cache
if err := db.Table(c.TableName()).Find(&caches).Error; err != nil {
@@ -19,6 +23,15 @@
}
return caches, nil
+}
+
+func (c *Cache) Count() (int64, error) {
+ var total int64
+ if err := db.Table(c.TableName()).Count(&total).Error; err != nil {
+ return total, err
+ }
+
+ return total, nil
}
func (c *Cache) Save() error {
@@ -34,6 +47,6 @@
}
func (c *Cache) Clean() error {
- sql := "DELETE FROM caches WHERE id NOT IN (SELECT id FROM caches ORDER BY id DESC LIMIT 2000);"
+ sql := "DELETE FROM caches WHERE id NOT IN (SELECT id FROM caches ORDER BY id DESC LIMIT 15000);"
return db.Table(c.TableName()).Exec(sql).Error
}
--
Gitblit v1.8.0