From f6b2863303625ef7ef3809c4e08edbd2e0b4530b Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期二, 25 二月 2025 11:19:57 +0800
Subject: [PATCH] 鉴权

---
 app/service/v2/initialize_data.py |  138 +++++++++++++++++++++++++++++++++++++++------
 1 files changed, 119 insertions(+), 19 deletions(-)

diff --git a/app/service/v2/initialize_data.py b/app/service/v2/initialize_data.py
index f681c56..d9e643b 100644
--- a/app/service/v2/initialize_data.py
+++ b/app/service/v2/initialize_data.py
@@ -1,10 +1,16 @@
 import json
 import time
 import os
+
+import yaml
+from passlib.context import CryptContext
+
+
 from Log import logger
-from app.config.const import DIFY
+# from app.api import pwd_context
+from app.config.const import DIFY, ENV_CONF_PATH, RAGFLOW, smart_server, chat_server, workflow_server, TMP_DICT
 from app.models import MenuCapacityModel, WebMenuModel, GroupModel, RoleModel, DialogModel, UserModel, UserAppModel, \
-    cipher_suite
+    cipher_suite, UserTokenModel
 from app.service.auth import UserAppDao
 from app.service.bisheng import BishengService
 from app.service.difyService import DifyService
@@ -12,12 +18,14 @@
 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")
 
 
 async def dialog_menu_sync(db):
     menu_list = []
-    with open("env_conf/menu_conf.json", 'r', encoding='utf-8') as file:
+    with open(os.path.join(ENV_CONF_PATH, "menu_conf.json") , 'r', encoding='utf-8') as file:
         # 鍔犺浇JSON鏁版嵁
         data = json.load(file)
         menu_list = data.get("data", [])
@@ -40,7 +48,8 @@
 
 
 async def create_menu_sync(db):
-    json_file_path = "env_conf/menu_conf.json.template"
+    # json_file_path = "env_conf/menu_conf.json.template"
+    json_file_path = os.path.join(ENV_CONF_PATH, "menu_conf.json.template")
     with open(json_file_path, 'r', encoding='utf-8') as file:
         json_data = json.load(file).get("data", [])
         # for menu in json_data:
@@ -105,21 +114,21 @@
             logger.error(e)
 
 
-async def app_register_sync(db):
-    app_dict = {}
-    with open("env_conf/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):
     agent_list = []
-    with open("env_conf/default_agent_conf.json", 'r', encoding='utf-8') as file:
+    with open(os.path.join(ENV_CONF_PATH, "default_agent_conf.json"), 'r', encoding='utf-8') as file:
         # 鍔犺浇JSON鏁版嵁
         agent_dict = json.load(file)
         agent_list = agent_dict.get("basic", [])
@@ -131,14 +140,15 @@
                 dialog.name = agent["name"]
                 dialog.description = agent["description"]
                 dialog.icon = agent["icon"]
+                dialog.mode = agent["mode"]
+                dialog.parameters = json.dumps(agent["parameters"])
                 db.commit()
             except Exception as e:
                 logger.error(e)
         else:
             try:
-                dialog = DialogModel(id=agent["id"], name=agent["name"], description=agent["description"],
-                                     icon=agent["icon"], tenant_id=user.id if user else "", dialog_type="3",
-                                     agent_id=agent["id"])
+                dialog = DialogModel(id=agent["id"], name=agent["name"], description=agent["description"],        
+                                     icon=agent["icon"], tenant_id=user.id if user else "", dialog_type=agent["dialogType"], mode=agent["mode"],parameters = json.dumps(agent["parameters"]))
                 db.add(dialog)
                 db.commit()
                 db.refresh(dialog)
@@ -219,3 +229,93 @@
     if not user_id:
         raise Exception("Failed to register with app")
     print({"msg": "User registered successfully", "userFlag": user_id})
+
+
+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, "admin.yaml"), 'r', encoding='utf-8') as file:
+            # 鍔犺浇JSON鏁版嵁
+            config = yaml.safe_load(file)
+        account_list = db.query(UserTokenModel).all()
+        for account in account_list:
+            if account.id in config:
+
+                if account.account != config[account.id]["account"] or account.password != config[account.id]["password"]:
+                    db.query(UserTokenModel).filter_by(id=account.id).update({"account": config[account.id]["account"],
+                                                                              "password": config[account.id]["password"],
+                                                                              "access_token": ""
+                                                                              })
+                now_account.append(account.id)
+            else:
+                db.query(UserTokenModel).filter_by(id=account.id).delete()
+
+        for k, v in config.items():
+            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()
\ No newline at end of file

--
Gitblit v1.8.0