def init_db(): from trove.common import cfg from trove.db import get_db_api from trove.db.sqlalchemy import session CONF = cfg.CONF db_api = get_db_api() db_api.db_sync(CONF) session.configure_db(CONF)
def init_db(): with LOCK: global DB_SETUP if not DB_SETUP: db_api = get_db_api() db_api.db_sync(CONF) session.configure_db(CONF) DB_SETUP = True
def initialize_database(): from trove.db import get_db_api from trove.db.sqlalchemy import session db_api = get_db_api() db_api.drop_db(CONF) # Destroys the database, if it exists. db_api.db_sync(CONF) session.configure_db(CONF) datastore_init() db_api.configure_db(CONF)
def initialize_database(): from trove.db import get_db_api from trove.instance import models from trove.db.sqlalchemy import session db_api = get_db_api() db_api.drop_db(CONF) # Destroys the database, if it exists. db_api.db_sync(CONF) session.configure_db(CONF) # Adds the image for mysql (needed to make most calls work). models.ServiceImage.create(service_name="mysql", image_id="fake") db_api.configure_db(CONF)
def init_db(): global DB_SETUP if DB_SETUP: return from trove.common import cfg from trove.db import get_db_api from trove.db.sqlalchemy import session CONF = cfg.CONF db_api = get_db_api() db_api.db_sync(CONF) session.configure_db(CONF) DB_SETUP = True
def upgrade(migrate_engine): meta.bind = migrate_engine instance_table = Table('instances', meta, autoload=True) session.configure_db(CONF) instances = DBInstance.find_all(datastore_version_id=None) if instances.count() > 0: datastore = DBDatastore.get_by(manager="mysql") datastore = datastore or DBDatastore.create( name="Legacy MySQL", manager="mysql", ) image_table = Table('service_images', meta, autoload=True) image = select( columns=["id", "image_id", "service_name"], from_obj=image_table, whereclause="service_name='mysql'", limit=1 ).execute().fetchone() image_id = "00000000-0000-0000-0000-000000000000" if image: image_id = image.image_id version = DBDatastoreVersion.create( datastore_id=datastore.id, name="Unknown Legacy Version", image_id=image_id, active=False, ) for instance in instances: instance.update_db(datastore_version_id=version.id) instance_table.c.datastore_version_id.alter(nullable=False)
def configure_db_for_plugins(options, *plugins): for plugin in plugins: session.configure_db(options, models_mapper=plugin.mapper)
def configure_db(options, *plugins): session.configure_db(options) configure_db_for_plugins(options, *plugins)