from typing import Optional

from pydantic import ConfigDict
from sqlmodel import Field, SQLModel


class InsertMedia(SQLModel, table=True):
    """Maps to tblPlaylistSynchronizationInsertMedia.

    Tracks a specific media item (e.g. a Spotify track URI) to be inserted
    at a fixed position in the target playlist during synchronization.
    """

    __tablename__ = "tblPlaylistSynchronizationInsertMedia"

    model_config = ConfigDict(populate_by_name=True)  # type: ignore[assignment]

    id: Optional[int] = Field(
        default=None, primary_key=True, sa_column_kwargs={"name": "Id"}
    )
    media_id: str = Field(alias="MediaId", sa_column_kwargs={"name": "MediaId"})
    insert_position: int = Field(
        alias="InsertPosition", sa_column_kwargs={"name": "InsertPosition"}
    )
    playlist_sync_id: int = Field(
        foreign_key="tblPlaylistSynchronization.id",
        alias="PlaylistSynchronizationId",
        sa_column_kwargs={"name": "PlaylistSynchronizationId"},
    )