from sqlmodel import SQLModel, Field
from typing import Optional
from datetime import datetime

class Movie(SQLModel, table=True):
    __tablename__ = "movies"

    id: Optional[str] = Field(default=None, primary_key=True)
    title: str
    path: str
    poster_path: Optional[str] = None
    description: Optional[str] = None
    release_date: Optional[str] = None
    duration: Optional[int] = None
    created_at: datetime = Field(default_factory=datetime.utcnow)
    updated_at: Optional[datetime] = None

    def __repr__(self) -> str:
        return f"Movie(id={self.id}, title={self.title})"