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