Script 32fa3f232c34_owner_renamed_to_user_in_copr_table_py
[hide private]
[frames] | no frames]

Source Code for Script 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  # revision identifiers, used by Alembic. 
10  revision = '32fa3f232c34' 
11  down_revision = '13af46c70227' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
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
34 -def downgrade():
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