fossasia/open-event-orga-server

"""empty message

Revision ID: 6904ae1e0e33
Revises: ccd80550c01f
Create Date: 2017-06-13 08:42:28.606478

"""

# revision identifiers, used by Alembic.
revision = '6904ae1e0e33'
down_revision = 'ccd80550c01f'

from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.execute("ALTER TABLE image_sizes ALTER full_aspect TYPE boolean USING CASE full_aspect WHEN 'on' THEN TRUE\
                ELSE FALSE END", execution_options=None)

    op.execute("ALTER TABLE image_sizes ALTER icon_aspect TYPE boolean USING CASE icon_aspect WHEN 'on' THEN TRUE\
                ELSE FALSE END", execution_options=None)

    op.execute("ALTER TABLE image_sizes ALTER thumbnail_aspect TYPE boolean USING CASE thumbnail_aspect WHEN 'on' THEN TRUE\
                ELSE FALSE END", execution_options=None)

    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.execute("ALTER TABLE image_sizes ALTER full_aspect TYPE varchar USING CASE full_aspect WHEN TRUE THEN 'on'\
                ELSE 'off' END", execution_options=None)

    op.execute("ALTER TABLE image_sizes ALTER icon_aspect TYPE varchar USING CASE icon_aspect WHEN TRUE THEN 'on'\
                ELSE 'off' END", execution_options=None)

    op.execute("ALTER TABLE image_sizes ALTER thumbnail_aspect TYPE varchar USING CASE thumbnail_aspect WHEN TRUE THEN 'on'\
                ELSE 'off' END", execution_options=None)
    ### end Alembic commands ###