|
1 """use index shortcuts |
|
2 |
|
3 Revision ID: 37eaf74e46b |
|
4 Revises: 3c78152eb874 |
|
5 Create Date: 2014-10-28 16:41:05.519404 |
|
6 |
|
7 """ |
|
8 |
|
9 # revision identifiers, used by Alembic. |
|
10 revision = '37eaf74e46b' |
|
11 down_revision = '3c78152eb874' |
|
12 |
|
13 from alembic import op |
|
14 import sqlalchemy as sa |
|
15 |
|
16 |
|
17 def upgrade(): |
|
18 op.create_index(op.f('ix_annotation_channel'), 'annotation', ['channel'], unique=False) |
|
19 op.create_index(op.f('ix_annotation_event_code'), 'annotation', ['event_code'], unique=False) |
|
20 op.create_index(op.f('ix_annotation_ts'), 'annotation', ['ts'], unique=False) |
|
21 op.drop_index('idx_annotation_channel', table_name='annotation') |
|
22 op.drop_index('idx_annotation_event', table_name='annotation') |
|
23 op.drop_index('idx_annotation_ts', table_name='annotation') |
|
24 op.create_index(op.f('ix_event_active'), 'event', ['active'], unique=False) |
|
25 op.create_index(op.f('ix_event_code'), 'event', ['code'], unique=True) |
|
26 op.create_index(op.f('ix_event_start_date'), 'event', ['start_date'], unique=False) |
|
27 op.drop_index('idx_event_active', table_name='event') |
|
28 op.drop_index('idx_event_code', table_name='event') |
|
29 op.drop_index('idx_event_start_date', table_name='event') |
|
30 op.create_index(op.f('ix_event_session_order'), 'event_session', ['order'], unique=False) |
|
31 op.create_index(op.f('ix_event_session_start_ts'), 'event_session', ['start_ts'], unique=False) |
|
32 op.drop_index('idx_event_session_order', table_name='event_session') |
|
33 op.drop_index('idx_event_session_start_ts', table_name='event_session') |
|
34 |
|
35 |
|
36 def downgrade(): |
|
37 op.create_index('idx_event_session_start_ts', 'event_session', ['start_ts'], unique=False) |
|
38 op.create_index('idx_event_session_order', 'event_session', ['order'], unique=False) |
|
39 op.drop_index(op.f('ix_event_session_start_ts'), table_name='event_session') |
|
40 op.drop_index(op.f('ix_event_session_order'), table_name='event_session') |
|
41 op.create_index('idx_event_start_date', 'event', ['start_date'], unique=False) |
|
42 op.create_index('idx_event_code', 'event', ['code'], unique=False) |
|
43 op.create_index('idx_event_active', 'event', ['active'], unique=False) |
|
44 op.drop_index(op.f('ix_event_start_date'), table_name='event') |
|
45 op.drop_index(op.f('ix_event_code'), table_name='event') |
|
46 op.drop_index(op.f('ix_event_active'), table_name='event') |
|
47 op.create_index('idx_annotation_ts', 'annotation', ['ts'], unique=False) |
|
48 op.create_index('idx_annotation_event', 'annotation', ['event_code'], unique=False) |
|
49 op.create_index('idx_annotation_channel', 'annotation', ['channel'], unique=False) |
|
50 op.drop_index(op.f('ix_annotation_ts'), table_name='annotation') |
|
51 op.drop_index(op.f('ix_annotation_event_code'), table_name='annotation') |
|
52 op.drop_index(op.f('ix_annotation_channel'), table_name='annotation') |