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

Source Code for Module deadbeafc0de_add_indexes2

 1  """add indexes2 
 2   
 3  Revision ID: deadbeafc0de_add_indexes.py 
 4  Revises: 10029c92dd0d 
 5  Create Date: 2019-01-14 14:43:00.000000 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = 'deadbeafc0de' 
11  down_revision = 'deaddeadc0de' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
18 op.create_index('build_package_idx', 'build', ['package_id'], unique=False) 19 op.create_index('copr_user_id_idx', 'copr', ['user_id'], unique=False) 20 op.create_index('copr_name_group_id_idx', 'copr', ['name', 'group_id'], unique=False) 21 op.create_index('package_copr_id_idx', 'package', ['copr_id'], unique=False) 22 op.create_index('build_user_id_idx', 'build', ['user_id'], unique=False)
23 24
25 -def downgrade():
26 op.drop_index('build_user_id_idx', table_name='build') 27 op.drop_index('package_copr_id_idx', table_name='package') 28 op.drop_index('copr_name_group_id_idx', table_name='copr') 29 op.drop_index('copr_user_id_idx', table_name='copr') 30 op.drop_index('build_package_idx', table_name='build')
31