Skip to content

Tag: django-models

How do I solve django.db.utils.IntegrityError: UNIQUE constraint failed?

How do I solve django.db.utils.IntegrityError: UNIQUE constraint failed? error code is django.db.utils.IntegrityError: UNIQUE constraint failed: Movies_comment.user_id, Movies_comment.tv_or_movie_id. This error occurs Comment(comment=form.cleaned_data[“comment”],user=request.user,stars=form.cleaned_data[“stars”],tv_or_movie=tv_or_movie_object).save() Answer tv_or_movie before saving i.e.

Unsupported lookup ‘category’ for CharField or join on the field not permitted This is my file. I show error at: bestseller = Product.objects.filter(product__category__icontains=’BestSeller’) I want to Bestseller category product at index.html I use Django 4 and pyhton 3.9 Answer You can’t use CharField as a ForeignKey. It should be like this: Or like this (the same logic): This will output all Products in category with name BestSeller.

Django join tables with ForeignKey

I’m trying to join 3 tables with ForeignKey but it returns Null values. I’m using select related and also I tried Insight.objects.all() but both are not working. Here are my models: My View: Answer I solved my problem by the below, I could update the DB with the result of the below query

Saving related model objects in single view

I am beginner and I am working on Django project – risk assessment application. I have a trouble to achieve saving on related objects for my application risk record. I am using MultiModelForm to achieve the following. I am successfully creating Whatif instance and connecting it with GuideWordi instance on save, however, I am not able to connect my RiskRecordi