Blame alembic/versions/7f31a9fad89f_expand_enum_for_lock_types.py
|
Pierre-Yves Chibon |
09776e |
"""expand enum for lock types
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
Revision ID: 7f31a9fad89f
|
|
Pierre-Yves Chibon |
09776e |
Revises: 369deb8c8b63
|
|
Pierre-Yves Chibon |
09776e |
Create Date: 2018-04-16 15:01:00.280469
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
"""
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
# revision identifiers, used by Alembic.
|
|
Pierre-Yves Chibon |
09776e |
revision = '7f31a9fad89f'
|
|
Pierre-Yves Chibon |
09776e |
down_revision = '369deb8c8b63'
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
from alembic import op
|
|
Pierre-Yves Chibon |
09776e |
import sqlalchemy as sa
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
def upgrade():
|
|
Pierre-Yves Chibon |
09776e |
"""
|
|
Pierre-Yves Chibon |
09776e |
Add new lock types to the lock_type_enum enum.
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
With this there are three enums:
|
|
Pierre-Yves Chibon |
09776e |
- WORKER, used to lock action on the main git repo (sources)
|
|
Pierre-Yves Chibon |
09776e |
- WORKER_TICKET, used to lock actions on the ticket git repo
|
|
Pierre-Yves Chibon |
09776e |
- WORKER_REQUEST, used to lock actions on the request git repo
|
|
Pierre-Yves Chibon |
09776e |
"""
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
# Let's start with commit to close the current transaction
|
|
Pierre-Yves Chibon |
09776e |
# cf https://bitbucket.org/zzzeek/alembic/issue/123
|
|
Pierre-Yves Chibon |
09776e |
op.execute('COMMIT')
|
|
Pierre-Yves Chibon |
09776e |
op.execute(
|
|
Pierre-Yves Chibon |
09776e |
"ALTER TYPE lock_type_enum ADD VALUE 'WORKER_TICKET';")
|
|
Pierre-Yves Chibon |
09776e |
op.execute(
|
|
Pierre-Yves Chibon |
09776e |
"ALTER TYPE lock_type_enum ADD VALUE 'WORKER_REQUEST';")
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
|
|
Pierre-Yves Chibon |
09776e |
def downgrade():
|
|
Pierre-Yves Chibon |
09776e |
"""Raise an exception explaining that this migration cannot be reversed."""
|
|
Pierre-Yves Chibon |
09776e |
raise NotImplemented('This migration cannot be reversed.')
|