""" Replace profile regex by format

Revision ID: 059b2c50d7e1
Revises: c5109b93fc0f
Create Date: 2020-05-11 17:22:47.462998
"""

from alembic import op
import sqlalchemy as sa
import hiboo


revision = '059b2c50d7e1'
down_revision = 'c5109b93fc0f'
branch_labels = None
depends_on = None


def upgrade():
    with op.batch_alter_table('service') as batch_op:
        batch_op.add_column(sa.Column('profile_format', sa.String(length=255), nullable=True))
        batch_op.drop_column('profile_regex')


def downgrade():
    with op.batch_alter_table('service') as batch_op:
        batch_op.add_column(sa.Column('profile_regex', sa.VARCHAR(length=255), nullable=True))
        batch_op.drop_column('profile_format')