def winBar(request): GET = request.GET endGameQuery = EndGame.objects.all() # set data config if "delta" in GET: delta = int(GET["delta"]) else: delta = 10 if "offset" in GET: offset = int(GET["offset"]) else: offset = 5 iMax = math.floor((90 - offset) / delta) unit = "min" endGameQuery = filterByMapAndVersion(endGameQuery, GET) endGameQuery = filterByLocation(endGameQuery, GET) q1 = endGameQuery.clone().filter(winner=1) q2 = endGameQuery.clone().filter(winner=2) average = endGameQuery.clone().average("length") data1 = {} for g in q1: l = g.length i, cat = findCategory(l / 60, delta, iMax, unit, offset) if i >= 0: if not data1.has_key(i): data1[i] = {"cat": cat, "count": 0} data1[i]["count"] += 1 data1 = [[key, val] for key, val in data1.items()] data2 = {} for g in q2: l = g.length i, cat = findCategory(l / 60, delta, iMax, unit, offset) if i >= 0: if not data2.has_key(i): data2[i] = {"cat": cat, "count": 0} data2[i]["count"] += 1 data2 = [[key, val] for key, val in data2.items()] data = [] for ii in range(min(len(data1), len(data2))): data.append([data1[ii][1]["cat"], data1[ii][1]["count"], data2[ii][1]["count"]]) data = {"data": data, "average": int(average), "order": ["Marines", "Aliens"], "colors": ["#3366cc", "#dc3912"]} dataJSON = json.dumps(data) return HttpResponse(dataJSON)
def cpuspeed(request): cpuQuery = CPU.objects.all().scalar("cpuspeed") data = {} for c in cpuQuery: i, cat = findCategory(c * 1.0 / 1000, 0.5, 6, "GHz") if not data.has_key(cat): data[cat] = 0 data[cat] += 1 data = {"data": [[str(key), val] for key, val in data.items()]} dataJSON = json.dumps(data) return HttpResponse(dataJSON)