def get_bitrate_measurements(device, days, direction, multi):
threading = "multi"
data = []
end = datetime.now()
start = datetime_helper.get_daterange_start(int(days))
rows = MBitrate.objects.filter(deviceid=device,
eventstamp__gte=start,
eventstamp__lte=end,
direction=direction)
if len(rows) == 0:
return []
if multi == "1":
rows = rows.filter(toolid='NETPERF_3')
else:
rows = rows.exclude(toolid='NETPERF_3')
threading = "single"
for r in rows:
try:
eventstamp = datetime_helper.datetime_to_JSON(r.eventstamp)
d = [eventstamp, float(r.average)]
data.append(d)
except:
continue
return dict(device=device,
days=days,
data=data,
direction=direction,
threading=threading)
def compare_by_isp(request, isp, country):
end_date=datetime.now()
#default daterange is 7 days:
start_date=datetime_helper.get_daterange_start(7)
start_day=start_date.day
start_month=start_date.month
start_year=start_date.year
end_day=end_date.day
end_month=end_date.month
end_year=end_date.year
return render_to_response('compare_by_isp.html', {'isp' : isp, 'country' : country, 'city' : 'none', 'start_day' : start_day, 'start_month' : start_month, 'start_year' : start_year, 'end_day' : end_day, 'end_month' : end_month, 'end_year' : end_year})
def compare_by_country(request, country):
#default daterange is last 7 days:
end_date=datetime.now()
start_date=datetime_helper.get_daterange_start(7)
start_day=start_date.day
start_month=start_date.month
start_year=start_date.year
end_day=end_date.day
end_month=end_date.month
end_year=end_date.year
return render_to_response('compare_by_country.html', {'country' : country, 'start_day' : start_day, 'start_month' : start_month, 'start_year' : start_year, 'end_day' : end_day, 'end_month' : end_month, 'end_year' : end_year})
def countries_vis(request):
server_list = database_helper.get_server_list()
end_date=datetime.now()
start_date=datetime_helper.get_daterange_start(31)
start_day=start_date.day
start_month=start_date.month
start_year=start_date.year
end_day=end_date.day
end_month=end_date.month
end_year=end_date.year
return render_to_response('countries_vis.html', {'server_list': server_list, 'start_day':start_day,'start_month':start_month,'start_year':start_year,'end_day':end_day,'end_month':end_month,'end_year':end_year});
def get_lmrtt_measurements(device,days): threading = "multi" data = [] end = datetime.now() start = datetime_helper.get_daterange_start(int(days)) rows = MRtt.objects.filter(deviceid=device,eventstamp__gte=start,eventstamp__lte=end) if len(rows)==0: return [] for r in rows: try: eventstamp = datetime_helper.datetime_to_JSON(r.eventstamp) d = [eventstamp, float(r.average)] data.append(d) except: continue return dict(device=device,days=days,data=data)
def get_lmrtt_measurements(device, days):
threading = "multi"
data = []
end = datetime.now()
start = datetime_helper.get_daterange_start(int(days))
rows = MRtt.objects.filter(deviceid=device,
eventstamp__gte=start,
eventstamp__lte=end)
if len(rows) == 0:
return []
for r in rows:
try:
eventstamp = datetime_helper.datetime_to_JSON(r.eventstamp)
d = [eventstamp, float(r.average)]
data.append(d)
except:
continue
return dict(device=device, days=days, data=data)
def compare_by_country(request, country):
#default daterange is last 7 days:
end_date = datetime.now()
start_date = datetime_helper.get_daterange_start(7)
start_day = start_date.day
start_month = start_date.month
start_year = start_date.year
end_day = end_date.day
end_month = end_date.month
end_year = end_date.year
return render_to_response(
'compare_by_country.html', {
'country': country,
'start_day': start_day,
'start_month': start_month,
'start_year': start_year,
'end_day': end_day,
'end_month': end_month,
'end_year': end_year
})
def countries_vis(request):
server_list = database_helper.get_server_list()
end_date = datetime.now()
start_date = datetime_helper.get_daterange_start(31)
start_day = start_date.day
start_month = start_date.month
start_year = start_date.year
end_day = end_date.day
end_month = end_date.month
end_year = end_date.year
return render_to_response(
'countries_vis.html', {
'server_list': server_list,
'start_day': start_day,
'start_month': start_month,
'start_year': start_year,
'end_day': end_day,
'end_month': end_month,
'end_year': end_year
})
def get_bitrate_measurements(device,days,direction,multi): threading = "multi" data = [] end = datetime.now() start = datetime_helper.get_daterange_start(int(days)) rows = MBitrate.objects.filter(deviceid=device,eventstamp__gte=start,eventstamp__lte=end,direction=direction) if len(rows)==0: return [] if multi=="1": rows = rows.filter(toolid='NETPERF_3') else: rows = rows.exclude(toolid='NETPERF_3') threading = "single" for r in rows: try: eventstamp = datetime_helper.datetime_to_JSON(r.eventstamp) d = [eventstamp, float(r.average)] data.append(d) except: continue return dict(device=device,days=days,data=data,direction=direction,threading=threading)
def compare_by_isp(request, isp, country):
end_date = datetime.now()
#default daterange is 7 days:
start_date = datetime_helper.get_daterange_start(7)
start_day = start_date.day
start_month = start_date.month
start_year = start_date.year
end_day = end_date.day
end_month = end_date.month
end_year = end_date.year
return render_to_response(
'compare_by_isp.html', {
'isp': isp,
'country': country,
'city': 'none',
'start_day': start_day,
'start_month': start_month,
'start_year': start_year,
'end_day': end_day,
'end_month': end_month,
'end_year': end_year
})
