Script 20140423001_add_indexes_py
[hide private]
[frames] | no frames]

Source Code for Script script-20140423001_add_indexes_py

 1  """add indexes 
 2   
 3  Revision ID: 20140423001 
 4  Revises: 5845661bb37d 
 5  Create Date: 2014-04-24 11:25:36.216132 
 6   
 7  """ 
 8   
 9  # revision identifiers, used by Alembic. 
10  revision = '20140423001' 
11  down_revision = '5845661bb37d' 
12   
13  from alembic import op 
14  import sqlalchemy as sa 
15   
16   
17 -def upgrade():
18 op.create_index('build_ended_on_canceled_started_on', 'build', ['ended_on', 'canceled', 'started_on']) 19 op.create_index('copr_owner_id', 'copr', ['owner_id']) 20 op.create_index('copr_deleted_name', 'copr', ['deleted', 'name']) 21 op.create_index('copr_chroot_copr_id', 'copr_chroot', ['copr_id']) 22 op.create_index('action_result_action_type', 'action', ['result', 'action_type']) 23 op.create_index('user_openid_name', 'user', ['openid_name']) 24 op.create_index('copr_permission_copr_id', 'copr_permission', ['copr_id']) 25 op.create_index('build_chroot_build_id', 'build_chroot', ['build_id']) 26 op.create_index('user_api_login', 'user', ['api_login']) 27 op.create_index('legal_flag_resolved_on', 'legal_flag', ['resolved_on'])
28
29 -def downgrade():
30 op.drop_index('build_ended_on_canceled_started_on') 31 op.drop_index('copr_owner_id') 32 op.drop_index('copr_deleted_name') 33 op.drop_index('copr_chroot_copr_id') 34 op.drop_index('action_result_action_type') 35 op.drop_index('user_openid_name') 36 op.drop_index('copr_permission_copr_id') 37 op.drop_index('build_chroot_build_id') 38 op.drop_index('user_api_login') 39 op.drop_index('legal_flag_resolved_on')
40