"""digital_campaign_update_metainfo

Revision ID: 98704a7d4665
Revises: b46b611aebf1
Create Date: 2022-04-12 10:57:48.245966

"""

from alembic import op
import sqlalchemy as sa
from models.campaign import CampaignSourceType


# revision identifiers, used by Alembic.

revision = '98704a7d4665'
down_revision = 'f97d95643973'
branch_labels = None
depends_on = None

external_sources = CampaignSourceType.all_external_sources()


def upgrade():
    bind = op.get_bind()
    bind.execute(
        f''' UPDATE "Campaign" SET metainfo = jsonb_set(metainfo::jsonb, array ['fields', 'platforms'],
        'false'::jsonb, true) WHERE source in {tuple(external_sources)} and is_deleted = false and metainfo ->
        'fields' ->> 'platforms' = 'true'
            '''
    )


def downgrade():
    pass