From 7666bdbabfb929f98e94310dbe99eabb435898a2 Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期二, 07 一月 2025 15:03:07 +0800
Subject: [PATCH] tmp

---
 app/models/v2/session_model.py |   19 ++++++++++++++-----
 1 files changed, 14 insertions(+), 5 deletions(-)

diff --git a/app/models/v2/session_model.py b/app/models/v2/session_model.py
index f6894c0..1bebe2f 100644
--- a/app/models/v2/session_model.py
+++ b/app/models/v2/session_model.py
@@ -5,7 +5,7 @@
 
 import pytz
 from pydantic import BaseModel
-from sqlalchemy import Column, String, Enum as SQLAlchemyEnum, Integer, DateTime, JSON, TEXT
+from sqlalchemy import Column, String, Integer, DateTime, JSON, TEXT, Index
 
 from app.models.agent_model import AgentType
 # from app.models import current_time
@@ -16,16 +16,24 @@
     return datetime.now(tz)
 
 class SessionModel(Base):
-    __tablename__ = "sessions"
-    id = Column(String(255), primary_key=True)
+    __tablename__ = "chat_sessions"
+
+    __table_args__ = (
+        Index('idx_username', 'username'),
+    )
+
+    id = Column(Integer, primary_key=True)
     name = Column(String(255))
     agent_id = Column(String(255))
-    agent_type = Column(SQLAlchemyEnum(AgentType), nullable=False)  # 鐩墠鍙瓨basic鐨勶紝ragflow鍜宐isheng鐨勮皟鎺ュ彛鑾峰彇
+    agent_type = Column(Integer)  # 鐩墠鍙瓨basic鐨勶紝ragflow鍜宐isheng鐨勮皟鎺ュ彛鑾峰彇
     create_date = Column(DateTime, default=current_time)  # 鍒涘缓鏃堕棿锛岄粯璁ゅ�间负褰撳墠鏃跺尯鏃堕棿
-    update_date = Column(DateTime, default=current_time, onupdate=current_time)  # 鏇存柊鏃堕棿锛岄粯璁ゅ�间负褰撳墠鏃跺尯鏃堕棿锛屾洿鏂版椂鑷姩鏇存柊
+    update_date = Column(DateTime, default=current_time, onupdate=current_time, index=True)  # 鏇存柊鏃堕棿锛岄粯璁ゅ�间负褰撳墠鏃跺尯鏃堕棿锛屾洿鏂版椂鑷姩鏇存柊
     tenant_id = Column(Integer)  # 鍒涘缓浜�
     message = Column(TEXT)  # 璇存槑
+    reference = Column(TEXT)  # 璇存槑
     conversation_id = Column(String(64))
+    session_id = Column(String(36), index=True)
+    chat_mode = Column(Integer)
 
     # to_dict 鏂规硶
     def to_dict(self):
@@ -63,3 +71,4 @@
 class ChatDialogData(BaseModel):
     sessionId: Optional[str] = ""
     question: str
+    chatId: str

--
Gitblit v1.8.0