"""fix_cp_sale_metrics_title

Revision ID: d97d6efcb37e
Revises: 6ce596b9d0bc
Create Date: 2020-11-03 14:04:12.389607

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'd97d6efcb37e'
down_revision = '6ce596b9d0bc'
branch_labels = None
depends_on = None

cp_sale_id = 10


def get_metrics_field_table():
    bind = op.get_bind()
    meta = sa.MetaData(bind=bind)
    meta.reflect()

    return meta.tables["MetricsField"]


def upgrade():
    metrics_field_table = get_metrics_field_table()

    op.execute(
        metrics_field_table.update().where(metrics_field_table.c.id == cp_sale_id).values(
            title="Sale",
            subtitle="CP"
        )
    )


def downgrade():
    metrics_field_table = get_metrics_field_table()

    op.execute(
        metrics_field_table.update().where(metrics_field_table.c.id == cp_sale_id).values(
            title="CP",
            subtitle="Sale"
        )
    )