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'])
