Deleting a ManytoMany Relationship Data in Django Project

Question

I have tried to fix this issue for a while.

I have a model where there are logs entered by users and saved in Log Model. Also there is ActiveSession Model which has a ManytoMany relationship with Log Model.

In My views I am getting the POST and saving them in the Log Model. The next step is my issue where I am trying to add unqiue Logs inside the ActiveSession Model. By unique I mean by searching a field called 'log_order' in the Log Model.

The desired outcome is to:

1: Get the POST form and save the Log details in the Log Model

2: Search if the new saved Log has been previously added the many to many relation log under Active Session Model

3: If there is no Log in the ActiveSession Model to add the new Log in the Post to the activesession

4: If there are logs previously saved in ActiveSession to search for the log_order related to these logs

5: If there is no same log_order to add the new Log in the Post to the activesession

6: If the log_order is existing inside the activesession logs to delete this specific log and to add the new Log in the Post to the activesession

Models.py:

class Log(models.Model):
    ...................................
    log_order = models.IntegerField(validators=[MinValueValidator(1)],blank=True, null=True)
    date = models.DateTimeField(...........)

class LogForm(forms.Form):
    .............................
    log_order = forms.IntegerField()

class ActiveSession(models.Model):
    log = models.ManyToManyField(Log)
    ..................................

Views.py:

def addlog(request, id):
    active_session = ActiveSession.objects.get(id=ActiveSession.objects.last().id)
        if request.method == 'POST':
            form = LogForm(request.POST)
            if form.is_valid():
                data = Log()
                data.log_order = request.POST.get('log_order')
                data.log_repetitions = form.cleaned_data['log_repetitions']
                data.log_weight = form.cleaned_data['log_weight']
                data.save()
                if active_session.log.values():
                    for i in active_session.log.values():
                        existing = i['log_order']
                        new = data.log_order
                        if int(existing) == int(new):
                            active_session.delete(active_session.log)
                            active_session.log.add(data)
                            active_session.save()
                        else:
                            active_session.log.add(data)
                else:
                    active_session.log.add(data)

I have tried to save the data and update() but nothing is changing the dictionary the same exisiting outcome is printed and the new data is not replacing the existing ones. My objective is replace and avoid duplicating.

Update: I am also thought of if the keys is i['log_order'] is equal to data.log_order to delete the whole dictionary and add the new data whichever is easier

Trial: With the below trial I got 'ManyRelatedManager' object is not subscriptable. I am not sure if I am going the wrong direction.

                if active_session.log.values():
                    for i in range(len(active_session.log.values())):
                        new = data.log_order
                        if active_session.log[i]['log_order'] == new:
                            active_session.save()
                        else:
                            active_session.log.add(data)
                else:
                    active_session.log.add(data)

Here is the current query:

here is the requested query:

Deleting a ManytoMany Relationship Data in Django Project

0 Answers