"""create_prs_service_user

Revision ID: ba05435c32d0
Revises: 4bff89c6c395
Create Date: 2021-02-19 14:05:18.825330

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'ba05435c32d0'
down_revision = '4bff89c6c395'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('User', sa.Column('is_service_account', sa.Boolean(), server_default='FALSE', nullable=False))
    bind = op.get_bind()
    bind.execute('''
        INSERT INTO "User" (email, auth0_id, name, phone, is_service_account)
            VALUES ('prs@prs.com', 'prs', 'PRS', '', True),
                   ('gras@gras.com', 'gras', 'GRAS', '', True);
    ''')

def downgrade():
    op.drop_column('User', 'is_service_account')
    bind = op.get_bind()
    bind.execute(''' DELETE FROM "User" WHERE email IN ('prs@prs.com', 'gras@gras.com') ''')