From 1b417d75a8e24e5ec9fd29e9b75ee53049f3b79e Mon Sep 17 00:00:00 2001
From: zhaoqingang <zhaoqg0118@163.com>
Date: 星期二, 19 十一月 2024 17:13:14 +0800
Subject: [PATCH] 跨域问题

---
 app/models/group_model.py |   43 ++++++++++++++++++++++++-------------------
 1 files changed, 24 insertions(+), 19 deletions(-)

diff --git a/app/models/group_model.py b/app/models/group_model.py
index 52e05a8..bb49da7 100644
--- a/app/models/group_model.py
+++ b/app/models/group_model.py
@@ -10,24 +10,24 @@
 
 
 group_knowledge_table = Table('group_Knowledge', Base.metadata
-                           , Column('group_id', Integer, ForeignKey('group.id'))
-                           , Column('knowledge_id', String(32), ForeignKey('knowledgebase.id')))
+                           , Column('group_id', Integer, ForeignKey('group.id', ondelete='CASCADE'))
+                           , Column('knowledge_id', String(32), ForeignKey('knowledgebase.id', ondelete='CASCADE')))
 
 group_dialog_table = Table('group_dialogs', Base.metadata
-                           , Column('group_id', Integer, ForeignKey('group.id'))
-                           , Column('dialog_id', String(36), ForeignKey('dialogs.id')))
+                           , Column('group_id', Integer, ForeignKey('group.id', ondelete='CASCADE'))
+                           , Column('dialog_id', String(36), ForeignKey('dialogs.id', ondelete='CASCADE')))
 
-group_agent_table = Table('group_agent', Base.metadata
-                           , Column('group_id', Integer, ForeignKey('group.id'))
-                           , Column('agent_id', String(36), ForeignKey('user_canvas.id')))
+group_agent_table = Table('group_canvas', Base.metadata
+                           , Column('group_id', Integer, ForeignKey('group.id', ondelete='CASCADE'))
+                           , Column('canvas_id', String(36), ForeignKey('canvas.id', ondelete='CASCADE')))
 
 group_llm_table = Table('group_llm', Base.metadata
-                           , Column('group_id', Integer, ForeignKey('group.id'))
-                           , Column('llm_id', String(36), ForeignKey('common_llm.id')))
+                           , Column('group_id', Integer, ForeignKey('group.id', ondelete='CASCADE'))
+                           , Column('llm_id', String(36), ForeignKey('common_llm.id', ondelete='CASCADE')))
 
 group_unified_agent_table = Table('group_unified_agent', Base.metadata
-                                    , Column('group_id', Integer, ForeignKey('group.id'))
-                                    ,Column('unified_agent_id', String(36), ForeignKey('unified_agent.id')))
+                                    , Column('group_id', Integer, ForeignKey('group.id', ondelete='CASCADE'))
+                                    ,Column('unified_agent_id', String(36), ForeignKey('unified_agent.id', ondelete='CASCADE')))
 
 
 class GroupModel(Base):
@@ -38,6 +38,7 @@
     status = Column(String(10), nullable=False, default="1")
     created_at = Column(DateTime, default=datetime.now())
     updated_at = Column(DateTime, default=datetime.now(), onupdate=datetime.now())
+    creator = Column(Integer)
 
 
     knowledges = relationship('KnowledgeModel',
@@ -52,18 +53,15 @@
 
     agents = relationship('CanvasModel',
                              secondary=group_agent_table,
-                             backref=backref('groups', lazy='dynamic'),
-                             lazy="dynamic")
+                             backref=backref('groups', lazy='dynamic'))
 
     llms = relationship('CommonLlmModel',
                            secondary=group_llm_table,
-                           backref=backref('groups', lazy='dynamic'),
-                           lazy="dynamic")
+                           backref=backref('groups', lazy='dynamic'))
 
     unified_agents = relationship('UnifiedAgentModel',
                                      secondary=group_unified_agent_table,
-                                     backref=backref('roles', lazy='dynamic'),
-                                     lazy="dynamic")
+                                     backref=backref('groups', lazy='dynamic'))
     def to_dict(self):
         return {
             'groupId': self.id,
@@ -79,8 +77,8 @@
 
 
     def __repr__(self):
-        return '<Role name:%r description:%r iconCls:%r seq:%r>\n' \
-            % (self.NAME, self.DESCRIPTION, self.ICONCLS, self.SEQ)
+        return '<Role name:%r description:%r>\n' \
+            % (self.group_name, self.group_description)
 
     def to_json(self):
         json = {
@@ -129,3 +127,10 @@
     id: int
     user_list: list
 
+
+class GroupResource(BaseModel):
+    id: int
+    agents: list
+    dialogs: list
+    knowledges: list
+

--
Gitblit v1.8.0