/
asigatchov
/
vb-ai-api
Обзор
Документация
Войти
/
asigatchov
/
vb-ai-api
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
src/database/models/project.py
26 строк
1 KB
Alexander Sigatchov
make reels
26 фев 2026, 18:13
26 фев 2026, 18:13
29591d1
Код
Авторство
О чём код?
from sqlalchemy import Float, ForeignKey, Integer, String from sqlalchemy.orm import Mapped, mapped_column, relationship from .base import Base class Project(Base): __tablename__ = "projects" id: Mapped[str] = mapped_column(String, primary_key=True) user_id: Mapped[str] = mapped_column(ForeignKey("users.id", ondelete="CASCADE"), nullable=False) folder_id: Mapped[str | None] = mapped_column(ForeignKey("folders.id", ondelete="SET NULL"), nullable=True) title: Mapped[str] = mapped_column(String, nullable=False) date: Mapped[str] = mapped_column(String, nullable=False) status: Mapped[str] = mapped_column(String, nullable=False) video_src: Mapped[str] = mapped_column(String, nullable=False) thumbnail_url: Mapped[str | None] = mapped_column(String, nullable=True) frame_width: Mapped[int | None] = mapped_column(Integer, nullable=True) frame_height: Mapped[int | None] = mapped_column(Integer, nullable=True) fps: Mapped[float | None] = mapped_column(Float, nullable=True) user = relationship("User", back_populates="projects") folder = relationship("Folder", back_populates="projects") annotation = relationship("Annotation", back_populates="project", uselist=False, cascade="all, delete-orphan") rallies = relationship("Rally", back_populates="project", cascade="all, delete-orphan") reels = relationship("Reel", back_populates="project", cascade="all, delete-orphan")