def query_sql_keep_connection(db, sql):
try:
Logger.logDebug("query_db: " + sql)
rs = db.query(sql)
return rs
except:
traceback.print_exc(file=sys.stdout)
db.close()
raise
def execute_sql_keep_connection(db, sql):
try:
Logger.logDebug("excute_db: " + sql)
affect = db.execute(sql)
db.commit()
return affect
except:
traceback.print_exc(file=sys.stdout)
db.close()
raise
def execute_sql(sql, dbcfg, dbtype = "oracle"):
try:
db = connect_db(dbcfg, dbtype)
Logger.logDebug("execute_sql: " + sql)
affect = db.execute(sql)
db.commit()
return affect
except:
traceback.print_exc(file=sys.stdout)
raise
finally:
db.close()
