from sqlalchemy import Column, Integer, String, Boolean, DateTime, ForeignKey
from sqlalchemy.orm import relationship, declarative_base
from datetime import datetime

Base = declarative_base()

class StreamMetadata(Base):
    __tablename__ = 'stream_metadata'

    id = Column(Integer, primary_key=True)
    movie_id = Column(String(255), nullable=False)
    format = Column(String(50), nullable=False)  # mp4, mkv, etc.
    quality = Column(String(50), nullable=False)  # 720p, 1080p
    output_path = Column(String(500), nullable=False)
    status = Column(String(50), default='ready')
    created_at = Column(DateTime, default=datetime.utcnow)

    def __repr__(self):
        return f'<StreamMetadata {self.movie_id} {self.format}>'