Script 32fa3f232c34_owner_renamed_to_user_in_copr_table_py
|
|
1 """Owner renamed to User in copr table
2
3 Revision ID: 32fa3f232c34
4 Revises: 13af46c70227
5 Create Date: 2016-04-15 09:33:52.137979
6
7 """
8
9
10 revision = '32fa3f232c34'
11 down_revision = '13af46c70227'
12
13 from alembic import op
14 import sqlalchemy as sa
15
16
18 op.add_column('copr', sa.Column('user_id', sa.Integer(), nullable=True))
19
20 copr_table = sa.Table(
21 'copr',
22 sa.MetaData(),
23 sa.Column('owner_id', sa.Integer(), sa.ForeignKey('user.id'), nullable=True),
24 sa.Column('user_id', sa.Integer(), nullable=True),
25 )
26
27 op.execute('UPDATE "copr" SET user_id = owner_id')
28
29 op.drop_constraint(u'copr_owner_id_fkey', 'copr', type_='foreignkey')
30 op.create_foreign_key(u'copr_user_id_fkey', 'copr', 'user', ['user_id'], ['id'])
31 op.drop_column('copr', 'owner_id')
32
33
35 op.add_column('copr', sa.Column('owner_id', sa.INTEGER(), autoincrement=False, nullable=True))
36
37 copr_table = sa.Table(
38 'copr',
39 sa.MetaData(),
40 sa.Column('owner_id', sa.Integer(), sa.ForeignKey('user.id'), nullable=True),
41 sa.Column('user_id', sa.Integer(), nullable=True),
42 )
43
44 op.execute('UPDATE "copr" SET owner_id = user_id')
45
46 op.drop_constraint(u'copr_user_id_fkey', 'copr', type_='foreignkey')
47 op.create_foreign_key(u'copr_owner_id_fkey', 'copr', 'user', ['owner_id'], ['id'])
48 op.drop_column('copr', 'user_id')
49