"""expand enum for lock types

Revision ID: 7f31a9fad89f
Revises: 369deb8c8b63
Create Date: 2018-04-16 15:01:00.280469

"""

# revision identifiers, used by Alembic.
revision = '7f31a9fad89f'
down_revision = '369deb8c8b63'

from alembic import op
import sqlalchemy as sa


def upgrade():
    """
    Add new lock types to the lock_type_enum enum.

    With this there are three enums:
      - WORKER, used to lock action on the main git repo (sources)
      - WORKER_TICKET, used to lock actions on the ticket git repo
      - WORKER_REQUEST, used to lock actions on the request git repo
    """

    # Let's start with commit to close the current transaction
    # cf https://bitbucket.org/zzzeek/alembic/issue/123
    op.execute('COMMIT')
    op.execute(
        "ALTER TYPE lock_type_enum ADD VALUE 'WORKER_TICKET';")
    op.execute(
        "ALTER TYPE lock_type_enum ADD VALUE 'WORKER_REQUEST';")


def downgrade():
    """Raise an exception explaining that this migration cannot be reversed."""
    raise NotImplemented('This migration cannot be reversed.')