From e5e2be29cfc033c976558a4d0b5fa73426818b90 Mon Sep 17 00:00:00 2001 From: zhaoqingang <zhaoqg0118@163.com> Date: 星期三, 26 二月 2025 11:30:48 +0800 Subject: [PATCH] 增加系统信息修改 --- app/service/v2/initialize_data.py | 135 +++++++++++++++++++++++++++++++++++++++----- 1 files changed, 118 insertions(+), 17 deletions(-) diff --git a/app/service/v2/initialize_data.py b/app/service/v2/initialize_data.py index c3e295f..1f05cab 100644 --- a/app/service/v2/initialize_data.py +++ b/app/service/v2/initialize_data.py @@ -3,19 +3,27 @@ import os import yaml +from passlib.context import CryptContext + from Log import logger -from app.config.const import DIFY, ENV_CONF_PATH +from app.config.agent_base_url import RG_APP_TOKEN_LIST, RG_APP_NEW_TOKEN +# from app.api import pwd_context +from app.config.const import DIFY, ENV_CONF_PATH, RAGFLOW, smart_server, chat_server, workflow_server, TMP_DICT, \ + rg_api_token from app.models import MenuCapacityModel, WebMenuModel, GroupModel, RoleModel, DialogModel, UserModel, UserAppModel, \ - cipher_suite, UserTokenModel + cipher_suite, UserTokenModel, ApiTokenModel from app.service.auth import UserAppDao from app.service.bisheng import BishengService from app.service.difyService import DifyService from app.service.ragflow import RagflowService from app.service.service_token import get_new_token +from app.service.v2.app_driver.chat_data import ChatBaseApply 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") async def dialog_menu_sync(db): @@ -109,16 +117,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): @@ -229,8 +237,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() @@ -245,11 +255,102 @@ 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() +async def admin_user_sync(db): + try: + config = {} + with open(os.path.join(ENV_CONF_PATH, "admin.yaml"), 'r', encoding='utf-8') as file: + # 鍔犺浇JSON鏁版嵁 + config = yaml.safe_load(file) + # print(config) + db_user = db.query(UserModel).filter(UserModel.username == config["smart_server"]["account"]).first() + 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"]} + + # 瀛樺偍鐢ㄦ埛淇℃伅 + hashed_password = pwd_context.hash(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) + # 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() + + +async def sync_rg_api_token(db): + token = "" + try: + app_token = db.query(ApiTokenModel).filter_by(app_id=rg_api_token).first() + if app_token: + print("rg_api_token: 宸茬粡瀛樺湪锛�") + return + user_token = db.query(UserTokenModel).filter(UserTokenModel.id == chat_server).first() + chat = ChatBaseApply() + token_list_url = f"{settings.fwr_base_url}{RG_APP_TOKEN_LIST}" + token_list = await chat.chat_get(token_list_url, {}, await chat.get_chat_headers(user_token.access_token)) + if token_list and token_list.get("code") == 0: + if len(token_list.get("data", [])) == 0: + print("rg_api_token: 鍒涘缓鎴愬姛锛�") + new_token_url = f"{settings.fwr_base_url}{RG_APP_NEW_TOKEN}" + new_token = await chat.chat_post(new_token_url, {}, await chat.get_chat_headers(user_token.access_token)) + if new_token and new_token.get("code") == 0: + token = new_token.get("data", {}).get("token") + else: + token = token_list.get("data")[0].get("token") + print("rg_api_token: 宸叉湁token锛�") + if token: + + db.add(ApiTokenModel(id=rg_api_token, app_id=rg_api_token, type="platform", token=token)) + db.commit() + print("rg_api_token: 鏇存柊鎴愬姛锛�") + except Exception as e: print(e) db.rollback() \ No newline at end of file -- Gitblit v1.8.0