"""add_facebook_marketing_accounts

Revision ID: 03391e33ea8b
Revises: 5a422097ee8b
Create Date: 2020-11-17 12:37:05.328323

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '03391e33ea8b'
down_revision = '5a422097ee8b'
branch_labels = None
depends_on = None

fb_marketing_accounts = [
    {"label_id": 1, "provider_id": 1, "account_ids": [1578898082220650, 237818583774340]},#Columbia Records & SONY
    {"label_id": 1, "provider_id": 2, "account_ids": [249200361]}, # Columbia Records & Gupta

    {"label_id": 2, "provider_id": 1, "account_ids": [2172078946186087] },#Epic Records & Sony
    {"label_id": 2, "provider_id": 2, "account_ids": [108170885940775] },#Epic Records & Gupta

    {"label_id": 3, "provider_id": 1, "account_ids": [220678908623791, 2191370510920980] }, #RCA Records & SONY
    {"label_id": 3, "provider_id": 2, "account_ids": [1377217462493790]},  # RCA Records & Gupta

    {"label_id": 4, "provider_id": 1, "account_ids": [1021693261336790]}, # Legacy & SONY

    {"label_id": 5, "provider_id": 1, "account_ids": [1905498269540420]},  # SME Nashville & SONY
    {"label_id": 5, "provider_id": 2, "account_ids": [105108209658736, 1887479554680002]},  # SME Nashville & Gupta

    {"label_id": 6, "provider_id": 1, "account_ids": [1704153223049150, 272365527010225]},  # SME US Latin & SONY
    {"label_id": 6, "provider_id": 2, "account_ids": [183005119794849, 210070156974883, 1376013932614746]},  # SME US Latin & Gupta

    {"label_id": 8, "provider_id": 1, "account_ids": [2121729928142320, 355257005256501, 10153208127585452]},  # SME Germany & SONY

    {"label_id": 9, "provider_id": 1, "account_ids": [654207068366389, 10154633859042935, 2257399607879318, 1708809069252994, 104202143076853]},  # SME Brasil & SONY

    {"label_id": 13, "provider_id": 1, "account_ids": [1359978377408397]},  # SME Mexico & SONY

    {"label_id": 14, "provider_id": 1, "account_ids": [10152480687163981, 157619175665308]},  # SME España & SONY

    {"label_id": 15, "provider_id": 1, "account_ids": [1387355094731337]},  # Sony Masterworks & SONY
    {"label_id": 15, "provider_id": 2, "account_ids": [1383134378632539]},  # Sony Masterworks & Gupta

    {"label_id": 19, "provider_id": 1, "account_ids": [10152362231207721]},  # SME Argentina & SONY

    {"label_id": 22, "provider_id": 1, "account_ids": [2351639881791021]},  # SME Colombia & SONY

    {"label_id": 23, "provider_id": 1, "account_ids": [192227596]}, # SME Portugal & SONY

    {"label_id": 25, "provider_id": 2, "account_ids": [1047672435265977]},  # SME Netherlands & Gupta

    {"label_id": 29, "provider_id": 2, "account_ids": [10154360480058586]},  # SME Belgium & Gupta

    {"label_id": 36, "provider_id": 1, "account_ids": [2390352294378610, 1376098445939200]},  # SME International US & SONY

    {"label_id": 37, "provider_id": 1, "account_ids": [580362375784985, 241279976492311]}, # SME Global Digital Business & SONY
    {"label_id": 37, "provider_id": 2, "account_ids": [10154355637658586, 10154355643988586]},  # SME Global Digital Business & Gupta

    {"label_id": 39, "provider_id": 2, "account_ids": [227960311301140]},  # SME Central America & Gupta
]

def upgrade():
    bind = op.get_bind()
    meta = sa.MetaData(bind=bind)
    meta.reflect()
    marketing_account_table = meta.tables["MarketingAccount"]
    for account in fb_marketing_accounts:
        for account_id in account["account_ids"]:
            op.execute(
                marketing_account_table.insert().values(
                    label_id=account["label_id"],
                    provider_id=account["provider_id"],
                    external_id=account_id,
                    type=1
                )
            )



def downgrade():
    op.execute(
        """
        DELETE FROM "MarketingAccount" WHERE type=1;
        """
    )