bbba2255e00_add_email_validation_column.py 730 Bytes
Edit Raw Blame History Permalink



1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28


"""add email validation column

Revision ID: bbba2255e00
Revises: 38a8a6299086
Create Date: 2014-12-16 14:18:45.290836

"""

# revision identifiers, used by Alembic.
revision = 'bbba2255e00'
down_revision = '38a8a6299086'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.add_column('user', sa.Column('valid_email', sa.Boolean, default=False))
    op.add_column('user', sa.Column('confirmation_email_sent', sa.Boolean, default=False))
    query = 'UPDATE "user" SET valid_email=false;'
    op.execute(query)
    query = 'UPDATE "user" SET confirmation_email_sent=false;'
    op.execute(query)


def downgrade():
    op.drop_column('user', 'valid_email')
    op.drop_column('user', 'confirmation_email_sent')