Pfthb

I am working on a result processing website and I've been trying to update multiple fields in each row of table. User should be able to input updated CA Score and EXAM Score values and it should update each student's CA Score and EXAM Score values which has been submitted. image of page

Someone ask same question here trying to update a single field. I tried to work with the solution provided there but was unable to make it suit my need

template

<form action="" method="post"> % csrf_token %
% for student in students %
<tr>
 <td> student.id_number </td>
 <td>
 <input type="number" value=" student.ca " name="student_ student.id ">
 </td>
 <td>
 <input type="number" value=" student.exam " name="student_ student.id ">
 </td>
</tr>
% endfor %
<tr>
 <td><input type="submit" value="Save"></td>
</tr>
</tbody>
</table>
</form>

view

def add_score_for(request, id):
 if request.method == 'GET':
 students = TakenCourse.objects.filter(course__allocated_course__lecturer__pk=request.user.id).filter(course__id=id)
 context = "students":students
 return render(request, 'result/add_score_for.html', context)

 if request.method == 'POST':
 data = request.POST.dict()
 data.pop('csrfmiddlewaretoken', None)
 for i in data.items():
 obj = TakenCourse.objects.get(id=i[0].split("_")[1])
 if not str(obj.ca) == str(i[1]): # if i do i[2] trying to get for exams it raise 'tuple index out of range'
 obj.ca = i[1]
 obj.save()

In plain Django you would solve this using Formsets:
https://docs.djangoproject.com/en/2.1/topics/forms/formsets/

This will generate the markup (or allow you to generate the markup) you need to update multiple students which will then be updated on submit. It also allows to add the entries (you can disable this feature).

Here is how i solved my problem, don't know if its the best way to do it but it did solve my issue

views

@lecturer_required 
def add_score_for(request, id):
 current_semester = Semester.objects.get(is_current_semester=True)
 if request.method == 'GET':
 ...
 return render(request, 'result/add_score_for.html', context)

 if request.method == 'POST':
 ids = ()
 data = request.POST.copy()
 data.pop('csrfmiddlewaretoken', None) # remove csrf_token
 for key in data.keys():
 ids = ids + (str(key),) # gather all the all students id (i.e the keys) in a tuple
 for s in range(0,len(ids)): # iterate over the list of student ids gathered above
 score = data.getlist(ids[s]) # get list of score for current student in the loop
 ca = score[0] # subscript the list to get the fisrt value > ca score
 exam = score[1] # do thesame for exam score
 obj = TakenCourse.objects.get(student__pk=ids[s]) # get the current student data
 obj.ca = ca # set current student ca score
 obj.exam = exam # set current student exam score
 obj.total = obj.get_total(ca=ca,exam=exam)
 obj.grade = obj.get_grade(ca=ca,exam=exam)
 obj.comment = obj.get_comment(obj.grade)
 obj.save()
 return HttpResponseRedirect(reverse_lazy('add_score_for', kwargs='id': id))
 return HttpResponseRedirect(reverse_lazy('add_score_for', kwargs='id': id))