"""fix_linkfire_metrics_format

Revision ID: ffaf24bebdb0
Revises: e9fa68d476a6
Create Date: 2021-09-28 09:20:14.993414

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ffaf24bebdb0'
down_revision = 'e9fa68d476a6'
branch_labels = None
depends_on = None

linkfire_metrics_ids = [72, 73, 75, 77, 78, 79, 80]


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

    # Change Linkfire Metrics format to percentages
    op.execute(
        metrics_table.update().values(
            format_id=3
        ).where(metrics_table.c.id.in_(linkfire_metrics_ids))
    )


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

    # Change Linkfire Metrics format back to decimals
    op.execute(
        metrics_table.update().values(
            format_id=8
        ).where(metrics_table.c.id.in_(linkfire_metrics_ids))
    )