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))) )
