"""remove_taxonomy_tables

Revision ID: 14a6b4bce5f4
Revises: 72d99002afee
Create Date: 2021-11-19 12:45:47.885885

"""
from alembic import op
from alembic import context
from migrations.fixtures.delphi_tables.v4.data_refresher import DelphiTablesDataRefresher
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '14a6b4bce5f4'
down_revision = 'dbcf68de163d'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    delphi_refresher = DelphiTablesDataRefresher()
    delphi_refresher.drop_triggers(bind)

    bind.execute("""
        DROP TABLE "CampaignCityAndPlacements";
        DROP TABLE "CampaignType";
        DROP TABLE "CampaignTypeCategoryValue";
        DROP TABLE "CampaignTypeValue";
        DROP TABLE "CampaignTypeCategory";
    """)
    delphi_refresher.refresh(bind)


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