"""update_marketing_mix_widget

Revision ID: 3854f6d74308
Revises: fe1e0b60fbdf
Create Date: 2021-12-09 10:38:18.152031

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '3854f6d74308'
down_revision = '1c077f014706'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    meta = sa.MetaData(bind=bind)
    meta.reflect()
    campaign_groups_table = meta.tables["CampaignTypeGroup"]

    op.execute(
        campaign_groups_table.update().values(
            name="Other"
        ).where(campaign_groups_table.c.id == 4)  # Uncategorized -> Other
    )


def downgrade():
    bind = op.get_bind()
    meta = sa.MetaData(bind=bind)
    meta.reflect()
    campaign_groups_table = meta.tables["CampaignTypeGroup"]

    op.execute(
        campaign_groups_table.update().values(
            name="Uncategorized"
        ).where(campaign_groups_table.c.id == 4)  # Uncategorized <- Other
    )