root / snf-pithos-backend / pithos / backends / lib / sqlalchemy / alembic / versions / 8320b1c62d9_create_index_nodes_p.py @ 3ccbbca8
History | View | Annotate | Download (404 Bytes)
| 1 | 5f8bbf54 | Sofia Papagiannaki | """create index nodes.parent
|
|---|---|---|---|
| 2 | 5f8bbf54 | Sofia Papagiannaki |
|
| 3 | 5f8bbf54 | Sofia Papagiannaki | Revision ID: 8320b1c62d9
|
| 4 | 5f8bbf54 | Sofia Papagiannaki | Revises: None
|
| 5 | 5f8bbf54 | Sofia Papagiannaki | Create Date: 2012-07-17 20:31:18.790919
|
| 6 | 5f8bbf54 | Sofia Papagiannaki |
|
| 7 | 5f8bbf54 | Sofia Papagiannaki | """
|
| 8 | 5f8bbf54 | Sofia Papagiannaki | |
| 9 | 5f8bbf54 | Sofia Papagiannaki | # revision identifiers, used by Alembic.
|
| 10 | 5f8bbf54 | Sofia Papagiannaki | revision = '8320b1c62d9'
|
| 11 | 5f8bbf54 | Sofia Papagiannaki | down_revision = None
|
| 12 | 5f8bbf54 | Sofia Papagiannaki | |
| 13 | 5f8bbf54 | Sofia Papagiannaki | from alembic import op |
| 14 | 5f8bbf54 | Sofia Papagiannaki | import sqlalchemy as sa |
| 15 | 5f8bbf54 | Sofia Papagiannaki | |
| 16 | 2715ade4 | Sofia Papagiannaki | |
| 17 | 5f8bbf54 | Sofia Papagiannaki | def upgrade(): |
| 18 | 5f8bbf54 | Sofia Papagiannaki | op.create_index('idx_nodes_parent', 'nodes', ['parent']) |
| 19 | 5f8bbf54 | Sofia Papagiannaki | |
| 20 | 2715ade4 | Sofia Papagiannaki | |
| 21 | 5f8bbf54 | Sofia Papagiannaki | def downgrade(): |
| 22 | 5f8bbf54 | Sofia Papagiannaki | op.drop_index('idx_nodes_parent', tablename='nodes') |