def getInterfeceListData(request): #根据任务执行结果 id = request.GET.get("id") taskDataModel = HTTP_task_executeService.findTaskRestltForId(id) taskData = dbModelToDict(taskDataModel) if taskDataModel.version == "CurrentVersion": getInterFaceDataSql = taskData["taskInterfaces"].replace( ",", "' union all select thi.id,thi.interfaceId,thi.title,thi.casedesc,thi.url,thi.addBy,tu.userName from tb_http_interface thi LEFT JOIN tb_user tu on thi.addBy = tu .loginName where interfaceId = '" ) sql = "select thi.id,thi.interfaceId,thi.title,thi.casedesc,thi.url,thi.addBy,tu.userName from tb_http_interface thi LEFT JOIN tb_user tu on thi.addBy = tu .loginName where interfaceId = '%s'" % getInterFaceDataSql else: getInterFaceDataSql = taskData["taskInterfaces"].replace( ",", "' union all select thi.id,thi.interfaceId,thi.title,thi.casedesc,thi.url,thi.addBy,tu.userName from tb_version_http_interface thi LEFT JOIN tb_user tu on thi.addBy = tu .loginName where interfaceId = '" ) sql = "select thi.id,thi.interfaceId,thi.title,thi.casedesc,thi.url,thi.addBy,tu.userName from tb_version_http_interface thi LEFT JOIN tb_user tu on thi.addBy = tu .loginName where interfaceId = '%s' and versionName='%s'" % ( getInterFaceDataSql, taskDataModel.version) taskInterfaceListData = executeSqlGetDict(sql) response = render( request, "InterfaceTest/HTTPTask/SubPages/HTTP_Task_Details_Select_interface_list_check_page.html", {"pageDatas": taskInterfaceListData}) return response
def getTaskRestltDetail(request): id = request.GET.get("id") taskExecDataModel = HTTP_task_executeService.findTaskRestltForId(id) taskExecData = dbModelToDict(taskExecDataModel) taskExecData.update(dbModelToDict(taskExecDataModel.httpConfKey)) taskExecData.update(dbModelToDict(taskExecDataModel.addBy)) return HttpResponse( ApiReturn(ApiReturn.CODE_OK, body=json.dumps(taskExecData)).toJson())