I am trying to use prefetch_related’s new Prefetch option to further filter
a database query. Using debug toolbar I can see that prefetch_related is
doing its job in making only three DB queries. However, I am positive that
the queryset filter I’m passing in is not working. Even though I’m using
the option, all of the records are being retrieved in the query.
The goal of the below code is to show a list of Chapters. For each chapter,
show its lessons. For each lesson, show the logged in user’s status
(complete/incomplete).
Models
class Chapter(models.Model):
status = models.IntegerField(choices=STATUS_CHOICES, default=1)
name = models.CharField(max_length=100)
slug = AutoSlugField(populate_from='name')
desc = models.TextField()
class Lesson(models.Model):
name = models.CharField(max_length=100)
chapter = models.ForeignKey(Chapter, related_name=‘les_chapter’)
class LessonStatus(models.Model):
status = models.IntegerField(choices=STATUS_CHOICES, default=1)
lesson = models.ForeignKey(Lesson, related_name="status_lesson")
student = models.ForeignKey(User)
chapter = models.ForeignKey(Chapter, related_name=“status_chapter")
View
def chapter_list(request, course_slug):
course = Course.objects.get(slug=course_slug)
chapters = Chapter.objects.filter(course=course).prefetch_related(
Prefetch('status_chapter__lesson__chapter',
queryset=LessonStatus.objects.filter(student=request.user)),
)
return TemplateResponse(request,
'course/chapter_list_parent.html',
{'chapters': chapters, 'course': course,}
)
Template
<div id="chapters">
{% for ch in chapters %}
<p>{{ ch.name }}</p>
{% for le in ch.status_chapter.all %}
<p>lesson status: {{ le.status }}</p>
<p>lesson name: {{ le.lesson.name }}</p>
{% endfor %}
{% endfor %}
</div>
When I run this code the LessonStatus is not being filtered by
student=request.user. Instead, it is simply getting all LessonStatus
records, including those that are for other users.
Can anyone see if there's something wrong with the above code? Or any ideas
how to troubleshoot? There are no errors generated.
--
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 http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/2ac2f5c7-ecc8-49b8-9329-db3646c16a83%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
