def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine modules = Table('modules', meta, autoload=True) modules.drop_column(COLUMN_NAME_1) modules.drop_column(COLUMN_NAME_2) modules.drop_column(COLUMN_NAME_3)
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # drop column: backups = Table('backups', meta, autoload=True) backups.drop_column('parent_id')
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([datastores, datastore_versions]) instances = Table('instances', meta, autoload=True) datastore_version_id = Column('datastore_version_id', String(36), ForeignKey('datastore_versions.id')) instances.create_column(datastore_version_id) instances.drop_column('service_type')
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # drop column: instances = Table('instances', meta, autoload=True) instances.drop_column('deleted') instances.drop_column('deleted_at')
def downgrade(migrate_engine): meta.bind = migrate_engine drop_tables([datastores, datastore_versions]) instances = Table('instances', meta, autoload=True) instances.drop_column('datastore_version_id') service_type = Column('service_type', String(36)) instances.create_column(service_type) instances.update().values({'service_type': 'mysql'}).execute()
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # drop column: instances = Table('instances', meta, autoload=True) instances.drop_column('tenant_id') instances.drop_column('server_status')
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # drop column: backups = Table('backups', meta, autoload=True) migrate_engine.execute('DROP INDEX backups_parent_id_idx ON backups') migrate_engine.execute('DROP INDEX backups_deleted_idx ON backups') backups.drop_column('parent_id')
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # drop column: instances = Table('instances', meta, autoload=True) instances.drop_column('flavor_id') instances.drop_column('volume_size')
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table("instances", meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table="instances", columns=[COLUMN_NAME], ref_table="instances", ref_columns=["id"] ) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[instances.c.slave_of_id], ref_columns=[instances.c.id] ) instances.drop_column(COLUMN_NAME)
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine datastores = Table('datastores', meta, autoload=True) datastore_versions = Table('datastore_versions', meta, autoload=True) # drop column from datastore_versions datastore_versions.drop_column('manager') # add column to datastores manager = Column('manager', String(255)) datastores.create_column(manager)
def downgrade(migrate_engine): meta.bind = migrate_engine # modify column: backups = Table('backups', meta, autoload=True) backups.drop_column("group_id") backups.drop_column("type") backups.drop_column("expire_at") backups.drop_column("service_image_id") instances = Table('instances', meta, autoload=True) instances.drop_column('group_id') drop_tables([InstanceGroup,InstanceGroupItem,InstanceVip,Vips,Autobackup, security_group_group_associations])
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='instances', columns=[COLUMN_NAME], ref_table='instances', ref_columns=['id']) db_utils.drop_foreign_key_constraints(constraint_names=constraint_names, columns=[instances.c.slave_of_id], ref_columns=[instances.c.id]) instances.drop_column(COLUMN_NAME)
def downgrade(migrate_engine): meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='instances', columns=['configuration_id'], ref_table='configurations', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[instances.c.configuration_id], ref_columns=[configurations.c.id]) instances.drop_column('configuration_id') drop_tables([configuration_parameters, configurations])
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine backups = Table('backups', meta, autoload=True) datastore_versions = Table('datastore_versions', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='backups', columns=['datastore_version_id'], ref_table='datastore_versions', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[backups.c.datastore_version_id], ref_columns=[datastore_versions.c.id]) backups.drop_column('datastore_version_id')
def upgrade(migrate_engine): meta.bind = migrate_engine ds_config_param = Table('datastore_configuration_parameters', meta, autoload=True) # Remove records with deleted=1 if 'deleted' in ds_config_param.c: ds_config_param.delete(). \ where(ds_config_param.c.deleted == 1). \ execute() # Delete columns deleted and deleted_at if migrate_engine.name != "sqlite": ds_config_param.drop_column('deleted') ds_config_param.drop_column('deleted_at')
def downgrade(migrate_engine): meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='instances', columns=['datastore_version_id'], ref_table='datastore_versions', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[instances.c.datastore_version_id], ref_columns=[datastore_versions.c.id]) instances.drop_column('datastore_version_id') service_type = Column('service_type', String(36)) instances.create_column(service_type) instances.update().values({'service_type': 'mysql'}).execute() drop_tables([datastore_versions, datastores])
def downgrade(migrate_engine): meta.bind = migrate_engine clusters = Table('clusters', meta, autoload=True) configurations = Table('configurations', meta, autoload=True, autoload_with=migrate_engine) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='clusters', columns=['configuration_id'], ref_table='configurations', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[clusters.c.configuration_id], ref_columns=[configurations.c.id]) clusters.drop_column('configuration_id')
def downgrade(migrate_engine): meta.bind = migrate_engine datastore_versions = Table('datastore_versions', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='clusters', columns=['datastore_version_id'], ref_table='datastore_versions', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[clusters.c.datastore_version_id], ref_columns=[datastore_versions.c.id]) instances = Table('instances', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='instances', columns=['cluster_id'], ref_table='clusters', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[instances.c.cluster_id], ref_columns=[clusters.c.id]) instances.drop_column('cluster_id') instances.drop_column('shard_id') instances.drop_column('type') drop_tables([clusters])
def downgrade(migrate_engine): meta.bind = migrate_engine datastore_versions = Table('datastore_versions', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='clusters', columns=['datastore_version_id'], ref_table='datastore_versions', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[clusters.c.datastore_version_id], ref_columns=[datastore_versions.c.id]) instances = Table('instances', meta, autoload=True) constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='instances', columns=['cluster_id'], ref_table='clusters', ref_columns=['id']) db_utils.drop_foreign_key_constraints(constraint_names=constraint_names, columns=[instances.c.cluster_id], ref_columns=[clusters.c.id]) instances.drop_column('cluster_id') instances.drop_column('shard_id') instances.drop_column('type') drop_tables([clusters])
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.drop_column(COLUMN_NAME)
def downgrade(migrate_engine): meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.drop_column('region_id')
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # modify column: instances = Table('instances', meta, autoload=True) instances.drop_column('service_type')
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine backups = Table('backups', meta, autoload=True) backups.drop_column('datastore_version_id')
def downgrade(migrate_engine): meta.bind = migrate_engine instance_vip = Table('instance_vip', meta, autoload=True) instance_vip.drop_column("virtual_instance_id")
def downgrade(migrate_engine): meta.bind = migrate_engine # modify column: backups = Table('backups', meta, autoload=True) backups.drop_column("extend")
def downgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table("instances", meta, autoload=True) instances.drop_column(COLUMN_NAME)
def downgrade(migrate_engine): meta = MetaData(bind=migrate_engine) configurations = Table('configurations', meta, autoload=True) configurations.drop_column('created') configurations.drop_column('updated')