Dbu-central-bot / app /db /models /pending.py
cipher-attacks's picture
stage 1
b37ebd1
Raw History Blame Contribute Delete
1 kB
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())