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