from datetime import datetime from typing import Optional from sqlalchemy import BigInteger, DateTime, Integer, String, func from sqlalchemy.orm import Mapped, mapped_column from app.db.base import Base class PendingMaterial(Base): """Filled later by the separate collector userbot; approved by an admin.""" __tablename__ = "pending_materials" id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True) source_chat_id: Mapped[Optional[int]] = mapped_column(BigInteger) source_message_id: Mapped[Optional[int]] = mapped_column(BigInteger) file_name: Mapped[Optional[str]] = mapped_column(String(256)) caption: Mapped[Optional[str]] = mapped_column(String(1024)) file_unique_id: Mapped[Optional[str]] = mapped_column(String(128), unique=True) status: Mapped[str] = mapped_column(String(16), default="pending") # pending|approved|rejected created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())