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)
