def ping_last_24_hours(request,station_id):
"csv view for last 24 hours"
response = HttpResponse(mimetype='text/csv')
writer = csv.writer(response)
writer.writerow(['bikes','free','hour'])
for ping in Ping.last_24_hours(station_id):
writer.writerow([ping['bikes'],ping['free'],ping['hour']])
return response
def ping_last_24_hours(request,station_id):
"json view for last 24 hours"
bikes = []
free = []
hours = []
for ping in Ping.last_24_hours(station_id):
bikes.append(int(ping['bikes']))
free.append(int(ping['free']))
hours.append(str(ping['hour']))
elements = [
{
"colour": "#ff0000",
"type": "line_dot",
"values": bikes,
"text": "bikes",
"dot-size": 3,
},
{
"type": "line_dot",
"colour": "#00ff00",
"values": free,
"text": "free places",
"dot-size": 3,
},
]
graph = {
"title": { "text": "Average By Hour" },
"elements": elements,
"y_axis": {
"min": 0,
"max": 39,
"steps": 3
},
"x_axis": {
"labels": { "labels" : hours },
}
}
return HttpResponse(json.dumps(graph))
def ping_last_24_hours(request,station_id):
return __pings(Ping.last_24_hours(station_id))
