"""fix_metrics_fields_descriptions

Revision ID: 132a25208482
Revises: deca345a03c2
Create Date: 2020-11-11 13:55:11.997352

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '132a25208482'
down_revision = 'deca345a03c2'
branch_labels = None
depends_on = None


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

    return meta.tables["MetricsField"]


def upgrade():
    bind = op.get_bind()
    metrics_field_table = get_metrics_field_table(bind)

    changes = {
        41: {"description": "Percentage of people who watched 95% of the video(s)"},
        39: {"description": "Percentage of people who watched 50% of the video(s)"},
    }

    for field_id, values in changes.items():
        op.execute(metrics_field_table.update().where(metrics_field_table.c.id == field_id).values(**values))


def downgrade():
    bind = op.get_bind()
    metrics_field_table = get_metrics_field_table(bind)

    changes = {
        41: {"description": "Average number of video views where 95% of the video was watched"},
        39: {"description": "Average number of video views where 50% of the video was watched"},
    }

    for field_id, values in changes.items():
        op.execute(metrics_field_table.update().where(metrics_field_table.c.id == field_id).values(**values))