"""Create private column in project table

Revision ID: 4255158a6913
Revises: 317a285e04a8
Create Date: 2016-06-06 14:33:47.039207

"""

# revision identifiers, used by Alembic.
revision = '4255158a6913'
down_revision = '317a285e04a8'

from alembic import op
import sqlalchemy as sa


def upgrade():
    ''' Add a pivate column in the project table
    '''
    op.add_column(
        'projects',
        sa.Column('_private', sa.Boolean, nullable=True, default=False)
    )
    op.execute('''UPDATE "projects" '''
               '''SET _private=False;''')

    op.alter_column(
        'projects',
        column_name='_private', new_column_name='private',
        nullable=False, existing_nullable=True)


def downgrade():
    ''' Remove the private column
    '''
    op.drop_column('projects', 'private')