| author | rougeronj |
| Thu, 22 Jan 2015 09:26:43 +0100 | |
| changeset 111 | a7b72620d227 |
| parent 78 | 37bb8e326446 |
| permissions | -rw-r--r-- |
|
78
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
1 |
"""use index shortcuts |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
2 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
3 |
Revision ID: 37eaf74e46b |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
4 |
Revises: 3c78152eb874 |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
5 |
Create Date: 2014-10-28 16:41:05.519404 |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
6 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
7 |
""" |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
8 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
9 |
# revision identifiers, used by Alembic. |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
10 |
revision = '37eaf74e46b' |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
11 |
down_revision = '3c78152eb874' |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
12 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
13 |
from alembic import op |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
14 |
import sqlalchemy as sa |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
15 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
16 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
17 |
def upgrade(): |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
18 |
op.create_index(op.f('ix_annotation_channel'), 'annotation', ['channel'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
19 |
op.create_index(op.f('ix_annotation_event_code'), 'annotation', ['event_code'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
20 |
op.create_index(op.f('ix_annotation_ts'), 'annotation', ['ts'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
21 |
op.drop_index('idx_annotation_channel', table_name='annotation') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
22 |
op.drop_index('idx_annotation_event', table_name='annotation') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
23 |
op.drop_index('idx_annotation_ts', table_name='annotation') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
24 |
op.create_index(op.f('ix_event_active'), 'event', ['active'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
25 |
op.create_index(op.f('ix_event_code'), 'event', ['code'], unique=True) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
26 |
op.create_index(op.f('ix_event_start_date'), 'event', ['start_date'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
27 |
op.drop_index('idx_event_active', table_name='event') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
28 |
op.drop_index('idx_event_code', table_name='event') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
29 |
op.drop_index('idx_event_start_date', table_name='event') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
30 |
op.create_index(op.f('ix_event_session_order'), 'event_session', ['order'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
31 |
op.create_index(op.f('ix_event_session_start_ts'), 'event_session', ['start_ts'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
32 |
op.drop_index('idx_event_session_order', table_name='event_session') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
33 |
op.drop_index('idx_event_session_start_ts', table_name='event_session') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
34 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
35 |
|
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
36 |
def downgrade(): |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
37 |
op.create_index('idx_event_session_start_ts', 'event_session', ['start_ts'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
38 |
op.create_index('idx_event_session_order', 'event_session', ['order'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
39 |
op.drop_index(op.f('ix_event_session_start_ts'), table_name='event_session') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
40 |
op.drop_index(op.f('ix_event_session_order'), table_name='event_session') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
41 |
op.create_index('idx_event_start_date', 'event', ['start_date'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
42 |
op.create_index('idx_event_code', 'event', ['code'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
43 |
op.create_index('idx_event_active', 'event', ['active'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
44 |
op.drop_index(op.f('ix_event_start_date'), table_name='event') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
45 |
op.drop_index(op.f('ix_event_code'), table_name='event') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
46 |
op.drop_index(op.f('ix_event_active'), table_name='event') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
47 |
op.create_index('idx_annotation_ts', 'annotation', ['ts'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
48 |
op.create_index('idx_annotation_event', 'annotation', ['event_code'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
49 |
op.create_index('idx_annotation_channel', 'annotation', ['channel'], unique=False) |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
50 |
op.drop_index(op.f('ix_annotation_ts'), table_name='annotation') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
51 |
op.drop_index(op.f('ix_annotation_event_code'), table_name='annotation') |
|
37bb8e326446
add a lable ro eventsession + add alembic migration for older databases
ymh <ymh.work@gmail.com>
parents:
diff
changeset
|
52 |
op.drop_index(op.f('ix_annotation_channel'), table_name='annotation') |