pythondjangoformsmo

Django IntegrityError When Submitting Form (pre-populating in views)


I haven't be able to find a solid answer for my problems. I am trying to pre-populate form in views. So when user works with form, some data is already been taken care for. What am I trying to do is to automatically get user username and his group and feed that into database. But when I try to do that I get IntegrityError NOT NULL constraint failed.

I am new to this and I'm learning from MDN web docs.

My views.py:

class AddNewView(generic.View):
    formClass = AddNewForm
    template_name = 'myapp/subscription_form.html'

    def get(self, request):
        form = self.formClass(None)
        return render(request, self.template_name, {'form': form})

    def post(self, request):

        form = self.formClass(request.POST)

        if form.is_valid():
            subscription = form.save(commit=False)

            organization = request.user.groups.values_list('id', flat=True).first()
            input_user = self.request.user
            stuff = form.cleaned_data['stuff']
            description = form.cleaned_data['description']

            subscription.save()

        return render(request, self.template_name, {'form': form})

forms.py:

class AddNewForm(forms.ModelForm):
    def __init__(self, *args,**kwargs):
        super (AddNewView, self ).__init__(*args,**kwargs) 

    class Meta:
        model = Subscription
        fields = [
            'stuff',
            'description',
        ]

models.py:

class Subscription(models.Model):
    organization = models.ForeignKey(Group, help_text="which organization")
    input_user = models.CharField(max_length=150)
    input_date = models.DateTimeField(auto_now_add=True)
    description = models.CharField(max_length=1000, null=True, blank=True, help_text='Description')
    stuff = models.CharField(max_length=100)

html:

{% extends "base_generic.html" %}

{% block content %}

<form action="" method="post">
    {% csrf_token %}
    <table>
    {{ form.as_table }}
    </table>
    <input type="submit" value="Submit" />

</form>
{% endblock %}

The error I get is: Exception Type: IntegrityError Exception Value:
NOT NULL constraint failed: myapp_myapp.organization_id

I appreciate any help that you can provide


Solution

  • you are not actually assigning the values to your subscription columns

       if form.is_valid():
            subscription = form.save(commit=False)
    
            subscription.organization = request.user.groups.first()
            subscription.input_user = self.request.user
            subscription.stuff = form.cleaned_data['stuff']
            subscription.description = form.cleaned_data['description']
    
            subscription.save()