"""长视频合成引擎的数据面:时间线、片段、字幕、音轨、导出记录。""" from __future__ import annotations from datetime import datetime from sqlalchemy import JSON, Boolean, Float, ForeignKey, Integer, String, Text, DateTime from sqlalchemy.orm import Mapped, mapped_column, relationship from app.models.base import TimestampMixin, now_utc from app.db import Base class Timeline(TimestampMixin, Base): __tablename__ = "timelines" id: Mapped[int] = mapped_column(primary_key=True) project_id: Mapped[int] = mapped_column(ForeignKey("projects.id", ondelete="CASCADE"), index=True) name: Mapped[str] = mapped_column(String(160), default="主时间线") version: Mapped[int] = mapped_column(Integer, default=1) is_current: Mapped[bool] = mapped_column(Boolean, default=True) fps: Mapped[int] = mapped_column(Integer, default=24) width: Mapped[int] = mapped_column(Integer, default=1920) height: Mapped[int] = mapped_column(Integer, default=1080) sample_rate: Mapped[int] = mapped_column(Integer, default=48000) total_duration_ms: Mapped[int] = mapped_column(Integer, default=0) settings_json: Mapped[dict] = mapped_column(JSON, default=dict) # burn_subtitle / 字幕样式 / 响度 / 配乐音量 segments: Mapped[list["TimelineSegment"]] = relationship( back_populates="timeline", cascade="all, delete-orphan", order_by="TimelineSegment.order_index", lazy="selectin") subtitles: Mapped[list["SubtitleCue"]] = relationship( back_populates="timeline", cascade="all, delete-orphan", order_by="SubtitleCue.start_ms", lazy="selectin") audio_clips: Mapped[list["AudioClip"]] = relationship( back_populates="timeline", cascade="all, delete-orphan", order_by="AudioClip.start_ms", lazy="selectin") class TimelineSegment(TimestampMixin, Base): __tablename__ = "timeline_segments" id: Mapped[int] = mapped_column(primary_key=True) timeline_id: Mapped[int] = mapped_column(ForeignKey("timelines.id", ondelete="CASCADE"), index=True) shot_id: Mapped[int | None] = mapped_column(ForeignKey("shots.id", ondelete="SET NULL"), nullable=True, index=True) order_index: Mapped[int] = mapped_column(Integer, default=1) label: Mapped[str] = mapped_column(String(200), default="") source_path: Mapped[str] = mapped_column(String(600), default="") start_ms: Mapped[int] = mapped_column(Integer, default=0) duration_ms: Mapped[int] = mapped_column(Integer, default=0) source_in_ms: Mapped[int] = mapped_column(Integer, default=0) source_out_ms: Mapped[int] = mapped_column(Integer, default=0) transition_out: Mapped[str] = mapped_column(String(30), default="cut") transition_duration_ms: Mapped[int] = mapped_column(Integer, default=0) volume: Mapped[float] = mapped_column(Float, default=1.0) muted: Mapped[bool] = mapped_column(Boolean, default=False) timeline: Mapped[Timeline] = relationship(back_populates="segments") class SubtitleCue(TimestampMixin, Base): __tablename__ = "subtitle_cues" id: Mapped[int] = mapped_column(primary_key=True) timeline_id: Mapped[int] = mapped_column(ForeignKey("timelines.id", ondelete="CASCADE"), index=True) shot_id: Mapped[int | None] = mapped_column(ForeignKey("shots.id", ondelete="SET NULL"), nullable=True, index=True) start_ms: Mapped[int] = mapped_column(Integer, default=0) end_ms: Mapped[int] = mapped_column(Integer, default=0) text: Mapped[str] = mapped_column(Text, default="") speaker: Mapped[str] = mapped_column(String(120), default="") emphasis: Mapped[bool] = mapped_column(Boolean, default=False) timeline: Mapped[Timeline] = relationship(back_populates="subtitles") class AudioClip(TimestampMixin, Base): __tablename__ = "audio_clips" id: Mapped[int] = mapped_column(primary_key=True) timeline_id: Mapped[int] = mapped_column(ForeignKey("timelines.id", ondelete="CASCADE"), index=True) shot_id: Mapped[int | None] = mapped_column(ForeignKey("shots.id", ondelete="SET NULL"), nullable=True, index=True) kind: Mapped[str] = mapped_column(String(20), default="voiceover") # voiceover / bgm / sfx label: Mapped[str] = mapped_column(String(200), default="") source_path: Mapped[str] = mapped_column(String(600), default="") start_ms: Mapped[int] = mapped_column(Integer, default=0) duration_ms: Mapped[int] = mapped_column(Integer, default=0) gain_db: Mapped[float] = mapped_column(Float, default=0.0) loop: Mapped[bool] = mapped_column(Boolean, default=False) voice_asset_id: Mapped[int | None] = mapped_column(Integer, nullable=True) text: Mapped[str] = mapped_column(Text, default="") ducking: Mapped[bool] = mapped_column(Boolean, default=True) # True = 这条「配音」其实是镜头产物自带的原声(MiniMax H3 这类一次成片模型)。 # 原声天生和口型同步:入点不加 lead 留白、片段不再为配音拉长定格、 # 混音时把该片段的原生总线静音,避免同一段人声混两遍。 native_audio: Mapped[bool] = mapped_column(Boolean, default=False) timeline: Mapped[Timeline] = relationship(back_populates="audio_clips") class ExportRecord(TimestampMixin, Base): __tablename__ = "export_records" id: Mapped[int] = mapped_column(primary_key=True) project_id: Mapped[int] = mapped_column(ForeignKey("projects.id", ondelete="CASCADE"), index=True) timeline_id: Mapped[int | None] = mapped_column(ForeignKey("timelines.id", ondelete="SET NULL"), nullable=True, index=True) task_id: Mapped[int | None] = mapped_column(Integer, nullable=True, index=True) name: Mapped[str] = mapped_column(String(200), default="") preset: Mapped[str] = mapped_column(String(60), default="hq_1080p") status: Mapped[str] = mapped_column(String(20), default="queued", index=True) path: Mapped[str | None] = mapped_column(String(600), nullable=True) size_bytes: Mapped[int] = mapped_column(Integer, default=0) duration_ms: Mapped[int] = mapped_column(Integer, default=0) width: Mapped[int] = mapped_column(Integer, default=0) height: Mapped[int] = mapped_column(Integer, default=0) fps: Mapped[int] = mapped_column(Integer, default=0) checksum: Mapped[str] = mapped_column(String(80), default="") subtitle_burned: Mapped[bool] = mapped_column(Boolean, default=False) error_message: Mapped[str] = mapped_column(Text, default="") started_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True) finished_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True)