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