"""remove_nullable_campaig_ad_links

Revision ID: 81019616f4dd
Revises: 1fc97d27e260
Create Date: 2022-03-16 12:07:48.485280

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '81019616f4dd'
down_revision = '1fc97d27e260'
branch_labels = None
depends_on = None


def upgrade():
    conn = op.get_bind()

    conn.execute('''DELETE FROM "CampaignAdLink" WHERE link is NULL''')

    op.alter_column('CampaignAdLink', 'link', existing_type=sa.VARCHAR(), nullable=False)


def downgrade():
    op.alter_column('CampaignAdLink', 'link', existing_type=sa.VARCHAR(), nullable=True)