def test_001_engine(self):
options = JNTOptions({'conf_file':'tests/data/janitoo_db.conf'})
options.load()
engine = create_db_engine(options)
self.dbmaker = sessionmaker()
# Bind the sessionmaker to engine
self.dbmaker.configure(bind=engine)
self.dbsession = scoped_session(self.dbmaker)
Base.metadata.create_all(bind=engine)
def setUp(self):
JNTTServer.setUp(self)
options = JNTOptions({'conf_file':self.getDataFile(self.server_conf)})
options.load()
self.dbengine = create_db_engine(options)
self.dbmaker = sessionmaker()
# Bind the sessionmaker to engine
self.dbmaker.configure(bind=self.dbengine)
self.dbsession = scoped_session(self.dbmaker)
Base.metadata.drop_all(bind=self.dbengine)
def _create_db_engine(self):
"""Create the sql alchemy engine
"""
logger.debug(u'[%s] - Create db engine', self.__class__.__name__)
#~ self.stop_db()
#print self.options
if self.dbengine is not None:
return True
alembic = self.options.get_options('database')
self.dbauto_migrate = string_to_bool(alembic['auto_migrate']) if 'auto_migrate' in alembic else None
self.dbengine = create_db_engine(self.options)
return True
