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
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
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