def task6(request):
temp = helper.Helper()
array = temp.query6()
return render(request, 'tasks/task6.html', {
'Value': array[0],
"Query": array[1]
})
def task7(request):
if request.method == "POST":
genre = request.POST['genre']
year = request.POST['year']
temp = helper.Helper()
array = temp.query7(year, genre)
return render(request, 'tasks/task7.html', {
'Value': array,
'Genre': genre
})
return render(request, 'tasks/task7.html')
def task3(request):
user = request.user
temp = helper.Helper()
name = user.first_name.split(" ")
array = temp.query3(name[0], "Day")
return render(
request, 'tasks/task3.html', {
'Value': array[0],
"Value2": array[1],
"Query": array[2],
"fname": name[0],
"lname": "Day"
})
def task8(request):
if request.method == "POST":
genre = request.POST['genre']
director = request.POST['director']
actor = request.POST['actor']
year = request.POST['year']
character = request.POST['character']
movie = request.POST['movie']
temp = helper.Helper()
array = temp.query8(movie, actor, character, genre, year, director)
if array != []:
new_array = temp.getUid(array[0]["uid"])
return render(request, 'tasks/task8.html', {'Value': new_array})
return render(request, 'tasks/task8.html')
def task2(request):
temp = helper.Helper()
array = temp.query2()
count = 0
sum = 0
for i in array[1]:
t = i["initial_release_date"].split("-")
sum += int(t[0])
count += 1
avg = int(sum / count)
return render(request, 'tasks/task2.html', {
'Value': array[0],
"Year": avg,
"Query": array[2]
})
def startTask(request):
task = ThreadTask()
task.save()
temp = helper.Helper()
temp.query5(task.id)
return JsonResponse({'id': task.id})