| | |
| | | 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": [], |
| | |
| | | .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 = [ |
| | |
| | | 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] |
| | |
| | | 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)}") |
| | |
| | | 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: |