From c941b948f1fa8eff615985a83110a401ae426ab3 Mon Sep 17 00:00:00 2001 From: zhaoqingang <zhaoqg0118@163.com> Date: 星期三, 18 十二月 2024 11:03:49 +0800 Subject: [PATCH] 知识库和智能体同步 --- app/service/knowledge.py | 36 +++++++++++++++++++++++++++++++++++- 1 files changed, 35 insertions(+), 1 deletions(-) diff --git a/app/service/knowledge.py b/app/service/knowledge.py index 828eb9d..7131186 100644 --- a/app/service/knowledge.py +++ b/app/service/knowledge.py @@ -3,6 +3,7 @@ from app.models import KnowledgeModel, group_knowledge_table from app.models.user_model import UserModel from Log import logger +from app.task.fetch_agent import get_one_from_ragflow_knowledge async def get_knowledge_list(db, user_id, keyword, page_size, page_index, status, knowledge, location): @@ -19,7 +20,7 @@ query = query.filter(KnowledgeModel.name.like('%{}%'.format(keyword))) total = query.count() if page_size: - query = query.limit(page_size).offset((page_index - 1) * page_size) + query = query.order_by(KnowledgeModel.update_date.desc()).limit(page_size).offset((page_index - 1) * page_size) return {"total": total, "rows": [kld.to_json() for kld in query.all()]} @@ -35,3 +36,36 @@ return False return True + +async def sync_knowledge_service(db, klg_id): + knowledge = db.query(KnowledgeModel).filter(KnowledgeModel.id == klg_id).first() + if knowledge: + try: + app_knowledge = get_one_from_ragflow_knowledge(klg_id) + if app_knowledge: + knowledge.name = app_knowledge["name"] + knowledge.description = app_knowledge["description"] + knowledge.permission = app_knowledge["permission"] + knowledge.documents = app_knowledge["doc_num"] + knowledge.status = app_knowledge["status"] + db.add(knowledge) + db.commit() + db.refresh(knowledge) + except Exception as e: + logger.error(e) + db.rollback() + return False + return True + + +async def delete_knowledge_service(db, klg_id): + + try: + db.query(KnowledgeModel).filter(KnowledgeModel.id==klg_id).delete() + db.commit() + except Exception as e: + logger.error(e) + db.rollback() + return False + return True + -- Gitblit v1.8.0