From 7a14bea3aa54e889524620efea074fa583e7de41 Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期五, 22 十一月 2024 17:31:02 +0800
Subject: [PATCH] Merge branch 'master' of http://192.168.5.5:10010/r/rag-gateway

---
 /dev/null            |   69 -----------------
 app/api/chat.py      |   17 +++-
 app/service/basic.py |   54 +++----------
 app/api/files.py     |   92 +++++++++++++---------
 4 files changed, 81 insertions(+), 151 deletions(-)

diff --git a/app/api/chat.py b/app/api/chat.py
index b2486ab..076950e 100644
--- a/app/api/chat.py
+++ b/app/api/chat.py
@@ -261,10 +261,19 @@
                                     f"&file_type={file_type}")
                         excel_url = build_file_url(excel_name, 'excel')
                         image_url = build_file_url(image_name, 'image')
-                        try:
-                            SessionService(db).update_session(chat_id, message={"content": output, "role": "assistant"})
-                        except Exception as e:
-                            logger.error(f"Unexpected error when update_session: {e}")
+                        if excel_url or data.get("e", ""):
+                            try:
+                                SessionService(db).update_session(chat_id,
+                                                                  message={
+                                                                      "content": output,
+                                                                      "excel_url": excel_url,
+                                                                      "image_url": image_url,
+                                                                      "sql": data.get("sql", ""),
+                                                                      "code": data.get("code", ""),
+                                                                      "e": data.get("e", ""),
+                                                                      "role": "assistant"})
+                            except Exception as e:
+                                logger.error(f"Unexpected error when update_session: {e}")
                         # 鍙戦�佺粨鏋滅粰瀹㈡埛绔�
                         data["type"] = "message"
                         data["message"] = output
diff --git a/app/api/excel_talk.py b/app/api/excel_talk.py
deleted file mode 100644
index ad4a416..0000000
--- a/app/api/excel_talk.py
+++ /dev/null
@@ -1,69 +0,0 @@
-import asyncio
-import json
-from enum import Enum
-
-from fastapi import APIRouter, Depends
-from sqlalchemy.orm import Session
-from starlette.websockets import WebSocket, WebSocketDisconnect
-
-from app.api import get_current_user_websocket
-from app.config.config import settings
-from app.models import UserModel, AgentModel
-from app.models.base_model import get_db
-from app.service.basic import BasicService
-
-router = APIRouter()
-
-# class CompletionRequest(BaseModel):
-#     id: Optional[str] = None
-#     app_id: str
-#     message: str
-#
-# class DownloadRequest(BaseModel):
-#     file_id: str
-#     app_id: str
-#     file_type: Optional[str] = None
-
-
-class AdvancedAgentID(Enum):
-    EXCEL_TALK = "excel_talk"
-    QUESTIONS_TALK = "questions_talk"
-
-@router.websocket("/ws/{agent_id}/{chat_id}")
-async def handle_client(websocket: WebSocket,
-                        agent_id: str,
-                        chat_id: str,
-                        current_user: UserModel = Depends(get_current_user_websocket),
-                        db: Session = Depends(get_db)):
-    await websocket.accept()
-    print(f"Client {agent_id} connected")
-
-    service = BasicService(base_url=settings.basic_base_url)
-
-    agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
-    if not agent:
-        ret = {"message": "Agent not found", "type": "close"}
-        await websocket.send_json(ret)
-        return
-    try:
-        while True:
-            # 鎺ユ敹鍓嶇娑堟伅
-            message = await websocket.receive_json()
-            question = message.get("message")
-            if not question:
-                await websocket.send_json({"message": "Invalid request", "type": "error"})
-                continue
-
-            # 璋冪敤 excel_talk 鏂规硶
-            result = await service.excel_talk(question, chat_id)
-
-            # 灏嗙粨鏋滃彂閫佸洖鍓嶇
-            await websocket.send_json({"message": result, "type": "response"})
-    except Exception as e:
-        await websocket.send_json({"message": str(e), "type": "error"})
-    finally:
-        await websocket.close()
-        print(f"Client {agent_id} disconnected")
-
-
-
diff --git a/app/api/files.py b/app/api/files.py
index 863f174..8faa011 100644
--- a/app/api/files.py
+++ b/app/api/files.py
@@ -1,5 +1,5 @@
 import io
-from typing import Optional
+from typing import Optional, List
 
 import requests
 from fastapi import Depends, APIRouter, HTTPException, UploadFile, File, Query, Form
@@ -23,48 +23,69 @@
 
 
 @router.post("/upload/{agent_id}", response_model=Response)
