from datetime import datetime

from fansifter_common.utils import timezone
from fansifter_common.utils.uuid import uuid_string
from sqlalchemy.orm import Mapped, mapped_column

from ows_text_campaigns.adapters.db import Model


class ArtistRosterMainRep(Model, kw_only=True):
    __tablename__ = "artist_roster_main_rep"

    id: Mapped[str] = mapped_column(primary_key=True, default_factory=uuid_string)
    global_participant_id: Mapped[str]
    vendor_id: Mapped[int]
    subaccount_id: Mapped[int]
    created_at: Mapped[datetime] = mapped_column(default_factory=timezone.now)


class ArtistRoster(Model, kw_only=True):
    __tablename__ = "artist_roster"

    id: Mapped[str] = mapped_column(primary_key=True, default_factory=uuid_string)
    global_participant_id: Mapped[str]
    vendor_id: Mapped[int]
    subaccount_id: Mapped[int]
    created_at: Mapped[datetime] = mapped_column(default_factory=timezone.now)