"""set_default_metrics_for_user

Revision ID: 51e5d89aabb3
Revises: ab8aae6065b1
Create Date: 2020-10-15 07:16:37.816263

"""
from alembic import op


# revision identifiers, used by Alembic.
revision = '51e5d89aabb3'
down_revision = 'ab8aae6065b1'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    metrics = [16, 40, 47, 22, 30, 35, 43, 49, 50]
    user_ids = bind.execute('''SELECT "User".id FROM "User"''').fetchall()

    for user_id in user_ids:
        [bind.execute(f'''INSERT INTO "UserMetricsField" VALUES ({user_id[0]}, {metric})''') for metric in metrics]


def downgrade():
    bind = op.get_bind()
    bind.execute(f'''DELETE FROM "UserMetricsField"''')