Files
mtusi2026lab4-fork/app/models.py
2026-11-06 13:57:29 +03:00

105 lines
3.5 KiB
Python

"""ORM-модели таблиц; схема и ограничения задаются миграциями."""
import uuid
from datetime import datetime
from sqlalchemy import DateTime, func
from sqlalchemy.dialects.postgresql import ARRAY, UUID
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
NOW = func.clock_timestamp()
class Base(DeclarativeBase):
"""Базовый класс моделей."""
class User(Base):
"""Пользователь; пароль хранится только как хеш."""
__tablename__ = "users"
id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
username: Mapped[str]
display_name: Mapped[str]
password_hash: Mapped[str]
created_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=NOW
)
class Chat(Base):
"""Чат."""
__tablename__ = "chats"
id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
title: Mapped[str]
created_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=NOW
)
class ChatMember(Base):
"""Участие пользователя в чате."""
__tablename__ = "chat_members"
chat_id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
user_id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
class Message(Base):
"""Сообщение чата."""
__tablename__ = "messages"
id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
chat_id: Mapped[uuid.UUID]
sender_id: Mapped[uuid.UUID]
text: Mapped[str]
attachment_ids: Mapped[list[uuid.UUID]] = mapped_column(ARRAY(UUID(as_uuid=True)), default=list)
created_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=NOW
)
class SessionRow(Base):
"""Сессия входа; хранится SHA-256 токена."""
__tablename__ = "sessions"
token_hash: Mapped[str] = mapped_column(primary_key=True)
user_id: Mapped[uuid.UUID]
created_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=NOW
)
expires_at: Mapped[datetime] = mapped_column(DateTime(timezone=True))
class MessageRequest(Base):
"""Общий результат POST сообщения; область ключа — пользователь и чат."""
__tablename__ = "message_requests"
user_id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
chat_id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
key: Mapped[str] = mapped_column(primary_key=True)
request_text: Mapped[str]
request_attachment_ids: Mapped[list[uuid.UUID]] = mapped_column(ARRAY(UUID(as_uuid=True)), default=list)
message_id: Mapped[uuid.UUID]
expires_at: Mapped[datetime] = mapped_column(DateTime(timezone=True))
class Attachment(Base):
"""Метаданные и устойчивое намерение upload; бинарные данные только в S3."""
__tablename__ = "attachments"
id: Mapped[uuid.UUID] = mapped_column(primary_key=True)
chat_id: Mapped[uuid.UUID]
owner_id: Mapped[uuid.UUID]
filename: Mapped[str]
object_key: Mapped[str]
content_type: Mapped[str]
size_bytes: Mapped[int]
sha256: Mapped[str]
width: Mapped[int]
height: Mapped[int]
status: Mapped[str]
updated_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=NOW)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=NOW)