Script 63db6872060f_add_bootstrap_config_columns_py
[hide private]
[frames] | no frames]

Source Code for Script script-63db6872060f_add_bootstrap_config_columns_py

 1  """ 
 2  add bootstrap-config columns 
 3   
 4  Revision ID: 63db6872060f 
 5  Revises: de903581465c 
 6  Create Date: 2020-06-29 08:59:07.525039 
 7  """ 
 8   
 9  import sqlalchemy as sa 
10  from alembic import op 
11   
12   
13  revision = '63db6872060f' 
14  down_revision = 'de903581465c' 
15   
16 -def upgrade():
17 op.add_column('copr', sa.Column('bootstrap', sa.Text())) 18 op.add_column('copr_chroot', sa.Column('bootstrap', sa.Text())) 19 op.add_column('copr_chroot', sa.Column('bootstrap_image', sa.Text())) 20 op.add_column('build', sa.Column('bootstrap', sa.Text())) 21 22 23 op.execute(""" 24 UPDATE 25 copr 26 SET 27 bootstrap = 'on' 28 WHERE 29 use_bootstrap_container = true 30 """) 31 32 op.execute(""" 33 UPDATE 34 copr 35 SET 36 bootstrap = 'off' 37 WHERE 38 use_bootstrap_container = false 39 """) 40 41 op.drop_column('copr', 'use_bootstrap_container')
42
43 -def downgrade():
44 op.add_column('copr', sa.Column('use_bootstrap_container', sa.Boolean(), 45 nullable=False, server_default='f')) 46 47 op.execute(""" 48 UPDATE 49 copr 50 SET 51 use_bootstrap_container = true 52 WHERE 53 bootstrap = 'on' 54 """) 55 56 op.execute(""" 57 UPDATE 58 copr 59 SET 60 use_bootstrap_container = false 61 WHERE 62 bootstrap = 'off' 63 """) 64 65 op.drop_column('copr', 'bootstrap') 66 op.drop_column('copr_chroot', 'bootstrap') 67 op.drop_column('copr_chroot', 'bootstrap_image') 68 op.drop_column('build', 'bootstrap')
69