"""add_is_assigned_marker_to_gras_project

Revision ID: 81eea94ebf06
Revises: 84a05eaad817
Create Date: 2020-09-17 11:06:08.195890

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '81eea94ebf06'
down_revision = '84a05eaad817'
branch_labels = None
depends_on = None


def upgrade():
    op.add_column('GRASProject', sa.Column('is_claimed', sa.Boolean(), server_default='FALSE', nullable=False))
    bind = op.get_bind()
    bind.execute('''
        UPDATE "GRASProject" SET is_claimed=TRUE WHERE is_deleted=TRUE;
        UPDATE "GRASProject" SET is_deleted=FALSE WHERE is_deleted= TRUE;
    ''')

def downgrade():
    op.drop_column('GRASProject', 'is_claimed')