"""add_linkfire_link_to_performance

Revision ID: 02ca9e3ceb81
Revises: 140f649d4b5a
Create Date: 2021-07-16 13:09:23.343557

"""
from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision = '02ca9e3ceb81'
down_revision = 'a7d533cdb066'
branch_labels = None
depends_on = None


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

    op.execute(
        performance_breakdown_table.update()
        .values(order=performance_breakdown_table.c.order + 1)
        .where(performance_breakdown_table.c.order >= 7)
    )

    op.execute(performance_breakdown_table.insert().values(name='Linkfire Link', group='Campaign Details', order=7))


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

    op.execute(performance_breakdown_table.delete().where(performance_breakdown_table.c.id == 19))
    op.execute(
        performance_breakdown_table.update()
        .values(order=performance_breakdown_table.c.order - 1)
        .where(performance_breakdown_table.c.order >= 7)
    )