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   
15   
16 -def upgrade():
17 op.create_index('build_ended_on_canceled_started_on', 'build', ['ended_on', 'canceled', 'started_on']) 18 op.create_index('copr_owner_id', 'copr', ['owner_id']) 19 op.create_index('copr_deleted_name', 'copr', ['deleted', 'name']) 20 op.create_index('copr_chroot_copr_id', 'copr_chroot', ['copr_id']) 21 op.create_index('action_result_action_type', 'action', ['result', 'action_type']) 22 op.create_index('user_openid_name', 'user', ['openid_name']) 23 op.create_index('copr_permission_copr_id', 'copr_permission', ['copr_id']) 24 op.create_index('build_chroot_build_id', 'build_chroot', ['build_id']) 25 op.create_index('user_api_login', 'user', ['api_login']) 26 op.create_index('legal_flag_resolved_on', 'legal_flag', ['resolved_on'])
27
28 -def downgrade():
29 op.drop_index('build_ended_on_canceled_started_on') 30 op.drop_index('copr_owner_id') 31 op.drop_index('copr_deleted_name') 32 op.drop_index('copr_chroot_copr_id') 33 op.drop_index('action_result_action_type') 34 op.drop_index('user_openid_name') 35 op.drop_index('copr_permission_copr_id') 36 op.drop_index('build_chroot_build_id') 37 op.drop_index('user_api_login') 38 op.drop_index('legal_flag_resolved_on')
39