""" Message database model SQLAlchemy ORM model for conversation messages """ from sqlalchemy import String, DateTime, ForeignKey, Text, Enum as SQLEnum, JSON from sqlalchemy.orm import Mapped, mapped_column, relationship from datetime import datetime import enum from app.db.base import Base from app.db.models.conversation import Conversation class MessageRole(str, enum.Enum): """Message role enumeration""" USER = "user" ASSISTANT = "assistant" SYSTEM = "system" class Message(Base): """ Message model Represents a single message in a conversation """ __tablename__ = "messages" # Primary Key id: Mapped[int] = mapped_column(primary_key=True, index=True) # Foreign Keys conversation_id: Mapped[int] = mapped_column( ForeignKey("conversations.id", ondelete="CASCADE"), nullable=False, index=True ) # Message Information role: Mapped[MessageRole] = mapped_column(SQLEnum(MessageRole), nullable=False) content: Mapped[str] = mapped_column(Text, nullable=False) metadata_json: Mapped[dict | None] = mapped_column(JSON, nullable=True) # Token Information (optional) prompt_tokens: Mapped[int | None] = mapped_column(nullable=True) completion_tokens: Mapped[int | None] = mapped_column(nullable=True) total_tokens: Mapped[int | None] = mapped_column(nullable=True) # Timestamps created_at: Mapped[datetime] = mapped_column( DateTime, default=datetime.utcnow, nullable=False, index=True ) # Relationships conversation: Mapped["Conversation"] = relationship( "Conversation", back_populates="messages" ) def __repr__(self) -> str: content_preview = ( self.content[:50] + "..." if len(self.content) > 50 else self.content ) return ( f"" )