def linegraph_lmrtt(request):
device = request.GET.get('deviceid')
filter_by = request.GET.get('filter_by')
details = Devicedetails.objects.filter(deviceid=device)[0]
all_device_details= MLmrtt.objects.filter(average__lte=3000).order_by('eventstamp')
device_details = all_device_details.filter(deviceid=device)
other_device_details = []
filtered_deviceids = []
if (filter_by == 'location'):
filtered_deviceids = Devicedetails.objects.filter(city=details.city).exclude(deviceid=device)
if (filter_by == 'provider'):
filtered_deviceids = Devicedetails.objects.filter(isp=details.isp).exclude(deviceid=device)
for row in filtered_deviceids:
other_device_details.extend(all_device_details.filter(deviceid=row.deviceid))
result=[]
result.append(cvs_helper.linegraph_normal(device_details,'Last mile latency',1,1))
if (filter_by != 'none'):
bucket_width = 2*3600
result.append(cvs_helper.linegraph_bucket(other_device_details,bucket_width,'median'))
answer = str(result).replace("['","[")
answer = answer.replace(")'",")")
return HttpResponse("(" + answer + ")")
def linegraph_bitrate(request):
g_filter = Graph_Filter(request)
chosen_limit = 100000000
details = Devicedetails.objects.filter(deviceid=g_filter.device)[0]
all_device_details= MBitrate.objects.filter(average__lte=chosen_limit).order_by('eventstamp')
other_device_details_netperf_3 = []
other_device_details_other = []
filtered_deviceids = []
if (g_filter.filter_by == 'location'):
filtered_deviceids = Devicedetails.objects.filter(city=details.city).exclude(deviceid=g_filter.device)
if (g_filter.filter_by == 'provider'):
filtered_deviceids = Devicedetails.objects.filter(isp=details.isp).exclude(deviceid=g_filter.device)
for row in filtered_deviceids:
other_device_details_other.extend(all_device_details.filter(deviceid=row.deviceid).exclude(toolid='NETPERF_3'))
other_device_details_netperf_3.extend(all_device_details.filter(deviceid=row.deviceid).filter(toolid='NETPERF_3'))
if (g_filter.graphno==1):
all_device_details = all_device_details.filter(srcip='143.215.131.173')
elif (g_filter.graphno==2):
all_device_details = all_device_details.filter(dstip='143.215.131.173')
my_device_details = all_device_details.filter(deviceid=g_filter.device)
my_device_details_netperf_3 = my_device_details.filter(toolid='NETPERF_3')
my_device_details_other = my_device_details.exclude(toolid='NETPERF_3')
result=[]
result.append(cvs_helper.linegraph_normal(my_device_details_netperf_3,"Multi-threaded TCP",1000,18000))
result.append(cvs_helper.linegraph_normal(my_device_details_other,"Single-threaded TCP",1000,18000))
if (g_filter.filter_by != 'none'):
bucket_width = 24*3600
result.append(cvs_helper.linegraph_bucket(other_device_details_netperf_3,bucket_width,"multi-median"))
result.append(cvs_helper.linegraph_bucket(other_device_details_other,bucket_width,"single-median"))
answer = str(result).replace("'D","D")
answer = answer.replace(")'",")")
return HttpResponse("(" + answer + ")")