From f2c43713b16e821f4a1ae97804c60f18734d5f6a Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期五, 13 十二月 2024 17:25:12 +0800
Subject: [PATCH] 问题优化

---
 app/service/role.py |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/app/service/role.py b/app/service/role.py
index fd7d91d..bc3e1af 100644
--- a/app/service/role.py
+++ b/app/service/role.py
@@ -12,9 +12,10 @@
     #     query.filter(RoleModel.creator==user_id)
     if keyword:
         query = query.filter(RoleModel.name.like('%{}%'.format(keyword)))
+    total = query.count()
     roles = query.order_by(RoleModel.id.desc()).limit(page_size).offset(
         (page_index - 1) * page_size).all()
-    return {"total": query.count(), "rows":  [role.to_json() for role in roles]}
+    return {"total": total, "rows":  [role.to_json() for role in roles]}
 
 
 async def create_role(db, role_name: str, description: str, role_key, data_scope, user_id):

--
Gitblit v1.8.0