else:
order.order_status = 5
order.save()
sendOrderNotice.delay(order.id,mask='【已执行】')
return JsonResponse({'msg':"SQL执行成功","code":200,'data':sList})
else:
return JsonResponse({'msg':result.get('errinfo'),"code":500,'data':[]})
except Exception, ex:
logger.error(msg="执行SQL[{id}]错误: {ex}".format(id=id,ex=str(ex)))
return JsonResponse({'msg':str(ex),"code":200,'data':[]})
elif order.sql_audit_order.order_type == 'file':
filePath = os.getcwd() + '/upload/' + str(order.sql_audit_order.order_file)
rc,rs = mysql.loads(
host=order.sql_audit_order.order_db.db_host,
dbname=order.sql_audit_order.order_db.db_name,
user=order.sql_audit_order.order_db.db_user,
passwd=order.sql_audit_order.order_db.db_passwd,
port=order.sql_audit_order.order_db.db_port,
sql=filePath
)
if rc == 0:
order.order_status = 8
order.save()
sendOrderNotice.delay(order.id,mask='【已执行】')
return JsonResponse({'msg':"SQL执行成功","code":200,'data':rs})
else:
order.order_status = 9
order.save()
sendOrderNotice.delay(order.id,mask='【已失败】')
return JsonResponse({'msg':"SQL执行失败：{rs}".format(rs=str(rs)),"code":500,'data':[]})
elif request.POST.get('type') == 'rollback' and order.order_status == 5 and order.prem == 1:
})
except Exception, ex:
logger.error(
msg="执行SQL[{id}]错误: {ex}".format(id=id, ex=str(ex)))
return JsonResponse({
'msg': str(ex),
"code": 200,
'data': []
})
elif order.sql_audit_order.order_type == 'file':
filePath = os.getcwd() + '/upload/' + str(
order.sql_audit_order.order_file)
rc, rs = mysql.loads(
host=order.sql_audit_order.order_db.db_host,
dbname=order.sql_audit_order.order_db.db_name,
user=order.sql_audit_order.order_db.db_user,
passwd=order.sql_audit_order.order_db.db_passwd,
port=order.sql_audit_order.order_db.db_port,
sql=filePath)
if rc == 0:
order.order_status = 8
order.save()
sendOrderNotice.delay(order.id, mask='【已执行】')
return JsonResponse({
'msg': "SQL执行成功",
"code": 200,
'data': rs
})
else:
order.order_status = 9
order.save()