From f13239560d9a6888d3bf95699ed5fc10395b50ff Mon Sep 17 00:00:00 2001 From: zhaoqingang <zhaoqg0118@163.com> Date: 星期一, 24 二月 2025 18:57:51 +0800 Subject: [PATCH] 历史记录增加 --- app/service/v2/app_driver/chat_dialog.py | 2 app/service/v2/app_register.py | 15 + app/service/service_token.py | 1 app/models/v2/session_model.py | 22 ++ app/service/user.py | 12 - app/utils/password_handle.py | 4 app/api/v2/chat.py | 17 ++ app/api/auth.py | 32 +-- app/service/auth.py | 10 app/service/v2/chat.py | 82 ++++++--- app/init_config/init_run_data.py | 8 app/service/dialog.py | 11 + app/config/const.py | 1 app/api/v2/public_api.py | 30 +-- app/task/fetch_agent.py | 33 ++-- main.py | 8 app/config/env_conf/admin.yaml | 14 app/service/v2/initialize_data.py | 81 ++++++--- app/models/token_model.py | 43 ----- 19 files changed, 221 insertions(+), 205 deletions(-) diff --git a/app/api/auth.py b/app/api/auth.py index 00b70be..634ada2 100644 --- a/app/api/auth.py +++ b/app/api/auth.py @@ -1,31 +1,21 @@ import json -import time from fastapi import APIRouter, Depends from sqlalchemy.orm import Session from sqlalchemy.ext.asyncio import AsyncSession - -from Log import logger from app.api import Response, pwd_context, get_current_user -from app.api.user import reset_user_pwd from app.config.config import settings -from app.config.const import RAGFLOW, BISHENG, DIFY, chat_server, workflow_server from app.models.app_token_model import AppToken from app.models.base_model import get_db from app.models.postgresql_base_model import get_pdb -from app.models.token_model import upsert_token, update_token +from app.models.token_model import upsert_token from app.models.user import UserCreate, LoginData -from app.models.user_model import UserModel, UserAppModel, UserTokenModel -from app.service.auth import authenticate_user, create_access_token, is_valid_password, save_register_user, \ - update_user_token, UserAppDao, update_user_info, password_rsa -from app.service.bisheng import BishengService -from app.service.service_token import get_new_token, get_token, update_user_group -from app.service.v2.app_register import AppRegisterDao -from app.service.difyService import DifyService +from app.models.user_model import UserModel, UserTokenModel +from app.service.auth import authenticate_user, create_access_token, is_valid_password, save_register_user, password_rsa +from app.service.service_token import get_token from app.service.ragflow import RagflowService from sqlalchemy.future import select -from app.utils.password_handle import generate_password router = APIRouter() @@ -144,11 +134,9 @@ # await update_token(db, user.id, access_token, token_dict) # await update_user_token(db, user.id, token_dict) token_dict = {} - for app in [{"app": RAGFLOW, "token_id": chat_server}, - {"app": DIFY,"token_id": workflow_server}]: - user_token = db.query(UserTokenModel).filter(UserTokenModel.id == app["token_id"]).first() - if user_token and user_token.access_token: - token_dict[app["app"]] = user_token.access_token + user_tokens = db.query(UserTokenModel).all() + for user_token in user_tokens: + token_dict[user_token.id] = user_token.access_token result = await pdb.execute(select(AppToken).where(AppToken.id == user.id)) db_app_token = result.scalars().first() if isinstance(access_token, bytes): @@ -220,7 +208,7 @@ @router.get("/v2/sync", response_model=Response) async def sync_user_tenant(userFlag: str, db=Depends(get_db)): - app_register = AppRegisterDao(db).get_app_by_id(RAGFLOW) - if app_register: - is_update = await update_user_group(db, userFlag) + # app_register = AppRegisterDao(db).get_app_by_id(RAGFLOW) + # if app_register: + # is_update = await update_user_group(db, userFlag) return Response(code=200, msg="success", data={}) \ No newline at end of file diff --git a/app/api/v2/chat.py b/app/api/v2/chat.py index 819b5a6..79bbe9c 100644 --- a/app/api/v2/chat.py +++ b/app/api/v2/chat.py @@ -5,6 +5,7 @@ from fastapi import Depends, APIRouter, File, UploadFile from sqlalchemy.orm import Session from starlette.responses import StreamingResponse, Response +from werkzeug.http import HTTP_STATUS_CODES from app.api import get_current_user from app.config.const import dialog_chat, advanced_chat, base_chat, agent_chat, workflow_chat, basic_chat, \ @@ -13,7 +14,8 @@ from app.models.base_model import get_db from app.models.v2.session_model import ChatData from app.service.v2.chat import service_chat_dialog, get_chat_info, service_chat_basic, \ - service_chat_workflow, service_chat_parameters, service_chat_sessions, service_chat_upload + service_chat_workflow, service_chat_parameters, service_chat_sessions, service_chat_upload, \ + service_chat_sessions_list, service_chat_session_log chat_router_v2 = APIRouter() @@ -109,3 +111,16 @@ status_code = http_400 data = "{}" return Response(data, media_type="application/json", status_code=status_code) + + + +@chat_router_v2.get("/chat/sessions") +async def api_chat_sessions(chatId:str, current:int=1, pageSize:int=100, keyword:str="", current_user: UserModel = Depends(get_current_user), db: Session = Depends(get_db)): # current_user: UserModel = Depends(get_current_user) + data = await service_chat_sessions_list(db, chatId, current, pageSize, current_user.id, keyword) + return Response(data, media_type="application/json", status_code=http_200) + + +@chat_router_v2.get("/chat/session_log") +async def api_chat_sessions(sessionId:str, current_user: UserModel = Depends(get_current_user), db: Session = Depends(get_db)): # current_user: UserModel = Depends(get_current_user) + data = await service_chat_session_log(db, sessionId) + return Response(data, media_type="application/json", status_code=http_200) \ No newline at end of file diff --git a/app/api/v2/public_api.py b/app/api/v2/public_api.py index e320aeb..67e1c18 100644 --- a/app/api/v2/public_api.py +++ b/app/api/v2/public_api.py @@ -4,13 +4,11 @@ from fastapi.responses import JSONResponse from Log import logger from app.api import Response -from app.api.auth import login -from app.config.const import IMAGE_TO_TEXT, DOCUMENT_TO_CLEANING, DOCUMENT_TO_REPORT, DIFY, BISHENG, RAGFLOW, \ +from app.config.const import IMAGE_TO_TEXT, DOCUMENT_TO_CLEANING, \ DOCUMENT_IA_QUESTIONS, DOCUMENT_TO_REPORT_TITLE, DOCUMENT_TO_TITLE, DOCUMENT_TO_PAPER from app.models.base_model import get_db -from app.models.public_api_model import DfToken, AppRegister +from app.models.public_api_model import DfToken from app.service.v2.api_token import DfTokenDao -from app.service.v2.app_register import AppRegisterDao from app.service.v2.initialize_data import dialog_menu_sync, create_menu_sync, user_update_app from app.task.sync_resources import sync_knowledge, sync_dialog, sync_agent, sync_llm, sync_resource @@ -34,18 +32,18 @@ return Response(code=200, msg="successfully", data={}) -@public_api.post("/sync/app_register", response_model=Response) -async def sync_app_register(apr: AppRegister, db=Depends(get_db)): - app_dict = {RAGFLOW: apr.rg, BISHENG: apr.bs, DIFY: apr.df} - - try: - for app_id, status in app_dict.items(): - AppRegisterDao(db).update_and_insert_app(app_id, status) - except Exception as e: - logger.error(e) - return Response(code=500, msg="failed", data={}) - - return Response(code=200, msg="successfully", data={}) +# @public_api.post("/sync/app_register", response_model=Response) +# async def sync_app_register(apr: AppRegister, db=Depends(get_db)): +# app_dict = {RAGFLOW: apr.rg, BISHENG: apr.bs, DIFY: apr.df} +# +# try: +# for app_id, status in app_dict.items(): +# AppRegisterDao(db).update_and_insert_app(app_id, status) +# except Exception as e: +# logger.error(e) +# return Response(code=500, msg="failed", data={}) +# +# return Response(code=200, msg="successfully", data={}) @public_api.get("/sync/resource", response_model=Response) diff --git a/app/config/const.py b/app/config/const.py index 27bf15c..2878f35 100644 --- a/app/config/const.py +++ b/app/config/const.py @@ -101,3 +101,4 @@ ###-----------------------app account key-------------------------------------------- chat_server = "chat_server" workflow_server = "workflow_server" +smart_server = "smart_server" diff --git a/app/config/env_conf/admin.yaml b/app/config/env_conf/admin.yaml index 3821bfd..7c12711 100644 --- a/app/config/env_conf/admin.yaml +++ b/app/config/env_conf/admin.yaml @@ -1,12 +1,12 @@ smart_server: account: administer - password: basic@2025 + password: gAAAAABnvAq8bErFiR9x_ZcODjUeOdrDo8Z5UVOzyqo6SxIhAvLpw81kciQN0frwIFVfY9wrxH1WqrpTICpEwfH7r2SkLjS7SQ== -ragflow_app: +chat_server: id: 2c039666c29d11efa4670242ac1b0006 - account: admin@example.com - password: basic@2025 + account: zhao1@example.com + password: gAAAAABnpFLtotY2OIRH12BJh4MzMgn5Zil7-DVpIeuqlFwvr0g6g_n4ULogn-LNhCbtk6cCDkzZlqAHvBSX2e_zf7AsoyzbiQ== -dify_app: - account: admin@mail.com - password: basic@2025 \ No newline at end of file +workflow_server: + account: admin@basic.com + password: gAAAAABnpFLtotY2OIRH12BJh4MzMgn5Zil7-DVpIeuqlFwvr0g6g_n4ULogn-LNhCbtk6cCDkzZlqAHvBSX2e_zf7AsoyzbiQ== \ No newline at end of file diff --git a/app/init_config/init_run_data.py b/app/init_config/init_run_data.py index 02283f4..92d942e 100644 --- a/app/init_config/init_run_data.py +++ b/app/init_config/init_run_data.py @@ -1,6 +1,6 @@ from app.models.base_model import SessionLocal -from app.service.v2.initialize_data import dialog_menu_sync, default_group_sync, default_role_sync, app_register_sync, \ - basic_agent_sync, admin_account_sync, admin_user_sync +from app.service.v2.initialize_data import dialog_menu_sync, default_group_sync, default_role_sync, \ + basic_agent_sync, admin_account_sync async def sync_default_data(): @@ -9,10 +9,10 @@ await dialog_menu_sync(db) # 灏忔暟 await default_group_sync(db) # 榛樿缁� await default_role_sync(db) # 榛樿瑙掕壊 - await app_register_sync(db) # 娉ㄥ唽鐨勫簲鐢� + # await app_register_sync(db) # 娉ㄥ唽鐨勫簲鐢� await basic_agent_sync(db) # 寮�鍙戠殑agent await admin_account_sync(db) # - await admin_user_sync(db) # + except Exception as e: print(e) finally: diff --git a/app/models/token_model.py b/app/models/token_model.py index ef120dc..bfd088d 100644 --- a/app/models/token_model.py +++ b/app/models/token_model.py @@ -1,11 +1,6 @@ from datetime import datetime -from typing import Type - from sqlalchemy import Column, Integer, DateTime, Text, String from sqlalchemy.orm import Session - -from app.config.const import RAGFLOW -# from Log import logger from app.models.base_model import Base @@ -52,44 +47,6 @@ except Exception as e: # 寮傚父澶勭悊 db.rollback() # 鍥炴粴浜嬪姟 - - -async def update_token(db: Session, user_id: int, access_token: str, token: dict): - # 鍙傛暟楠岃瘉 - if not isinstance(user_id, int) or user_id <= 0: - return - db_token = None - # print(token) - try: - # 鏌ヨ鐜版湁璁板綍 - db_token = db.query(TokenModel).filter_by(user_id=user_id).first() - if db_token: - # 璁板綍瀛樺湪锛岃繘琛屾洿鏂� - db_token.token = access_token - db_token.ragflow_token = token.get(RAGFLOW, "") - # db_token.token = access_token - # for k, v in token.items(): - # setattr(db_token, k.replace("app", "token"), v) - else: - # 璁板綍涓嶅瓨鍦紝杩涜鎻掑叆 - db_token = TokenModel( - user_id=user_id, - token=access_token, - ragflow_token = token.get(RAGFLOW, "") - ) - # for k, v in token.items(): - # setattr(db_token, k.replace("app", "token"), v) - db.add(db_token) - - # 鎻愪氦浜嬪姟 - db.commit() - db.refresh(db_token) - - except Exception as e: - # logger.error(e) - # 寮傚父澶勭悊 - db.rollback() # 鍥炴粴浜嬪姟 - class ApiTokenModel(Base): diff --git a/app/models/v2/session_model.py b/app/models/v2/session_model.py index fad5bc1..3fa4eef 100644 --- a/app/models/v2/session_model.py +++ b/app/models/v2/session_model.py @@ -3,7 +3,7 @@ from datetime import datetime from sqlalchemy.orm import Session -from typing import Optional, Type +from typing import Optional, Type, List from pydantic import BaseModel from sqlalchemy import Column, String, Integer, DateTime, JSON, TEXT, Index @@ -43,9 +43,9 @@ 'session_id': self.id, 'name': self.name, 'agent_type': self.agent_type, - 'agent_id': self.agent_id, + 'chat_id': self.agent_id, 'event_type': self.event_type, - 'session_type': self.session_type, + 'session_type': self.session_type if self.session_type else 0, 'create_date': self.create_date.strftime("%Y-%m-%d %H:%M:%S"), 'update_date': self.update_date.strftime("%Y-%m-%d %H:%M:%S"), } @@ -55,7 +55,7 @@ 'id': self.id, 'name': self.name, 'agent_type': self.agent_type, - 'agent_id': self.agent_id, + 'chat_id': self.agent_id, 'create_date': self.create_date.strftime("%Y-%m-%d %H:%M:%S"), 'update_date': self.update_date.strftime("%Y-%m-%d %H:%M:%S"), 'message': json.loads(self.message) @@ -104,7 +104,7 @@ return session async def update_session_by_id(self, session_id: str, session, message: dict, conversation_id=None) -> ChatSessionModel | None: - print(message) + # print(message) if not session: session = await self.get_session_by_id(session_id) if session: @@ -133,3 +133,15 @@ if session: self.db.delete(session) self.db.commit() + + async def get_session_list(self, user_id: int, agent_id: str, keyword:str, page: int, page_size: int) -> any: + query = self.db.query(ChatSessionModel).filter(ChatSessionModel.tenant_id==user_id) + if agent_id: + query = query.filter(ChatSessionModel.agent_id==agent_id) + if keyword: + query = query.filter(ChatSessionModel.name.like('%{}%'.format(keyword))) + total = query.count() + session_list = query.order_by(ChatSessionModel.update_date.desc()).offset((page-1)*page_size).limit(page_size).all() + return total, session_list + + diff --git a/app/service/auth.py b/app/service/auth.py index 8354200..dcf1ebb 100644 --- a/app/service/auth.py +++ b/app/service/auth.py @@ -4,7 +4,6 @@ import base64 from datetime import datetime, timedelta from typing import Type -from uuid import uuid4 from jwt import encode, decode, exceptions from passlib.context import CryptContext @@ -13,12 +12,9 @@ from Log import logger from app.config.config import settings -from app.config.const import RAGFLOW, BISHENG, DIFY, USER_STATSU_DELETE, APP_SERVICE_PATH +from app.config.const import USER_STATSU_DELETE, APP_SERVICE_PATH from app.models import RoleModel, GroupModel, TokenModel from app.models.user_model import UserModel, UserAppModel -# from app.service.ragflow import RagflowService -# from app.service.service_token import get_new_token -from app.service.v2.app_register import AppRegisterDao from cryptography.hazmat.backends import default_backend from cryptography.hazmat.primitives import serialization @@ -113,7 +109,7 @@ return False return True - +""" async def update_user_info(db, user_id): app_register = AppRegisterDao(db).get_apps() register_dict = {} @@ -147,6 +143,8 @@ # db.refresh(db_user) # is_sava = await save_register_user(db, user.username, user.password, user.email, register_dict) +""" + class UserAppDao: def __init__(self, db: Session): diff --git a/app/service/dialog.py b/app/service/dialog.py index 81316ff..3b965f2 100644 --- a/app/service/dialog.py +++ b/app/service/dialog.py @@ -97,10 +97,19 @@ async def create_dialog_service(db, dialog_id, dialog_name, description, icon, dialog_type, mode, user_id): + para = { + "user_input_form": [], + "retriever_resource": { + "enabled": True + }, + "file_upload": { + "enabled": False + } + } try: dialog_model = DialogModel(id=dialog_id, name=dialog_name, description=description, icon=icon, dialog_type=dialog_type, tenant_id=user_id, mode=mode, update_date=datetime.now(), - create_date=datetime.now()) + create_date=datetime.now(), parameters=json.dumps(para)) db.add(dialog_model) db.commit() db.refresh(dialog_model) diff --git a/app/service/service_token.py b/app/service/service_token.py index 9707d3c..6383b6a 100644 --- a/app/service/service_token.py +++ b/app/service/service_token.py @@ -2,7 +2,6 @@ from app.config.config import settings from app.config.const import BISHENG, RAGFLOW, DIFY from app.models import UserModel, UserAppModel -from app.models.base_model import SessionLocal from app.models.token_model import TokenModel from app.service.auth import UserAppDao from app.service.bisheng import BishengService diff --git a/app/service/user.py b/app/service/user.py index 3536b89..d11683e 100644 --- a/app/service/user.py +++ b/app/service/user.py @@ -1,11 +1,7 @@ import time import uuid from datetime import datetime -from traceback import print_tb - from app.api import pwd_context -from app.api.dialog import dialog_list -from app.config.config import settings from app.config.const import RAGFLOW, BISHENG, DIFY, USER_STATSU_DELETE, ROLE_STATUS_ON, DEPT_STATUS_ON, \ Dialog_STATSU_ON from app.models import RoleModel, GroupModel, AgentType, role_resource_table, DialogModel, OrganizationModel, \ @@ -13,13 +9,7 @@ from app.models.menu_model import WebMenuModel, MenuCapacityModel from app.models.user_model import UserModel, UserAppModel from Log import logger -from app.service.auth import UserAppDao -from app.service.bisheng import BishengService -from app.service.v2.app_register import AppRegisterDao -from app.service.difyService import DifyService -from app.service.ragflow import RagflowService -from app.service.service_token import get_ragflow_token, get_bisheng_token, get_new_token, get_dify_token -from app.utils.password_handle import generate_password + async def get_user_list(db, page_index: int, page_size: int, keyword: str, role_key: str, user_id): diff --git a/app/service/v2/app_driver/chat_dialog.py b/app/service/v2/app_driver/chat_dialog.py index df7a5d1..bfbe645 100644 --- a/app/service/v2/app_driver/chat_dialog.py +++ b/app/service/v2/app_driver/chat_dialog.py @@ -9,7 +9,7 @@ async def chat_completions(self, url, data, headers): complete_response = "" async for line in self.http_stream(url, data, headers): - print(line) + # print(line) if line.startswith("data:"): complete_response = line.strip("data:").strip() else: diff --git a/app/service/v2/app_register.py b/app/service/v2/app_register.py index 88c5393..c4c56cc 100644 --- a/app/service/v2/app_register.py +++ b/app/service/v2/app_register.py @@ -16,22 +16,23 @@ return session - def update_app(self, app_id: str, status: int): + def update_app(self, app_id: str, status: int, name): logger.error("鏇存柊鏁版嵁: app register---------------------------") try: - self.db.query(AppRegisterModel).filter(AppRegisterModel.id==app_id).update({"status":status, "updated_at": datetime.now()}) + self.db.query(AppRegisterModel).filter(AppRegisterModel.id==app_id).update({"status":status, "updated_at": datetime.now(), "name": name}) self.db.commit() except Exception as e: logger.error(e) self.db.rollback() raise Exception("鏇存柊澶辫触锛�") - def insert_app(self, app_id: str, status: int): + def insert_app(self, app_id: str, status: int, name: str): logger.error("鏂板鏁版嵁: app register---------------------------") new_session = AppRegisterModel( id=app_id, - status=status + status=status, + name=name ) self.db.add(new_session) self.db.commit() @@ -39,14 +40,14 @@ return new_session - def update_and_insert_app(self, app_id: str, status: int): + def update_and_insert_app(self, app_id: str, status: int, name=""): logger.error("鏇存柊鎴栬�呮坊鍔犳暟鎹�: app register---------------------------") token_boj = self.get_app_by_id(app_id) if token_boj: - self.update_app(app_id, status) + self.update_app(app_id, status, name) else: - self.insert_app(app_id, status) + self.insert_app(app_id, status, name) def get_apps(self): diff --git a/app/service/v2/chat.py b/app/service/v2/chat.py index 034235b..a35c775 100644 --- a/app/service/v2/chat.py +++ b/app/service/v2/chat.py @@ -28,13 +28,13 @@ async def add_session_log(db, session_id: str, question: str, chat_id: str, user_id, event_type: str, - conversation_id: str): + conversation_id: str, agent_type): try: session = await ChatSessionDao(db).update_or_insert_by_id( session_id=session_id, name=question[:255], agent_id=chat_id, - agent_type=1, + agent_type=agent_type, tenant_id=user_id, message={"role": "user", "content": question}, conversation_id=conversation_id, @@ -88,7 +88,7 @@ token = await get_chat_token(db, rg_api_token) url = settings.fwr_base_url + RG_CHAT_DIALOG.format(chat_id) chat = ChatDialog() - session = await add_session_log(db, session_id, question, chat_id, user_id, mode, session_id) + session = await add_session_log(db, session_id, question, chat_id, user_id, mode, session_id, 1) if session: conversation_id = session.conversation_id message = {"role": "assistant", "answer": "", "reference": {}} @@ -129,13 +129,35 @@ except: ... finally: + message["role"] = "assistant" await update_session_log(db, session_id, message, conversation_id) + +async def data_process(data): + if isinstance(data, str): + return data.replace("dify", "smart") + elif isinstance(data, dict): + for k in list(data.keys()): + if isinstance(k, str) and "dify" in k: + new_k = k.replace("dify", "smart") + data[new_k] = await data_process(data[k]) + del data[k] + else: + data[k] = await data_process(data[k]) + return data + elif isinstance(data, list): + for i in range(len(data)): + data[i] = await data_process(data[i]) + return data + else: + return data async def service_chat_workflow(db, chat_id: str, chat_data: ChatData, session_id: str, user_id, mode: str): conversation_id = "" answer_event = "" answer_agent = "" + answer_workflow = "" + download_url = "" message_id = "" task_id = "" error = "" @@ -147,7 +169,7 @@ query = chat_data.query else: query = "start new workflow" - session = await add_session_log(db, session_id, query, chat_id, user_id, mode, conversation_id) + session = await add_session_log(db, session_id, query, chat_id, user_id, mode, conversation_id, 3) if session: conversation_id = session.conversation_id try: @@ -179,14 +201,17 @@ event = smart_message_file elif ans.get("event") in [workflow_started, node_started, node_finished]: data = ans.get("data", {}) - data["inputs"] = [] - data["outputs"] = [] + data["inputs"] = await data_process(data.get("inputs", {})) + data["outputs"] = await data_process(data.get("outputs", {})) + data["files"] = await data_process(data.get("files", [])) data["process_data"] = "" node_list.append(ans) event = [smart_workflow_started, smart_node_started, smart_node_finished][ [workflow_started, node_started, node_finished].index(ans.get("event"))] elif ans.get("event") == workflow_finished: data = ans.get("data", {}) + answer_workflow = data.get("outputs", {}).get("output") + download_url = data.get("outputs", {}).get("download_url") event = smart_workflow_finished node_list.append(ans) @@ -209,7 +234,8 @@ except: ... finally: - await update_session_log(db, session_id, {"role": "assistant", "answer": answer_event or answer_agent, + await update_session_log(db, session_id, {"role": "assistant", "answer": answer_event or answer_agent or answer_workflow, + "download_url":download_url, "node_list": node_list, "task_id": task_id, "id": message_id, "error": error}, conversation_id) @@ -223,22 +249,6 @@ if not chat_info: return {} return chat_info.parameters - # if chat_info.dialog_type == RG_TYPE: - # return {"retriever_resource": - # { - # "enabled": True - # } - # } - # elif chat_info.dialog_type == BASIC_TYPE: - # ... - # elif chat_info.dialog_type == DF_TYPE: - # token = await get_chat_token(db, chat_id) - # if not token: - # return {} - # url = settings.dify_base_url + DF_CHAT_PARAMETERS - # chat = ChatBaseApply() - # return await chat.chat_get(url, {"user": str(user_id)}, await chat.get_headers(token)) - async def service_chat_sessions(db, chat_id, name): token = await get_chat_token(db, rg_api_token) @@ -247,6 +257,24 @@ url = settings.fwr_base_url + RG_CHAT_SESSIONS.format(chat_id) chat = ChatDialog() return await chat.chat_sessions(url, {"name": name}, await chat.get_headers(token)) + + +async def service_chat_sessions_list(db, chat_id, current, page_size, user_id, keyword): + total, session_list = await ChatSessionDao(db).get_session_list( + user_id=user_id, + agent_id=chat_id, + keyword=keyword, + page=current, + page_size=page_size + ) + return json.dumps({"total":total, "rows": [session.to_dict() for session in session_list]}) + + + +async def service_chat_session_log(db, session_id): + session_log = await ChatSessionDao(db).get_session_by_id(session_id) + return json.dumps(session_log.log_to_json()) + async def service_chat_upload(db, chat_id, file, user_id): @@ -277,14 +305,6 @@ tokenizer = get_tokenizer('qwen-turbo') # 灏嗗瓧绗︿覆鍒囧垎鎴恡oken骞惰浆鎹负token id tokens = tokenizer.encode(input_str) - # print(f"缁忚繃鍒囧垎鍚庣殑token id涓猴細{tokens}銆�") - # # 缁忚繃鍒囧垎鍚庣殑token id涓猴細 [31935, 64559, 99320, 56007, 100629, 104795, 99788, 1773] - # print(f"缁忚繃鍒囧垎鍚庡叡鏈墈len(tokens)}涓猼oken") - # # 缁忚繃鍒囧垎鍚庡叡鏈�8涓猼oken - # - # # 灏唗oken id杞寲涓哄瓧绗︿覆骞舵墦鍗板嚭鏉� - # for i in range(len(tokens)): - # print(f"token id涓簕tokens[i]}瀵瑰簲鐨勫瓧绗︿覆涓猴細{tokenizer.decode(tokens[i])}") return len(tokens) async def read_pdf(pdf_stream): diff --git a/app/service/v2/initialize_data.py b/app/service/v2/initialize_data.py index e315b4a..9f47f70 100644 --- a/app/service/v2/initialize_data.py +++ b/app/service/v2/initialize_data.py @@ -8,7 +8,7 @@ from Log import logger # from app.api import pwd_context -from app.config.const import DIFY, ENV_CONF_PATH, RAGFLOW +from app.config.const import DIFY, ENV_CONF_PATH, RAGFLOW, smart_server, chat_server, workflow_server from app.models import MenuCapacityModel, WebMenuModel, GroupModel, RoleModel, DialogModel, UserModel, UserAppModel, \ cipher_suite, UserTokenModel from app.service.auth import UserAppDao @@ -18,7 +18,7 @@ from app.service.service_token import get_new_token from app.service.v2.app_register import AppRegisterDao from app.config.config import settings -from app.utils.password_handle import generate_password +from app.utils.password_handle import generate_password, password_encrypted, password_decrypted pwd_context = CryptContext(schemes=["bcrypt"], deprecated="auto") @@ -114,16 +114,16 @@ logger.error(e) -async def app_register_sync(db): - app_dict = {} - with open(os.path.join(ENV_CONF_PATH, "app_register_conf.json"), 'r', encoding='utf-8') as file: - # 鍔犺浇JSON鏁版嵁 - app_dict = json.load(file) - try: - for app_id, status in app_dict.items(): - AppRegisterDao(db).update_and_insert_app(app_id, status) - except Exception as e: - logger.error(e) +# async def app_register_sync(db): +# app_dict = {} +# with open(os.path.join(ENV_CONF_PATH, "app_register_conf.json"), 'r', encoding='utf-8') as file: +# # 鍔犺浇JSON鏁版嵁 +# app_dict = json.load(file) +# try: +# for app_id, status in app_dict.items(): +# AppRegisterDao(db).update_and_insert_app(app_id, status) +# except Exception as e: +# logger.error(e) async def basic_agent_sync(db): @@ -234,8 +234,10 @@ async def admin_account_sync(db): try: config = {} + app_dict = {} + tmp_dict = {chat_server:RAGFLOW, workflow_server:DIFY} now_account =[] - with open(os.path.join(ENV_CONF_PATH, "account.yaml"), 'r', encoding='utf-8') as file: + with open(os.path.join(ENV_CONF_PATH, "admin.yaml"), 'r', encoding='utf-8') as file: # 鍔犺浇JSON鏁版嵁 config = yaml.safe_load(file) account_list = db.query(UserTokenModel).all() @@ -250,11 +252,38 @@ now_account.append(account.id) else: db.query(UserTokenModel).filter_by(id=account.id).delete() + for k, v in config.items(): - if k not in now_account: - new_account = UserTokenModel(id=k, account=v["account"], password=v["password"]) - db.add(new_account) + if k in tmp_dict: + app_dict[tmp_dict[k]] = v.get("id") + if k == smart_server: + db_user = db.query(UserModel).filter(UserModel.username == config["smart_server"]["account"]).first() + if db_user: + print("admin_user_sync: 鐢ㄦ埛宸茬粡瀛樺湪锛�") + continue + hashed_password = pwd_context.hash(await password_decrypted(config["smart_server"]["password"])) # config["smart_server"]["password"] + user_model = UserModel(username=config["smart_server"]["account"], hashed_password=hashed_password, + email="", + phone="", login_name="", sync_flag="", creator=0, permission="admin") + db.add(user_model) + # db.commit() + # db.refresh(user_model) + else: + if k not in now_account: + new_account = UserTokenModel(id=k, account=v["account"], password=v["password"]) + db.add(new_account) + db.commit() + + # with open(os.path.join(ENV_CONF_PATH, "app_register_conf.json"), 'r', encoding='utf-8') as file: + # # 鍔犺浇JSON鏁版嵁 + # app_dict = json.load(file) + try: + for app_id, name in app_dict.items(): + AppRegisterDao(db).update_and_insert_app(app_id, 1, name) + except Exception as e: + logger.error(e) + except Exception as e: print(e) db.rollback() @@ -269,12 +298,12 @@ if db_user: print("admin_user_sync: 鐢ㄦ埛宸茬粡瀛樺湪锛�") return - register_dict = {} - - for app in [RAGFLOW, DIFY]: - register_dict[app] = {"id": config[app].get("id", "123"), "name": config[app]["account"], - "pwd":config[app]["password"], - "email": config[app]["account"]} + # register_dict = {} + # + # for app in [RAGFLOW, DIFY]: + # register_dict[app] = {"id": config[app].get("id", "123"), "name": config[app]["account"], + # "pwd":config[app]["password"], + # "email": config[app]["account"]} # 瀛樺偍鐢ㄦ埛淇℃伅 hashed_password = pwd_context.hash(config["smart_server"]["password"]) @@ -283,10 +312,10 @@ db.add(user_model) db.commit() db.refresh(user_model) - u_id = user_model.id - user_app_dao = UserAppDao(db) - for k, v in register_dict.items(): - await user_app_dao.update_and_insert_data(v.get("name"), user_model.encrypted_password(v.get("pwd")), v.get("email"), u_id, str(v.get("id")), k) + # u_id = user_model.id + # user_app_dao = UserAppDao(db) + # for k, v in register_dict.items(): + # await user_app_dao.update_and_insert_data(v.get("name"), user_model.encrypted_password(v.get("pwd")), v.get("email"), u_id, str(v.get("id")), k) except Exception as e: print(e) db.rollback() \ No newline at end of file diff --git a/app/task/fetch_agent.py b/app/task/fetch_agent.py index c753f55..fde6d3a 100644 --- a/app/task/fetch_agent.py +++ b/app/task/fetch_agent.py @@ -239,7 +239,7 @@ db.close() -def get_data_from_ragflow_v2(names: List[str]) -> List[Dict]: +def get_data_from_ragflow_v2(names: List[str], tenant_id) -> List[Dict]: db = SessionRagflow() para = { "user_input_form": [], @@ -256,7 +256,7 @@ .filter(Dialog.name.in_(names), Dialog.status == "1") else: query = db.query(Dialog.id, Dialog.name, Dialog.description, Dialog.status, Dialog.tenant_id).filter( - Dialog.status == "1") + Dialog.status == "1", Dialog.tenant_id == tenant_id) results = query.all() formatted_results = [ @@ -320,12 +320,12 @@ db.close() -def get_data_from_ragflow_knowledge(): +def get_data_from_ragflow_knowledge(tenant_id): db = SessionRagflow() try: results = db.query(RgKnowledge.id, RgKnowledge.name, RgKnowledge.description, RgKnowledge.status, - RgKnowledge.tenant_id, RgKnowledge.doc_num, RgKnowledge.permission).all() + RgKnowledge.tenant_id, RgKnowledge.doc_num, RgKnowledge.permission).filter(RgKnowledge.tenant_id==tenant_id).all() formatted_results = [ {"id": row[0], "name": row[1], "description": row[2], "status": str(row[3]), "user_id": str(row[4]), "doc_num": row[5], "permission": row[6]} for row in results] @@ -340,18 +340,17 @@ try: app_register = AppRegisterDao(db).get_apps() for app in app_register: - if app["id"] == RAGFLOW: - ragflow_data = get_data_from_ragflow_v2([]) - if ragflow_data: - update_ids_in_local_v2(ragflow_data, "1") - # elif app["id"] == BISHENG: - # bisheng_data = get_data_from_bisheng_v2([]) - # if bisheng_data: - # update_ids_in_local_v2(bisheng_data, "2") - elif app["id"] == DIFY: - dify_data = get_data_from_dy_v2([]) - if dify_data: - update_ids_in_local_v2(dify_data, "4") + try: + if app["id"] == RAGFLOW: + ragflow_data = get_data_from_ragflow_v2([], app["name"]) + if ragflow_data: + update_ids_in_local_v2(ragflow_data, "1") + elif app["id"] == DIFY: + dify_data = get_data_from_dy_v2([]) + if dify_data: + update_ids_in_local_v2(dify_data, "4") + except Exception as e: + print(f"Failed to sync agents: {str(e)}") print("v2 Agents synchronized successfully") except Exception as e: print(f"v2 Failed to sync agents: {str(e)}") @@ -412,7 +411,7 @@ app_register = AppRegisterDao(db).get_apps() for app in app_register: if app["id"] == RAGFLOW: - ragflow_data = get_data_from_ragflow_knowledge() + ragflow_data = get_data_from_ragflow_knowledge(app["name"]) if ragflow_data: update_ids_in_local_knowledge(ragflow_data, "1") # elif app["id"] == BISHENG: diff --git a/app/utils/password_handle.py b/app/utils/password_handle.py index 2eebd7a..48063ed 100644 --- a/app/utils/password_handle.py +++ b/app/utils/password_handle.py @@ -31,13 +31,13 @@ async def password_encrypted(password): hash_pwd = cipher_suite.encrypt(password.encode("utf-8")).decode("utf-8") - print(hash_pwd) + # print(hash_pwd) return hash_pwd async def password_decrypted(hash_password): pwd = cipher_suite.decrypt(hash_password).decode("utf-8") - print(pwd) + # print(pwd) return pwd if __name__ == "__main__": # 鐢熸垚涓�涓�10浣嶇殑瀵嗙爜 diff --git a/main.py b/main.py index 7f504c2..339fb25 100644 --- a/main.py +++ b/main.py @@ -29,7 +29,7 @@ from app.task.fetch_agent import sync_agents, initialize_agents, sync_agents_v2, sync_knowledge, \ sync_resources_from_json from app.init_config.init_run_data import sync_default_data -from app.task.sync_account_token import start_sync_token_task +from app.task.sync_account_token import start_sync_token_task, sync_token init_db() @@ -44,10 +44,10 @@ await sync_default_data() - sync_agents_v2() - sync_knowledge() + sync_agents_v2() # 鏅鸿兘浣� + sync_knowledge() # 鐭ヨ瘑搴� sync_resources_from_json() - # start_sync_token_task() + await sync_token() # 鍚姩鍚屾token浠诲姟 yield # 鍦ㄥ簲鐢ㄥ叧闂椂鎵ц娓呯悊鎿嶄綔锛堝鏋滈渶瑕侊級 pass -- Gitblit v1.8.0