"""FlaggedChannel SQLModel — maps to tblPlaylistSynchronizationFlaggedChannel.

Used by YoutubeSynchronizer to whitelist/blacklist YouTube channels.
"""

from enum import IntEnum
from typing import Optional

from sqlmodel import Field, SQLModel


class ChannelFlagType(IntEnum):
    Whitelist = 0
    Blacklist = 1


class FlaggedChannel(SQLModel, table=True):
    __tablename__ = "tblPlaylistSynchronizationFlaggedChannel"

    id: Optional[int] = Field(default=None, primary_key=True, alias="id")
    channel_id: str = Field(alias="channelId", sa_column_kwargs={"name": "ChannelId"})
    flag_type: int = Field(alias="flagType", sa_column_kwargs={"name": "FlagType"})