NexLab_System / app /models /messaging.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
2.13 kB
# app/models/messaging.py
# Chat, ChatMember, Message, MessageReceipt models.
from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field
class Chat(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
is_group: bool = Field(default=False)
name: Optional[str] = None
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_at: Optional[datetime] = None
class ChatMember(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
chat_id: int = Field(foreign_key="chat.id", index=True)
user_id: int = Field(foreign_key="user.id", index=True)
joined_at: datetime = Field(default_factory=datetime.now)
is_admin: bool = Field(default=False)
last_read_message_id: Optional[int] = None
class Message(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
chat_id: int = Field(foreign_key="chat.id", index=True)
sender_id: Optional[int] = Field(default=None, foreign_key="user.id", index=True)
text: Optional[str] = None
attachment_path: Optional[str] = None
attachment_name: Optional[str] = None
attachment_type: Optional[str] = None
voice_note_path: Optional[str] = None
voice_note_duration: Optional[int] = None
reply_to_id: Optional[int] = Field(default=None, foreign_key="message.id")
created_at: datetime = Field(default_factory=datetime.now)
is_deleted: bool = Field(default=False)
is_call: bool = Field(default=False)
call_type: Optional[str] = None
call_status: Optional[str] = None
call_duration: Optional[int] = None
class MessageReceipt(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
message_id: int = Field(foreign_key="message.id", index=True)
user_id: int = Field(foreign_key="user.id", index=True)
chat_id: int = Field(foreign_key="chat.id", index=True)
status: str = Field(default="delivered")
updated_at: datetime = Field(default_factory=datetime.now)