What exactly I need?
I have 2 models Product and Photo(having ForeignKey relationship with
Product). Now suppose I inserted 3 products in Product table. For the 3rd
product I not inserted any photo in Photo table. I want to fetch all the
Products along with Photos but for the 3rd product photo should come as
null(or None) because I not inserted. why I am doing like this because for
the product for which no photos are uploaded I can check in the template
that if null or None is coming as a photo then show a default image
referring it from the static folder. I know we can achieve it using left
join but how to achieve it in Django style?
What I have tried?
q=Product.objects.all().filter(photo__isnull=True)
print(q.query)
SELECT "app_product"."id", "app_product"."name" FROM "app_product" LEFT
OUTER JOIN "app_photo" ON
("app_product"."id" = "app_photo"."product_id") WHERE "app_photo"."id" IS
NOT NULL
If in the above query I remove the where clause my problem will be resolved?
So how to do that in a django way?
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/c8c00d69-f136-4c65-a87b-8466bcb2d866%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
