From 52ba4076f5ad55fdf3239a33a2a376eaa0e0dea5 Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期一, 09 十二月 2024 17:53:01 +0800
Subject: [PATCH] m

---
 app/models/session_model.py |   42 ++++++++++++++++++++++++++++++++++++------
 1 files changed, 36 insertions(+), 6 deletions(-)

diff --git a/app/models/session_model.py b/app/models/session_model.py
index 21bfb7e..b7fae97 100644
--- a/app/models/session_model.py
+++ b/app/models/session_model.py
@@ -1,11 +1,17 @@
 import json
 from datetime import datetime
 from enum import IntEnum
-from sqlalchemy import Column, String, Enum as SQLAlchemyEnum, Integer, DateTime
 
-from app.models import AgentType
+import pytz
+from sqlalchemy import Column, String, Enum as SQLAlchemyEnum, Integer, DateTime, JSON, TEXT
+
+from app.models.agent_model import AgentType
+# from app.models import current_time
 from app.models.base_model import Base
 
+def current_time():
+    tz = pytz.timezone('Asia/Shanghai')
+    return datetime.now(tz)
 
 class SessionModel(Base):
     __tablename__ = "sessions"
@@ -13,8 +19,11 @@
     name = Column(String(255))
     agent_id = Column(String(255))
     agent_type = Column(SQLAlchemyEnum(AgentType), nullable=False)  # 鐩墠鍙瓨basic鐨勶紝ragflow鍜宐isheng鐨勮皟鎺ュ彛鑾峰彇
-    create_date = Column(DateTime)  # 鍒涘缓鏃堕棿
-    update_date = Column(DateTime)  # 鏇存柊鏃堕棿
+    create_date = Column(DateTime, default=current_time)  # 鍒涘缓鏃堕棿锛岄粯璁ゅ�间负褰撳墠鏃跺尯鏃堕棿
+    update_date = Column(DateTime, default=current_time, onupdate=current_time)  # 鏇存柊鏃堕棿锛岄粯璁ゅ�间负褰撳墠鏃跺尯鏃堕棿锛屾洿鏂版椂鑷姩鏇存柊
+    tenant_id = Column(Integer)  # 鍒涘缓浜�
+    message = Column(TEXT)  # 璇存槑
+    conversation_id = Column(String(64))
 
     # to_dict 鏂规硶
     def to_dict(self):
@@ -23,6 +32,27 @@
             'name': self.name,
             'agent_type': self.agent_type,
             'agent_id': self.agent_id,
-            'create_date': self.create_date,
-            'update_date': self.update_date,
+            'create_date': self.create_date.strftime("%Y-%m-%d %H:%M:%S"),
+            'update_date': self.update_date.strftime("%Y-%m-%d %H:%M:%S"),
         }
+
+    def log_to_json(self):
+        return {
+            'id': self.id,
+            'name': self.name,
+            'agent_type': self.agent_type,
+            'agent_id': self.agent_id,
+            'create_date': self.create_date.strftime("%Y-%m-%d %H:%M:%S"),
+            'update_date': self.update_date.strftime("%Y-%m-%d %H:%M:%S"),
+            'message': json.loads(self.message)
+        }
+
+    def add_message(self, message: dict):
+        if self.message is None:
+            self.message = '[]'
+        try:
+            msg = json.loads(self.message)
+            msg.append(message)
+        except Exception as e:
+            return
+        self.message = json.dumps(msg)

--
Gitblit v1.8.0