"""CampaignPlatforms model."""
from src.db import db


class CampaignPlatforms(db.Model):
    """Campaign Platforms"""

    __tablename__ = "CampaignPlatforms"

    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String, nullable=False, index=True, unique=True)
    label_id = db.Column(
        db.Integer, db.ForeignKey("Label.id", ondelete="CASCADE"), nullable=True
    )
    common = db.Column(db.Boolean, nullable=False, server_default="false")
    platform_group_id = db.Column(
        db.Integer,
        db.ForeignKey("CampaignPlatformGroups.id", ondelete="SET NULL"),
        nullable=True,
    )

    platform_group = db.relationship("CampaignPlatformGroups")
    placements = db.relationship(
        "CampaignPlacements", secondary="CampaignPlatformPlacements"
    )

    def __str__(self):
        return self.name


campaign_platforms_placements = db.Table(
    "CampaignPlatformPlacements",
    db.Model.metadata,
    db.Column(
        "platform_id",
        db.Integer,
        db.ForeignKey("CampaignPlatforms.id", ondelete="CASCADE"),
        nullable=False,
    ),
    db.Column(
        "placement_id",
        db.Integer,
        db.ForeignKey("CampaignPlacements.id", ondelete="CASCADE"),
        nullable=False,
    ),
)