-async def upload_file(agent_id: str,
-                      file: UploadFile = File(...),
-                      chat_id: str = Query(None, description="The ID of the chat"),
-                      db: Session = Depends(get_db),
-                      current_user: UserModel = Depends(get_current_user)
-                      ):
+async def upload_files(
+    agent_id: str,
+    file: List[UploadFile] = File(...),  # 淇敼杩欓噷锛屾帴鍙楁枃浠跺垪琛�
+    chat_id: str = Query(None, description="The ID of the chat"),
+    db: Session = Depends(get_db),
+    current_user: UserModel = Depends(get_current_user)
+):
     agent = db.query(AgentModel).filter(AgentModel.id == agent_id).first()
     if not agent:
         return Response(code=404, msg="Agent not found")
-    # 璇诲彇涓婁紶鐨勬枃浠跺唴瀹�
-    try:
-        file_content = await file.read()
-    except Exception as e:
-        return Response(code=400, msg=str(e))
 
-    if agent.agent_type == AgentType.RAGFLOW:
-        token = get_ragflow_token(db, current_user.id)
-        ragflow_service = RagflowService(base_url=settings.fwr_base_url)
-        # 鏌ヨ浼氳瘽鏄惁瀛樺湪锛屼笉瀛樺湪鍏堝垱寤轰細璇�
-        history = await ragflow_service.get_session_history(token, chat_id)
-        if len(history) == 0:
-            message = {"role": "user", "message": file.filename}
-            await ragflow_service.set_session(token, agent_id, message, chat_id, True)
+    # 妫�鏌� agent 绫诲瀷锛岀‘瀹氭槸鍚﹀厑璁镐笂浼犲涓枃浠�
+    if agent.agent_type in [AgentType.RAGFLOW, AgentType.BISHENG]:
+        if len(file) > 1:
+            return Response(code=400, msg="杩欎釜鏅鸿兘浣撳彧鏀寔浼犲崟涓枃浠�")
 
-        ragflow_service = RagflowService(base_url=settings.fwr_base_url)
-        token = get_ragflow_token(db, current_user.id)
-        doc_ids = await ragflow_service.upload_and_parse(token, chat_id, file.filename, file_content)
-        return Response(code=200, msg="", data={"doc_ids": doc_ids, "file_name": file.filename})
-
-    elif agent.agent_type == AgentType.BISHENG:
-        bisheng_service = BishengService(base_url=settings.sgb_base_url)
+    if agent.agent_type == AgentType.RAGFLOW or agent.agent_type == AgentType.BISHENG:
+        file = file[0]
+        # 璇诲彇涓婁紶鐨勬枃浠跺唴瀹�
         try:
-            token = get_bisheng_token(db, current_user.id)
-            result = await bisheng_service.upload(token, file.filename, file_content)
+            file_content = await file.read()
         except Exception as e:
-            raise HTTPException(status_code=500, detail=str(e))
-        result["file_name"] = file.filename
-        return Response(code=200, msg="", data=result)
+            return Response(code=400, msg=str(e))
+
+        if agent.agent_type == AgentType.RAGFLOW:
+            token = get_ragflow_token(db, current_user.id)
+            ragflow_service = RagflowService(base_url=settings.fwr_base_url)
+            # 鏌ヨ浼氳瘽鏄惁瀛樺湪锛屼笉瀛樺湪鍏堝垱寤轰細璇�
+            history = await ragflow_service.get_session_history(token, chat_id)
+            if len(history) == 0:
+                message = {"role": "user", "message": file.filename}
+                await ragflow_service.set_session(token, agent_id, message, chat_id, True)
+
+            doc_ids = await ragflow_service.upload_and_parse(token, chat_id, file.filename, file_content)
+            # 瀵逛簬澶氭枃浠讹紝鍙兘闇�瑕佹敹闆嗘墍鏈塪oc_ids
+            return Response(code=200, msg="", data={"doc_ids": doc_ids, "file_name": file.filename})
+
+        elif agent.agent_type == AgentType.BISHENG:
+            bisheng_service = BishengService(base_url=settings.sgb_base_url)
+            try:
+                token = get_bisheng_token(db, current_user.id)
+                result = await bisheng_service.upload(token, file.filename, file_content)
+            except Exception as e:
+                raise HTTPException(status_code=500, detail=str(e))
+            result["file_name"] = file.filename
+            return Response(code=200, msg="", data=result)
+
     elif agent.agent_type == AgentType.BASIC:
         if agent_id == "basic_excel_talk":
+            # 澶勭悊鍗曚釜鏂囦欢鐨勬儏鍐�
+            file_list = file
+            if len(file) == 1 and agent.agent_type != AgentType.BASIC:
+                file_list = [file[0]]  # 濡傛灉鍙湁涓�涓枃浠讹紝纭繚瀹冩槸涓�涓垪琛�
             service = BasicService(base_url=settings.basic_base_url)
