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