16
16
"""Ironic DB test base class."""
18
from ironic.openstack.common import context as ironic_context
22
from oslo.config import cfg
24
from ironic.common import paths
25
from ironic.db import api as dbapi
26
from ironic.db.sqlalchemy import api as sqla_api
27
from ironic.db.sqlalchemy import migration
28
from ironic.db.sqlalchemy import models
19
29
from ironic.tests import base
37
class Database(fixtures.Fixture):
39
def __init__(self, db_api, db_migrate, sql_connection,
40
sqlite_db, sqlite_clean_db):
41
self.sql_connection = sql_connection
42
self.sqlite_db = sqlite_db
43
self.sqlite_clean_db = sqlite_clean_db
45
self.engine = db_api.get_engine()
47
conn = self.engine.connect()
48
if sql_connection == "sqlite://":
49
self.setup_sqlite(db_migrate)
50
elif sql_connection.startswith('sqlite:///'):
51
testdb = paths.state_path_rel(sqlite_db)
52
if os.path.exists(testdb):
54
self.setup_sqlite(db_migrate)
56
db_migrate.upgrade('head')
57
self.post_migrations()
58
if sql_connection == "sqlite://":
59
conn = self.engine.connect()
60
self._DB = "".join(line for line in conn.connection.iterdump())
63
cleandb = paths.state_path_rel(sqlite_clean_db)
64
shutil.copyfile(testdb, cleandb)
66
def setup_sqlite(self, db_migrate):
67
if db_migrate.version():
69
models.Base.metadata.create_all(self.engine)
70
db_migrate.stamp('head')
73
super(Database, self).setUp()
75
if self.sql_connection == "sqlite://":
76
conn = self.engine.connect()
77
conn.connection.executescript(self._DB)
78
self.addCleanup(self.engine.dispose)
80
shutil.copyfile(paths.state_path_rel(self.sqlite_clean_db),
81
paths.state_path_rel(self.sqlite_db))
82
self.addCleanup(os.unlink, self.sqlite_db)
84
def post_migrations(self):
85
"""Any addition steps that are needed outside of the migrations."""
22
88
class DbTestCase(base.TestCase):
25
91
super(DbTestCase, self).setUp()
26
self.context = ironic_context.get_admin_context()
93
self.dbapi = dbapi.get_instance()
97
_DB_CACHE = Database(sqla_api, migration,
98
sql_connection=CONF.database.connection,
99
sqlite_db=CONF.database.sqlite_db,
100
sqlite_clean_db='clean.sqlite')
101
self.useFixture(_DB_CACHE)