def view_ratings(request):
userID = request.GET.get("userid")
if not (userID and pci.is_userID_present(userID)):
return HttpResponse("<b>Error:</b> UserID '" + str(userID) + "' not found")
query_result = pci.show_ratings(userID)
response_dict = {}
response_dict["title"] = "View ratings"
response_dict["table_caption"] = "Ratings of userID '" + str(userID) + "'"
response_dict["table_headers"] = query_result.columns
response_dict["table_rows"] = query_result
return render(request, "render_table.html", response_dict)
def update_rating(request):
userID = request.GET.get("userid")
if not (userID and pci.is_userID_present(userID)):
return HttpResponse("<b>Error:</b> UserID '" + str(userID) + "' not found")
movieID = request.GET.get("movieid")
if not(movieID and pci.is_movieID_present(movieID)):
return HttpResponse("<b>Error:</b> MovieID '" + str(movieID) + "' not found")
rating = request.GET.get("rating")
if not (int(rating) >=1 and int(rating) <= 5):
return HttpResponse("<b>Error:</b> Invalid rating value '" + str(rating) + "'")
query_result = pci.update_rating(userID, movieID, rating)
return HttpResponse("Rating updated!!")
def get_recommendations(request):
userID = request.GET.get("userid")
if not (userID and pci.is_userID_present(userID)):
return HttpResponse("<b>Error:</b> UserID '" + str(userID) + "' not found")
pci.user_avg_rating(userID)
pci.compute_similarity(userID)
query_result = pci.get_recommendations(userID)
response_dict = {}
response_dict["title"] = "View recommendations"
response_dict["table_caption"] = "Recommendations for userID '" + str(userID) + "'"
response_dict["table_headers"] = query_result.columns
response_dict["table_rows"] = query_result
return render(request, "render_table.html", response_dict)
