Jun-29-2018, 08:41 AM
Hi - very new to python. I have a function that connects to teradata using jdwh. The function works well but the function returns nothing when there is an sql error. Function is as shown below - I’m advised that jdwh will return “exit code 1” if there was an error:
def db_execute(sql,ret='stdout'):
ret_type = {'stdout': 0 , 'out': 0, 'err':1, 'error':1, 'stderror':1}
args = ['jdwh']
db_cmd = subprocess.Popen(args, stdout=subprocess.PIPE, stdin=subprocess.PIPE, stderr=subprocess.PIPE)
out = db_cmd.communicate(input = sql)
if ret_type[ret] not in list(ret_type.values()):
return None
return out[ret_type[ret]]
Any help appreciated.
def db_execute(sql,ret='stdout'):
ret_type = {'stdout': 0 , 'out': 0, 'err':1, 'error':1, 'stderror':1}
args = ['jdwh']
db_cmd = subprocess.Popen(args, stdout=subprocess.PIPE, stdin=subprocess.PIPE, stderr=subprocess.PIPE)
out = db_cmd.communicate(input = sql)
if ret_type[ret] not in list(ret_type.values()):
return None
return out[ret_type[ret]]
Any help appreciated.
