File size: 2,134 Bytes
6ea020b
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
43
44
45
46
47
48
49
50
51
52
53
# 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)