"""MarketingAccount model."""
from enum import Enum

from db import db


class MarketingAccountType(Enum):  # deprecated
    GOOGLE = 0
    FACEBOOK = 1


class MarketingAccountSource(Enum):
    GOOGLE = "google"
    FACEBOOK = "facebook"
    TIKTOK = "tiktok"


class MarketingAccount(db.Model):
    """MarketingAccount model."""

    __tablename__ = "MarketingAccount"

    id = db.Column(db.Integer, primary_key=True)
    label_id = db.Column(db.Integer, db.ForeignKey("Label.id"), nullable=False)
    external_id = db.Column(db.String, nullable=False, index=True)
    provider_id = db.Column(db.Integer, db.ForeignKey("CampaignProvider.id"), nullable=False)
    type = db.Column(db.Integer, nullable=False)  # deprecated
    name = db.Column(db.String)
    source = db.Column(db.String)
    currency = db.Column(db.String)
    label = db.relationship("Label")
    provider = db.relationship("CampaignProvider")

    __table_args__ = (db.UniqueConstraint("external_id", name="uq_MarketingAccount_external_id"),)