from sqlalchemy import Column, Integer, String, Float, DateTime, Text
from sqlalchemy.orm import relationship
from datetime import datetime
import uuid

class StreamMetadata(Base):
    __tablename__ = 'stream_metadata'

    id = Column(Integer, primary_key=True, index=True)
    movie_id = Column(String(255), nullable=False, unique=True)
    title = Column(String(255), nullable=False)
    description = Column(Text, nullable=True)
    duration = Column(Integer, nullable=True)  # en segundos
    resolution = Column(String(10), nullable=True)  # ej: '1080p', '720p'
    codec = Column(String(50), nullable=True)  # ej: 'h264', 'hevc'
    bitrate = Column(Integer, nullable=True)
    created_at = Column(DateTime, default=datetime.utcnow)
    updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)

    # Relaciones
    movie = relationship('Movie', back_populates='stream_metadata')