YT-Automation / core /models.py
Vinoth
feat: switch to Supabase cloud database and optimize for cloud deployment
9d8ff93
Raw History Blame Contribute Delete
4.28 kB
from sqlalchemy import Column, Integer, String, DateTime, ForeignKey, Float, Text, JSON, Enum as SQLEnum
from sqlalchemy.orm import relationship, declarative_base
from sqlalchemy.sql import func
import enum
Base = declarative_base()
class JobState(enum.Enum):
SCHEDULED = "scheduled"
GENERATING_SCRIPT = "generating_script"
GENERATING_AUDIO = "generating_audio"
GENERATING_VISUALS = "generating_visuals"
RENDERING_DRAFT = "rendering_draft"
AWAITING_APPROVAL = "awaiting_approval"
UPLOADING = "uploading"
UPLOADED = "uploaded"
FAILED = "failed"
PAUSED = "paused"
class ContentType(enum.Enum):
SHORT = "short"
VIDEO = "video"
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True)
telegram_id = Column(Integer, unique=True, nullable=False)
timezone = Column(String, default="UTC")
approval_mode = Column(String, default="manual")
voice_profile = Column(String)
schedules = relationship("Schedule", back_populates="user")
channels = relationship("Channel", back_populates="user")
class Channel(Base):
__tablename__ = "channels"
id = Column(Integer, primary_key=True)
user_id = Column(Integer, ForeignKey("users.id"))
channel_id = Column(String, unique=True)
oauth_tokens = Column(JSON)
default_category = Column(String)
default_tags = Column(JSON)
user = relationship("User", back_populates="channels")
class Schedule(Base):
__tablename__ = "schedules"
id = Column(Integer, primary_key=True)
user_id = Column(Integer, ForeignKey("users.id"))
content_type = Column(SQLEnum(ContentType), default=ContentType.SHORT)
recurrence = Column(String) # e.g., "daily"
publish_time = Column(String) # e.g., "10:00"
status = Column(String, default="active")
user = relationship("User", back_populates="schedules")
jobs = relationship("Job", back_populates="schedule")
class Job(Base):
__tablename__ = "jobs"
id = Column(Integer, primary_key=True)
schedule_id = Column(Integer, ForeignKey("schedules.id"), nullable=True)
planned_date = Column(DateTime)
state = Column(SQLEnum(JobState), default=JobState.SCHEDULED)
originality_score = Column(Float)
voice_mode = Column(String)
upload_mode = Column(String)
created_at = Column(DateTime, server_default=func.now())
schedule = relationship("Schedule", back_populates="jobs")
script = relationship("ScriptAsset", back_populates="job", uselist=False)
audio = relationship("AudioAsset", back_populates="job", uselist=False)
video = relationship("VideoAsset", back_populates="job", uselist=False)
approvals = relationship("ApprovalAction", back_populates="job")
class ScriptAsset(Base):
__tablename__ = "script_assets"
id = Column(Integer, primary_key=True)
job_id = Column(Integer, ForeignKey("jobs.id"))
topic = Column(String)
script_text = Column(Text)
hook_style = Column(String)
similarity_score = Column(Float)
title = Column(String)
description = Column(Text)
hashtags = Column(JSON)
job = relationship("Job", back_populates="script")
class AudioAsset(Base):
__tablename__ = "audio_assets"
id = Column(Integer, primary_key=True)
job_id = Column(Integer, ForeignKey("jobs.id"))
model_name = Column(String)
quality_mode = Column(String)
audio_path = Column(String)
duration = Column(Float)
job = relationship("Job", back_populates="audio")
class VideoAsset(Base):
__tablename__ = "video_assets"
id = Column(Integer, primary_key=True)
job_id = Column(Integer, ForeignKey("jobs.id"))
draft_path = Column(String)
final_path = Column(String)
aspect_ratio = Column(String)
visual_mode = Column(String)
job = relationship("Job", back_populates="video")
class ApprovalAction(Base):
__tablename__ = "approval_actions"
id = Column(Integer, primary_key=True)
job_id = Column(Integer, ForeignKey("jobs.id"))
action_type = Column(String) # e.g., "approve", "regenerate"
actor = Column(String) # telegram_id
timestamp = Column(DateTime, server_default=func.now())
notes = Column(Text)
job = relationship("Job", back_populates="approvals")