def upgrade_releases(connection): select = text( """SELECT id, attributes_metadata, roles_metadata from releases""" ) update = text( """UPDATE releases SET attributes_metadata = :attrs, roles_metadata = :roles, wizard_metadata = :wiz_meta WHERE id = :id""" ) r = connection.execute(select) # reading fixture files in loop is in general a bad idea and as long as # wizard_metadata is the same for all existing releases getting it can # be moved outside of the loop wizard_meta = upgrade_release_wizard_metadata_50_to_51() for release in r: attrs_meta = upgrade_release_attributes_50_to_51(jsonutils.loads(release[1])) roles_meta = upgrade_release_roles_50_to_51(jsonutils.loads(release[2])) connection.execute( update, id=release[0], attrs=jsonutils.dumps(attrs_meta), roles=jsonutils.dumps(roles_meta), wiz_meta=jsonutils.dumps(wizard_meta), )
def test_upgrade_wizard_data(self): fixture_path = os.path.join(os.path.dirname(__file__), '..', '..', 'fixtures', 'openstack.yaml') wizard_meta = migration.upgrade_release_wizard_metadata_50_to_51( fixture_path=fixture_path) network_settings = [ n['data'] for n in wizard_meta['Network']['manager']['values'] ] self.assertNotIn('neutron-nsx', network_settings)
def test_upgrade_wizard_data(self): fixture_path = os.path.join(os.path.dirname(__file__), '..', '..', 'fixtures', 'openstack.yaml') wizard_meta = migration.upgrade_release_wizard_metadata_50_to_51( fixture_path=fixture_path ) network_settings = [ n['data'] for n in wizard_meta['Network']['manager']['values'] ] self.assertNotIn('neutron-nsx', network_settings)
def upgrade_releases(connection): select = text("""SELECT id, attributes_metadata, roles_metadata from releases""") update = text("""UPDATE releases SET attributes_metadata = :attrs, roles_metadata = :roles, wizard_metadata = :wiz_meta WHERE id = :id""") r = connection.execute(select) # reading fixture files in loop is in general a bad idea and as long as # wizard_metadata is the same for all existing releases getting it can # be moved outside of the loop wizard_meta = upgrade_release_wizard_metadata_50_to_51() for release in r: attrs_meta = upgrade_release_attributes_50_to_51( jsonutils.loads(release[1])) roles_meta = upgrade_release_roles_50_to_51(jsonutils.loads( release[2])) connection.execute(update, id=release[0], attrs=jsonutils.dumps(attrs_meta), roles=jsonutils.dumps(roles_meta), wiz_meta=jsonutils.dumps(wizard_meta))