"""rename_cost_per_conversion_field

Revision ID: faf37068df31
Revises: d474e086de55
Create Date: 2020-11-20 15:25:59.697642

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'faf37068df31'
down_revision = 'd474e086de55'
branch_labels = None
depends_on = None


def get_table(bind, table_name: str):
    meta = sa.MetaData(bind=bind)
    meta.reflect()
    return meta.tables[table_name]


def upgrade():
    bind = op.get_bind()
    metrics_field_table = get_table(bind, "MetricsField")

    op.execute(metrics_field_table.update().where(metrics_field_table.c.id == 33).values(
        title="Landing Page View",
        name="CP Landing Page View"
    ))


def downgrade():
    bind = op.get_bind()
    metrics_field_table = get_table(bind, "MetricsField")

    op.execute(metrics_field_table.update().where(metrics_field_table.c.id == 33).values(
        title="Landing Page Views",
        name="CP Landing Page Views"
    ))