117 lines
6.5 KiB
Python
117 lines
6.5 KiB
Python
"""长视频合成引擎的数据面:时间线、片段、字幕、音轨、导出记录。"""
|
||
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)
|