root / snf-pithos-backend / pithos / backends / lib / sqlalchemy / alembic / versions / e6edec1b499_add_columns_for_snap.py @ 329b8349
History | View | Annotate | Download (698 Bytes)
| 1 | eaaec098 | Sofia Papagiannaki | """Add columns for snapshots
|
|---|---|---|---|
| 2 | eaaec098 | Sofia Papagiannaki |
|
| 3 | eaaec098 | Sofia Papagiannaki | Revision ID: e6edec1b499
|
| 4 | eaaec098 | Sofia Papagiannaki | Revises: 3b62b3f1bf6c
|
| 5 | eaaec098 | Sofia Papagiannaki | Create Date: 2014-01-27 15:33:21.058484
|
| 6 | eaaec098 | Sofia Papagiannaki |
|
| 7 | eaaec098 | Sofia Papagiannaki | """
|
| 8 | eaaec098 | Sofia Papagiannaki | |
| 9 | eaaec098 | Sofia Papagiannaki | # revision identifiers, used by Alembic.
|
| 10 | eaaec098 | Sofia Papagiannaki | revision = 'e6edec1b499'
|
| 11 | 329b8349 | Sofia Papagiannaki | down_revision = '54dbdde2d187'
|
| 12 | eaaec098 | Sofia Papagiannaki | |
| 13 | eaaec098 | Sofia Papagiannaki | from alembic import op |
| 14 | eaaec098 | Sofia Papagiannaki | import sqlalchemy as sa |
| 15 | eaaec098 | Sofia Papagiannaki | |
| 16 | eaaec098 | Sofia Papagiannaki | |
| 17 | eaaec098 | Sofia Papagiannaki | def upgrade(): |
| 18 | eaaec098 | Sofia Papagiannaki | op.add_column('versions',
|
| 19 | eaaec098 | Sofia Papagiannaki | sa.Column('available', sa.Boolean, nullable=False, |
| 20 | eaaec098 | Sofia Papagiannaki | server_default='true'))
|
| 21 | eaaec098 | Sofia Papagiannaki | op.add_column('versions',
|
| 22 | eaaec098 | Sofia Papagiannaki | sa.Column('map_check_timestamp',
|
| 23 | eaaec098 | Sofia Papagiannaki | sa.DECIMAL(precision=16, scale=6))) |
| 24 | eaaec098 | Sofia Papagiannaki | |
| 25 | eaaec098 | Sofia Papagiannaki | |
| 26 | eaaec098 | Sofia Papagiannaki | def downgrade(): |
| 27 | eaaec098 | Sofia Papagiannaki | op.drop_column('versions', 'available') |
| 28 | eaaec098 | Sofia Papagiannaki | op.drop_column('versions', 'map_check_timestamp') |