-            result = await service.excel_talk_upload(chat_id, file.filename, file_content)
+            # 閬嶅巻file_list锛屽瓨鍒癴iles 鍒楄〃涓�
+            files = []
+            for item in file_list:
+                file_content = await item.read()
+                files.append(('files', (item.filename, file_content, 'application/octet-stream')))
+
+            result = await service.excel_talk_upload(chat_id, files)
+            if not result:
+                return Response(code=400, msg="涓婁紶鏂囦欢鍑洪敊")
 
             return Response(code=200, msg="", data=result)
 
@@ -72,10 +93,7 @@
             service = BasicService(base_url=settings.basic_paper_url)
             result = await service.paper_file_upload(chat_id, file.filename, file_content)
 
-            return Response(code=200, msg="", data=result)
-
-    else:
-        return Response(code=200, msg="Unsupported agent type")
+        return Response(code=200, msg="", data=result)
 
 
 @router.get("/download/", response_model=Response)
diff --git a/app/service/basic.py b/app/service/basic.py
index d93782e..26c15c1 100644
--- a/app/service/basic.py
+++ b/app/service/basic.py
@@ -1,6 +1,7 @@
 import json
 
 import httpx
+import requests
 
 from Log import logger
 
@@ -44,12 +45,9 @@
         url = f"{self.base_url}/exceltalk/download/excel"
         return await self.download_from_url(url, params={'excel_name': file_id})
 
-    async def excel_talk_upload(self, chat_id: str, filename: str, file_content: bytes):
+    async def excel_talk_upload(self, chat_id: str, files):
         url = f"{self.base_url}/exceltalk/upload/files"
         params = {'chat_id': chat_id, 'is_col': '0'}
-
-        # 鍒涘缓 FormData 瀵硅薄
-        files = [('files', (filename, file_content, 'application/octet-stream'))]
 
         async with httpx.AsyncClient() as client:
             response = await client.post(
@@ -64,28 +62,25 @@
         params = {'chat_id': chat_id}
         data = {"query": question}
         headers = {'Content-Type': 'application/json'}
-        buffer = bytearray()
-        async with httpx.AsyncClient(timeout=300.0) as client:
-            async with client.stream("POST", url, params=params, json=data, headers=headers) as response:
-                if response.status_code == 200:
+        with requests.post(url, headers=headers, json=data, params=params, timeout=60,
+                           stream=True) as response:
+            for line in response.iter_lines():
+                if line:
+                    decoded_line = line.decode("utf-8")
                     try:
-                        async for chunk in response.aiter_bytes():
-                            json_data = process_buffer(chunk, buffer)
-                            if json_data:
-                                yield json_data
-                                buffer.clear()
+                        if decoded_line.startswith("data:"):
+                            decoded_line = decoded_line[5:]
+                        answer = json.loads(decoded_line)
+                        yield answer
                     except GeneratorExit as e:
                         print(e)
                         yield {"message": "鍐呴儴閿欒", "type": "close"}
                     finally:
-                        # 鍦ㄦ墍鏈夋暟鎹帴鏀跺畬姣曞悗璁板綍鏃ュ織
-                        logger.info("All messages received and processed - over")
+                        # 鍦ㄦ墍鏈夋暟鎹帴鏀跺畬姣曞悗杩斿洖close
                         yield {"message": "", "type": "close"}
 
                 else:
                     yield f"Error: {response.status_code}"
-
-
 
     async def questions_talk(self, question, chat_id: str):
         logger.error("---------------questions_talk--------------------------")
@@ -103,27 +98,4 @@
 
     async def questions_talk_word_download(self, file_id: str):
         url = f"{self.base_url}/questions/download/word"
-        return await self.download_from_url(url, params={'word_name': file_id})
-
-
-def process_buffer(data, buffer):
-    def try_parse_json(data1):
-        try:
-            return True, json.loads(data1)
-        except json.JSONDecodeError:
-            return False, None
-
-    if data.startswith(b'data:'):
-        # 鍒犻櫎 'data:' 澶�
-        data = data[5:].strip()
-    else:
-        pass
-
-    # 鐩存帴鎷兼帴鍒扮紦鍐插尯灏濊瘯瑙f瀽JSON
-    buffer.extend(data.strip())
-    success, parsed_data = try_parse_json(buffer)
-    if success:
-        return parsed_data
-    else:
-        # 瑙f瀽澶辫触锛岀户缁嫾鎺�
-        return None
+        return await self.download_from_url(url, params={'word_name': file_id})
\ No newline at end of file

--
Gitblit v1.8.0