"""campaign_update_metainfo

Revision ID: b46b611aebf1
Revises: 6e16011951ae
Create Date: 2022-03-30 14:54:56.646482

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'b46b611aebf1'
down_revision = 'b2243490c23d'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    bind.execute(
        '''
            UPDATE "Campaign" SET metainfo = jsonb_set(metainfo::jsonb, array ['fields'],
              metainfo::jsonb -> 'fields' || '{"platforms": true}', true)
            WHERE not metainfo ->> 'fields' like '%%platforms%%' and is_deleted = false
            '''
    )


def downgrade():
    pass