"""add_index_to_campaign_metainfo

Revision ID: e34841cb0721
Revises: 558fafc55e6b
Create Date: 2022-06-01 11:41:09.325717

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = 'e34841cb0721'
down_revision = '558fafc55e6b'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    op.alter_column('Campaign', 'metainfo',
                    existing_type=postgresql.JSON(astext_type=sa.Text()),
                    type_=postgresql.JSONB(astext_type=sa.Text()),
                    existing_nullable=False,
                    existing_server_default=sa.text("'{}'::json"))
    bind.execute('create index ix_campaign_metainfo on "Campaign" using gin(metainfo)')


def downgrade():
    bind = op.get_bind()
    bind.execute('drop index if exists ix_campaign_metainfo')
    op.alter_column('Campaign', 'metainfo',
                    existing_type=postgresql.JSONB(astext_type=sa.Text()),
                    type_=postgresql.JSON(astext_type=sa.Text()),
                    existing_nullable=False,
                    existing_server_default=sa.text("'{}'::json"))