"""change_metrcis_field_description

Revision ID: 81ba9760458d
Revises: 66b1d16db276
Create Date: 2021-03-12 13:51:37.031336

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '81ba9760458d'
down_revision = '66b1d16db276'
branch_labels = None
depends_on = None


def upgrade():
    op.execute(
        """
            UPDATE "MetricsField"
            SET total_name = 'Total CPM',
                description = 'Overall cost per 1,000 impressions for all data in selected range.'
            WHERE name = 'CPM';
        """
    )
    op.execute(
        """
            DELETE FROM "MetricsField"
            WHERE id in (12, 13);
        """
    )


def downgrade():
    pass