def downgrade(): op.drop_column('task', 'action') op.rename_table('task', 'deployment') op.create_table( 'task', sa.Column('id', sa.String(length=36), nullable=False)) helpers.transform_table( 'status', {'task_id': 'deployment_id'}, {}, sa.Column('created', sa.DateTime(), nullable=False), sa.Column('updated', sa.DateTime(), nullable=False), sa.Column('id', sa.String(length=36), nullable=False), sa.Column('entity_id', sa.String(length=255), nullable=True), sa.Column('entity', sa.String(length=10), nullable=True), sa.Column('deployment_id', sa.String(length=36), nullable=True), sa.Column('text', sa.Text(), nullable=False), sa.Column('level', sa.String(length=32), nullable=False), sa.Column('details', sa.Text(), nullable=True), sa.ForeignKeyConstraint(['deployment_id'], ['deployment.id'], ), sa.PrimaryKeyConstraint('id'), mysql_engine=MYSQL_ENGINE, mysql_charset=MYSQL_CHARSET ) op.drop_table('task')
def downgrade(): op.drop_column('task', 'action') op.rename_table('task', 'deployment') op.create_table('task', sa.Column('id', sa.String(length=36), nullable=False)) helpers.transform_table('status', {'task_id': 'deployment_id'}, {}, sa.Column('created', sa.DateTime(), nullable=False), sa.Column('updated', sa.DateTime(), nullable=False), sa.Column('id', sa.String(length=36), nullable=False), sa.Column('entity_id', sa.String(length=255), nullable=True), sa.Column('entity', sa.String(length=10), nullable=True), sa.Column('deployment_id', sa.String(length=36), nullable=True), sa.Column('text', sa.Text(), nullable=False), sa.Column('level', sa.String(length=32), nullable=False), sa.Column('details', sa.Text(), nullable=True), sa.ForeignKeyConstraint( ['deployment_id'], ['deployment.id'], ), sa.PrimaryKeyConstraint('id'), mysql_engine=MYSQL_ENGINE, mysql_charset=MYSQL_CHARSET) op.drop_table('task')
def upgrade(): engine = op.get_bind() if engine.dialect.dialect_description.startswith('mysql'): engine.execute('SET FOREIGN_KEY_CHECKS=0') if engine.dialect.dialect_description == 'postgresql+psycopg2': op.drop_constraint('package_to_tag_package_id_fkey', 'package_to_tag', 'foreignkey') op.drop_constraint('package_to_tag_tag_id_fkey', 'package_to_tag', 'foreignkey') op.drop_constraint('package_to_category_package_id_fkey', 'package_to_category', 'foreignkey') op.drop_constraint('class_definition_package_id_fkey', 'class_definition', 'foreignkey') helpers.transform_table('package', {}, {}, sa.Column('created', sa.DateTime(), nullable=False), sa.Column('updated', sa.DateTime(), nullable=False), sa.Column('id', sa.String(length=36), nullable=False), sa.Column('archive', st.LargeBinary(), nullable=True), sa.Column('fully_qualified_name', sa.String(length=128), nullable=False, unique=True), sa.Column('type', sa.String(length=20), nullable=False), sa.Column('author', sa.String(length=80), nullable=True), sa.Column('name', sa.String(length=80), nullable=False), sa.Column('enabled', sa.Boolean(), nullable=True), sa.Column('description', sa.Text(), nullable=False), sa.Column('is_public', sa.Boolean(), nullable=True), sa.Column('logo', st.LargeBinary(), nullable=True), sa.Column('owner_id', sa.String(length=36), nullable=False), sa.Column('ui_definition', sa.Text(), nullable=True), sa.Column('supplier_logo', sa.types.LargeBinary), sa.Column('supplier', sa.types.Text()), sa.PrimaryKeyConstraint('id'), mysql_engine=MYSQL_ENGINE, mysql_charset=MYSQL_CHARSET) op.create_index('ix_package_fqn', 'package', ['fully_qualified_name']) if engine.dialect.dialect_description.startswith('mysql'): engine.execute('SET FOREIGN_KEY_CHECKS=1') if engine.dialect.dialect_description == 'postgresql+psycopg2': op.create_foreign_key('package_to_tag_package_id_fkey', 'package_to_tag', 'package', ['package_id'], ['id']) op.create_foreign_key('package_to_tag_tag_id_fkey', 'package_to_tag', 'tag', ['tag_id'], ['id']) op.create_foreign_key('package_to_category_package_id_fkey', 'package_to_category', 'package', ['package_id'], ['id']) op.create_foreign_key('class_definition_package_id_fkey', 'class_definition', 'package', ['package_id'], ['id'])
def upgrade(): engine = op.get_bind() if engine.dialect.dialect_description.startswith('mysql'): engine.execute('SET FOREIGN_KEY_CHECKS=0') if engine.dialect.dialect_description == 'postgresql+psycopg2': op.drop_constraint('package_to_tag_package_id_fkey', 'package_to_tag', 'foreignkey') op.drop_constraint('package_to_tag_tag_id_fkey', 'package_to_tag', 'foreignkey') op.drop_constraint('package_to_category_package_id_fkey', 'package_to_category', 'foreignkey') op.drop_constraint('class_definition_package_id_fkey', 'class_definition', 'foreignkey') helpers.transform_table( 'package', {}, {}, sa.Column('created', sa.DateTime(), nullable=False), sa.Column('updated', sa.DateTime(), nullable=False), sa.Column('id', sa.String(length=36), nullable=False), sa.Column('archive', st.LargeBinary(), nullable=True), sa.Column('fully_qualified_name', sa.String(length=128), nullable=False), sa.Column('type', sa.String(length=20), nullable=False), sa.Column('author', sa.String(length=80), nullable=True), sa.Column('name', sa.String(length=80), nullable=False), sa.Column('enabled', sa.Boolean(), nullable=True), sa.Column('description', sa.Text(), nullable=False), sa.Column('is_public', sa.Boolean(), nullable=True), sa.Column('logo', st.LargeBinary(), nullable=True), sa.Column('owner_id', sa.String(length=36), nullable=False), sa.Column('ui_definition', sa.Text(), nullable=True), sa.Column('supplier_logo', sa.types.LargeBinary), sa.Column('supplier', sa.types.Text()), sa.PrimaryKeyConstraint('id'), mysql_engine=MYSQL_ENGINE, mysql_charset=MYSQL_CHARSET ) helpers.transform_table( 'class_definition', {}, {}, sa.Column('created', sa.DateTime(), nullable=False), sa.Column('updated', sa.DateTime(), nullable=False), sa.Column('id', sa.String(length=36), nullable=False), sa.Column('name', sa.String(length=128), nullable=False), sa.Column('package_id', sa.String(length=36), nullable=True), sa.ForeignKeyConstraint(['package_id'], ['package.id'], ), sa.PrimaryKeyConstraint('id'), mysql_engine=MYSQL_ENGINE, mysql_charset=MYSQL_CHARSET ) if engine.dialect.dialect_description.startswith('mysql'): engine.execute('SET FOREIGN_KEY_CHECKS=1') if engine.dialect.dialect_description == 'postgresql+psycopg2': op.create_foreign_key('package_to_tag_package_id_fkey', 'package_to_tag', 'package', ['package_id'], ['id']) op.create_foreign_key('package_to_tag_tag_id_fkey', 'package_to_tag', 'tag', ['tag_id'], ['id']) op.create_foreign_key('package_to_category_package_id_fkey', 'package_to_category', 'package', ['package_id'], ['id']) op.create_foreign_key('class_definition_package_id_fkey', 'class_definition', 'package', ['package_id'], ['id']) op.create_index('ix_package_fqn_and_owner', table_name='package', columns=['fully_qualified_name', 'owner_id'], unique=True) op.create_index('ix_class_definition_name', 'class_definition', ['name'])