Saving list in django database

Question

I have a question about saving a list in Django database. Let me explain my problem, is pretty complex so I hope you understand that. At the base, I have a list of values (called learning objectives) where each student will have a grade from 1 to 5. Now, the idea is that the teacher, to give the evaluation, will press a checkbox corresponding to each grade and the database will create some sort of record to store the student's evaluation.

models.py

GRADING_VALUE = (
    ('1', '1'),
    ('2', '2'),
    ('3', '3'),
    ('4', '4'),
    ('5', '5'),
)


class Grading(models.Model):
    value = models.CharField(max_length=10, choices=GRADING_VALUE)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.value


class LearningObjective(models.Model):
    name = models.CharField(max_length=300)
    mission = models.ForeignKey(Mission, on_delete=models.DO_NOTHING)
    grading = models.ForeignKey(
        Grading, on_delete=models.DO_NOTHING, blank=True, null=True)
    note = models.ForeignKey(
        Note, on_delete=models.DO_NOTHING, null=True, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return self.name


class MissionEntry(models.Model):
    mission = models.ForeignKey(Mission, on_delete=models.DO_NOTHING)
    log_entry = models.ForeignKey(LogEntry, on_delete=models.DO_NOTHING)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

    def __str__(self):
        return str(self.mission) + ' ' + str(self.log_entry)


class LearningObjGradingNote(models.Model):
    learning_objective = models.ForeignKey(
        LearningObjective, on_delete=models.DO_NOTHING, blank=True, null=True)
    grade = models.ForeignKey(
        Grading, on_delete=models.DO_NOTHING, blank=True, null=True)
    note = models.ForeignKey(
        Note, on_delete=models.DO_NOTHING, blank=True, null=True)
    created_at = models.DateTimeField(auto_now_add=True)
    updated_at = models.DateTimeField(auto_now=True)

views.py

def mission_test(request, pk):
    mission = Mission.objects.get(id=pk)
    learning_obj = LearningObjective.objects.filter(mission_id=mission)
    grading = Grading.objects.all()
    aircrafts = Aircraft.objects.all()
    aerodromes = Aerodrome.objects.all()
    function_type = FunctionType.objects.all()
    students = Student.objects.all()
    instructors = Instructor.objects.all()
    context = {
        'mission': mission,
        'learning_obj': learning_obj,
        'grading': grading,
        'aircrafts': aircrafts,
        'aerodromes': aerodromes,
        'function_type': function_type,
        'students': students,
        'instructors': instructors
    }
    if request.method == 'POST':
        aircraft = request.POST.get('aircraft')
        adep = request.POST.get('adep')
        ades = request.POST.get('ades')
        date = request.POST.get('date')
        etd = request.POST.get('etd')
        ata = request.POST.get('ata')
        function_type_obj = request.POST.get('function_type')
        student = request.POST.get('student')
        instructor = request.POST.get('instructor')
        note = request.POST.get('note')
        comment = request.POST.getlist('comment')
        grade = request.POST.getlist('grade')

        comment_list = []
        for com in comment:
            comment_list.append(com)
        print(comment_list)

        grade_list = []
        for g in grade:
            grade_list.append(g)
        print(grade_list)
        lo_list = []
        for lo in learning_obj:
            lo_list.append(lo)
        print(lo_list)

        try:
            log_entry = LogEntry.objects.create(aircraft_id=aircraft, adep_id=adep, ades_id=ades, date=date, etd=etd,
                                                ata=ata, function_type_id=function_type_obj, student_id=student, instructor_id=instructor, note=note)
            print(log_entry)

            learning_objective = LearningObjective(
                grading_id=grade_list, note_id=comment_list, learning_objective=learning_obj)
            learning_objective.save()

            mission_entry = MissionEntry.objects.create(
                log_entry_id=log_entry, mission_id=mission)
            learning_obj.save()
            log_entry.save()
            mission_entry.save()

            messages.success(request, "Successfully Added New Flight")
            return HttpResponseRedirect(reverse('mission:mission_test', kwargs={'pk': pk}))
        except:
            messages.error(request, "Failed to Add New Flight")
            return HttpResponseRedirect(reverse('mission:mission_test', kwargs={'pk': pk}))

    return render(request, 'mission/mission_test.html', context)

Now, the part where I am having problem (let alone I know there are other things to be fixed, but I am on it) is in saving the list of grading and comments (which can be also empty) for each learning objective. How can I do that with a for loop? I hope I was clear enough.

Saving list in django database

Answers (1)

Related Questions