def mime(request):
if request.method == "GET":
startdate = datetime.strptime("03/Feb/2014", "%d/%b/%Y")
enddate = datetime.strptime("05/Feb/2014", "%d/%b/%Y")
queryset = logdata.objects.values("mime").annotate(Count("mime")).filter(date__range=[startdate, enddate])
serializer = logdataSerializer(queryset, many=True)
# return HttpResponse(JSONRenderer().render(serializer.data))#queryset#serializer.data
content = JSONRenderer().render(queryset)
return HttpResponse(JSONRenderer().render(queryset)) # (json.dumps(content), content_type='application/json')
elif request.method == "POST":
data = JSONParser().parse(request)
serializer = logdataSerializer(data=data)
if serializer.is_valid():
serializer.save()
return HttpResponse(JSONRenderer().render(serializer.data), status=201)
return HttpResponse(serializer.errors, status=400)
def data(request):
if request.method == "GET":
startdate = datetime.strptime("03/Feb/2014", "%d/%b/%Y")
enddate = datetime.strptime("05/Feb/2014", "%d/%b/%Y")
FromMB = 10 * 2048
ToMB = 50 * 2048
queryset = (
logdata.objects.values("username")
.annotate(Sum("byte_transferred"))
.filter(date__range=[startdate, enddate])
.filter(byte_transferred__range=[FromMB, ToMB])
)
serializer = logdataSerializer(queryset, many=True)
# return HttpResponse(JSONRenderer().render(serializer.data))#queryset#serializer.data
content = JSONRenderer().render(queryset)
return HttpResponse(JSONRenderer().render(queryset))
elif request.method == "POST":
data = JSONParser().parse(request)
serializer = logdataSerializer(data=data)
if serializer.is_valid():
serializer.save()
return HttpResponse(JSONRenderer().render(serializer.data), status=201)
return HttpResponse(serializer.errors, status=400)
def website(request):
if request.method == "GET":
startdate = datetime.strptime("03/Feb/2014", "%d/%b/%Y")
enddate = datetime.strptime("05/Feb/2014", "%d/%b/%Y")
website_name = "http://192.168.50.252/schoolquizplus/teachers/lectures/mylectures.jsp?Action=New&TeacherID=32"
queryset = (
logdata.objects.values("referrer_url", "http_status", "username")
.annotate(Count("referrer_url"))
.filter(date__range=[startdate, enddate])
.filter(referrer_url=website_name)
)
serializer = logdataSerializer(queryset, many=True)
# return HttpResponse(JSONRenderer().render(serializer.data))#queryset#serializer.data
content = JSONRenderer().render(queryset)
return HttpResponse(JSONRenderer().render(queryset))
elif request.method == "POST":
data = JSONParser().parse(request)
serializer = logdataSerializer(data=data)
if serializer.is_valid():
serializer.save()
return HttpResponse(JSONRenderer().render(serializer.data), status=201)
return HttpResponse(serializer.errors, status=400)
def username(request):
if request.method == "GET":
startdate = datetime.strptime("03/Feb/2014", "%d/%b/%Y")
enddate = datetime.strptime("05/Feb/2014", "%d/%b/%Y")
user_name = "pb114uvgjc1-16"
queryset = (
logdata.objects.values("username", "referrer_url")
.annotate(Count("referrer_url"))
.filter(date__range=[startdate, enddate])
.filter(username=user_name)
)
serializer = logdataSerializer(queryset, many=True)
# return HttpResponse(JSONRenderer().render(serializer.data))#queryset#serializer.data
content = JSONRenderer().render(queryset)
return HttpResponse(JSONRenderer().render(queryset))
elif request.method == "POST":
data = JSONParser().parse(request)
serializer = logdataSerializer(data=data)
if serializer.is_valid():
serializer.save()
return HttpResponse(JSONRenderer().render(serializer.data), status=201)
return HttpResponse(serializer.errors, status=400)
