Spaces:
Sleeping
Sleeping
File size: 1,393 Bytes
a631409 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | """SQLAlchemy database models for conversations."""
from sqlalchemy import Column, String, Integer, Text, ForeignKey, JSON
from sqlalchemy.orm import relationship
from app.database import Base
import uuid
class DBConversation(Base):
"""Database model for conversations."""
__tablename__ = "conversations"
id = Column(String, primary_key=True, default=lambda: str(uuid.uuid4()))
title = Column(String, default="New Chat")
created_at = Column(String, nullable=False)
updated_at = Column(String, nullable=False)
# Relationship to messages
messages = relationship(
"DBMessage",
back_populates="conversation",
cascade="all, delete-orphan",
order_by="DBMessage.id"
)
class DBMessage(Base):
"""Database model for conversation messages."""
__tablename__ = "messages"
id = Column(Integer, primary_key=True, autoincrement=True)
conversation_id = Column(String, ForeignKey("conversations.id"), nullable=False)
role = Column(String, nullable=False) # 'user' or 'assistant'
content = Column(Text, nullable=False)
timestamp = Column(String, nullable=False)
sources = Column(JSON, default=list) # Stored as JSON array
# Relationship to conversation
conversation = relationship("DBConversation", back_populates="messages")
|