def _setup_db_session( self ): """ Initializes db_session. Called by setUp() """ engine = alchemy_create_engine( settings_app.TEST_DB_CONNECTION_URL ) Session = alchemy_scoped_session( alchemy_sessionmaker(bind=engine) ) db_session = Session() self.db_session = db_session return
def _setup_db_session(self): """ Initializes db_session. Called by setUp() """ engine = alchemy_create_engine(settings_app.TEST_DB_CONNECTION_URL) Session = alchemy_scoped_session(alchemy_sessionmaker(bind=engine)) db_session = Session() self.db_session = db_session return
def run_sql( self, sql, connection_url ): """ Executes sql. Called by UpdateTitlesHelper._make_backup_table() """ time.sleep( .25 ) log.debug( 'sql, ```%s```' % sql ) engine = alchemy_create_engine( connection_url ) try: return_val = None result = engine.execute( sql ) if 'fetchall' in dir( result.cursor ): return_val = result.cursor.fetchall() result.close() return return_val except Exception as e: log.error( 'exception executing sql, ```{}```'.format(unicode(repr(e))) )