"""erase_taxonomy_v2

Revision ID: 643ead0cd31d
Revises: ddacf0175c71
Create Date: 2020-08-10 12:54:30.205797

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '643ead0cd31d'
down_revision = 'ddacf0175c71'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    bind = op.get_bind()
    bind.execute("""DELETE FROM "Campaign" """)
    bind.execute("""
        TRUNCATE
            "CampaignTypeCategory",
            "CampaignTypeCategoryValue",
            "CampaignTypeCity",
            "CampaignTypeGroup",
            "CampaignTypeValue",
            "CampaignTypeWidget"
        RESTART IDENTITY CASCADE;
    """)

    pass
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###