Script 8ae65946df53_add_blocked_by_column_for_batch_py
|
|
1 """Add blocked_by column for batch
2
3 Revision ID: 8ae65946df53
4 Revises: b64659389c54
5 Create Date: 2019-03-27 18:38:03.758974
6
7 """
8
9
10 revision = '8ae65946df53'
11 down_revision = '9bc8681ed275'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
18 op.add_column('batch', sa.Column('blocked_by_id', sa.Integer(), nullable=True))
19 op.create_foreign_key('batch_blocked_by_id_fkey', 'batch', 'batch', ['blocked_by_id'], ['id'])
20
21
23 op.drop_constraint('batch_blocked_by_id_fkey', 'batch', type_='foreignkey')
24 op.drop_column('batch', 'blocked_by_id')
25