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