| """Create private column in project table |
| |
| Revision ID: 4255158a6913 |
| Revises: 4df75d40bafa |
| Create Date: 2016-06-06 14:33:47.039207 |
| |
| """ |
| |
| |
| revision = '4255158a6913' |
| down_revision = '4df75d40bafa' |
| |
| from alembic import op |
| import sqlalchemy as sa |
| |
| |
| def upgrade(): |
| ''' Add a private 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', |
| nullable=False, existing_nullable=True) |
| |
| |
| def downgrade(): |
| ''' Remove the private column |
| ''' |
| op.drop_column('projects', 'private') |