PRINTFILM: AI short-video marketing and AI short-drama creation platform
"""App settings and upstream model channels."""
from __future__ import annotations
from datetime import datetime
from sqlalchemy import Boolean, DateTime, Integer, JSON, String, Text, func
from sqlalchemy.orm import Mapped, mapped_column
from app.database import Base
class AppSettings(Base):
"""Site-wide settings: logical models, defaults, flat runtime knobs."""
__tablename__ = "app_settings"
id: Mapped[str] = mapped_column(String(32), primary_key=True, default="default")
config_json: Mapped[dict | None] = mapped_column(JSON, nullable=True)
updated_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
)
class MediaPriceVersion(Base):
"""Published price books are append-only; the active pointer lives in AppSettings."""
__tablename__ = "media_price_versions"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
prices: Mapped[dict] = mapped_column(JSON, nullable=False)
created_by: Mapped[int] = mapped_column(Integer, nullable=False)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
class SystemModelChannelRow(Base):
"""Physical upstream provider channel."""
__tablename__ = "system_model_channels"
id: Mapped[str] = mapped_column(String(64), primary_key=True)
name: Mapped[str] = mapped_column(String(128), default="")
base_url: Mapped[str] = mapped_column(String(512), default="")
api_key_ciphertext: Mapped[str | None] = mapped_column(Text, nullable=True)
api_format: Mapped[str] = mapped_column(String(32), default="openai")
protocol: Mapped[str] = mapped_column(String(32), default="auto")
models: Mapped[list | None] = mapped_column(JSON, nullable=True)
enabled: Mapped[bool] = mapped_column(Boolean, default=True)
sort_order: Mapped[int] = mapped_column(Integer, default=0)
advanced_config: Mapped[dict | None] = mapped_column(JSON, nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
updated_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
)