4e435ff8ba74_add_unsubscribe_column_to_user_table.py 502 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 
"""Add subscribe column to user table

Revision ID: 4e435ff8ba74
Revises: bbba2255e00
Create Date: 2015-02-09 10:36:45.935116

"""

# revision identifiers, used by Alembic.
revision = '4e435ff8ba74'
down_revision = 'bbba2255e00'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.add_column('user', sa.Column('subscribed', sa.Boolean, default=True))
    query = 'UPDATE "user" SET subscribed=true;'
    op.execute(query)


def downgrade():
    op.drop_column('user', 'subscribed')