def run(self, url_or_engine, conn_=None):
"""Run the contents of this SqlLog on a database"""
engine = url_or_engine
if type(url_or_engine) is str:
engine = create_engine(url_or_engine)
conn = conn_
if conn_ is None:
conn = engine.contextual_connect()
try:
for entry in self.entries:
try:
conn._execute_raw(entry.statement, entry.parameters)
except sqlalchemy.exceptions.SQLError, e:
# SQL error: add the original traceback to the message
raise exceptions.LogSqlError(e, entry)
finally:
if conn_ is None:
# connection was made here - clean up
conn.close()
def run(self,url_or_engine,conn_=None):
"""Run the contents of this SqlLog on a database"""
engine=url_or_engine
if type(url_or_engine) is str:
engine=create_engine(url_or_engine)
conn=conn_
if conn_ is None:
conn=engine.contextual_connect()
try:
for entry in self.entries:
try:
conn._execute_raw(entry.statement,entry.parameters)
except sqlalchemy.exceptions.SQLError,e:
# SQL error: add the original traceback to the message
raise exceptions.LogSqlError(e,entry)
finally:
if conn_ is None:
# connection was made here - clean up
conn.close()
def __connection(self, engine, **kwargs):
if self.transaction is not None:
return self.transaction.get_or_add(engine)
else:
return engine.contextual_connect(**kwargs)
def __connection(self, engine, **kwargs):
if self.transaction is not None:
return self.transaction.get_or_add(engine)
else:
return engine.contextual_connect(**kwargs)