Script 8ae65946df53_add_blocked_by_column_for_batch_py
[hide private]
[frames] | no frames]

Source Code for Script 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  # revision identifiers, used by Alembic. 
10  revision = '8ae65946df53' 
11  down_revision = '9bc8681ed275' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
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
22 -def downgrade():
23 op.drop_constraint('batch_blocked_by_id_fkey', 'batch', type_='foreignkey') 24 op.drop_column('batch', 'blocked_by_id')
25