nex_animation/backend/app/models/compose.py

117 lines
6.5 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

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