如何在Django中获取多对多字段中的对象的查询集

Question

我在 models.py 中有两个模型 Student 和 Classroom

class Classroom(models.Model):
    classroom_subject = models.CharField(max_length=100)
    classroom_code = models.CharField(max_length= 5, default = '00000')
    teacher = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)

class Student(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, primary_key=True)
    student_name = models.CharField(max_length=100)
    classes = models.ManyToManyField(Classroom, blank = True)

我的数据库中有三个表

Student:

user_id	Student_name
1	4
2	4
3	1

Classroom:

id	Classroom_subject	Classroom_code
1	maths	12345
2	english	12345
3	Biology	12345

Student_classes:

id	Student_id	Classroom_id
1	4	1
2	4	2
3	1	1

在我的views.py中

class StudentClassesView(ListView):
    model = Classroom
    template_name = 'student_classroom_list.html'
    context_object_name = 'classroom_list'

    
    def get_queryset(self):
        student_id = self.request.user.id
        return Student.classes.through.objects.filter(
        )

这段代码返回student_classes中的所有教室，但我希望它返回student_id = self.request.user.id的所有教室

因此例如self.request.user.id返回4，我想要student_classes表中student_id的所有教室= 4。

Answer 1

使用：

Classroom.objects.filter(
    student__user=request.user
)

这将检索相关学生将request.user作为user的所有Classroom。