Module ac5917e5c4fe_make_copr_dirs_unique_by_ownername
[hide private]
[frames] | no frames]

Source Code for Module ac5917e5c4fe_make_copr_dirs_unique_by_ownername

 1  """make copr_dirs unique by ownername 
 2   
 3  Revision ID: ac5917e5c4fe 
 4  Revises: 887cbbd6575e 
 5  Create Date: 2018-07-19 11:45:57.228628 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = 'ac5917e5c4fe' 
11  down_revision = '887cbbd6575e' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
18 op.add_column('copr_dir', sa.Column('ownername', sa.Text(), nullable=False)) 19 op.create_index(op.f('ix_copr_dir_ownername'), 'copr_dir', ['ownername'], unique=False) 20 op.create_unique_constraint('ownername_copr_dir_uniq', 'copr_dir', ['ownername', 'name']) 21 op.drop_constraint(u'copr_dir_copr_id_name_uniq', 'copr_dir', type_='unique')
22 23
24 -def downgrade():
25 op.create_unique_constraint(u'copr_dir_copr_id_name_uniq', 'copr_dir', ['copr_id', 'name']) 26 op.drop_constraint('ownername_copr_dir_uniq', 'copr_dir', type_='unique') 27 op.drop_index(op.f('ix_copr_dir_ownername'), table_name='copr_dir') 28 op.drop_column('copr_dir', 'ownername')
29