aiverse / app /db /models /message.py
junaidte14's picture
aiverse backend to hf
3821102
Raw History Blame Contribute Delete
1.92 kB
"""
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"<Message(id={self.id}, role='{self.role}', content='{content_preview}')>"
)