from datetime import datetime

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

from dmp.adapters.db import ReportingModel


class SongwhipPresavePageDbt(ReportingModel, kw_only=True):
    __tablename__ = "songwhip_presave_page_dbt"
    id: Mapped[str] = mapped_column(primary_key=True, unique=True)
    name: Mapped[str]
    path: Mapped[str]
    vendor_id: Mapped[int]
    subaccount_id: Mapped[int]
    global_participant_id: Mapped[str]
    created_at: Mapped[datetime] = mapped_column(default_factory=timezone.now)


class SongwhipPresavePageFanDbt(ReportingModel, kw_only=True):
    __tablename__ = "songwhip_presave_page_fan_dbt"
    id: Mapped[str] = mapped_column(primary_key=True, unique=True)
    fan_id: Mapped[str] = mapped_column(primary_key=True)
    vendor_id: Mapped[int] = mapped_column(primary_key=True)
    subaccount_id: Mapped[int] = mapped_column(primary_key=True)
    global_participant_id: Mapped[str] = mapped_column(primary_key=True)


class SongwhipCustomPageFanDbt(ReportingModel, kw_only=True):
    __tablename__ = "songwhip_custom_page_fan_dbt"
    id: Mapped[str] = mapped_column(primary_key=True)
    fan_id: Mapped[str] = mapped_column(primary_key=True)
    vendor_id: Mapped[int] = mapped_column(primary_key=True)
    subaccount_id: Mapped[int] = mapped_column(primary_key=True)
    global_participant_id: Mapped[str] = mapped_column(primary_key=True)


class SongwhipCustomPageDbt(ReportingModel, kw_only=True):
    __tablename__ = "songwhip_custom_page_dbt"
    id: Mapped[str] = mapped_column(primary_key=True, unique=True)
    name: Mapped[str]
    image: Mapped[str | None]
    path: Mapped[str]
    vendor_id: Mapped[int]
    subaccount_id: Mapped[int]
    global_participant_id: Mapped[str]
    created_at: Mapped[datetime] = mapped_column(default_factory=timezone.now)