如何在Django models.py中查询相关模型 [英] How to query related models in django models.py

问题描述

我有一个如下所示的用户模型：

I have a user model which looks like this:

class User(AbstractUser):
    first_name = models.CharField(max_length=70)
    last_name = models.CharField(max_length=70)
    middle_name = models.CharField(max_length=70, blank=True)
    email = models.EmailField(
        max_length=254,
        unique=True,
        verbose_name='Email Address',
        blank=True
    )
    is_student = models.BooleanField(default=False, verbose_name='Student')
    is_superuser = models.BooleanField(default=False, verbose_name='Administrator')
    is_teacher = models.BooleanField(default=False, verbose_name='Teacher')
    is_staff = models.BooleanField(default=False, verbose_name='Staff')
    is_registrar = models.BooleanField(default=False, verbose_name='Registrar')

，在我的 StudentPorile 模型中，我有一个名为 class_advisor 与用户模型，我需要使用 is_teacher 字段为True的用户。现在，如何过滤 class_advisor 字段以仅返回 is_teacher = True 的用户？

and in my StudentPorile model I have a field called class_advisor which is related to User model and I need to get the users with is_teacher field is True. Now, how do i filter class_advisor field to return Users only with is_teacher=True?

这是我的 StudentProfile 模型：

class StudentProfile(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, primary_key=True)
    lrn = models.CharField(max_length=20)
    landline_number = models.CharField(max_length=11, null=True, blank=True)
    mobile_number = models.CharField(max_length=11, null=True, blank=True)
    address = models.TextField(max_length=300, blank=True)
    mothers_name = models.CharField(max_length=50)
    fathers_name = models.CharField(max_length=50)
    contact_person_name = models.CharField(max_length=50)
    contact_person_number = models.CharField(
        max_length=12, verbose_name='Phone number of Contact Person')
    # class_advisor = IM STUCK HERE
    year_level = models.OneToOneField(Year_Level, on_delete=models.SET_NULL, null=True)
    section = models.OneToOneField(Section, on_delete=models.SET_NULL, null=True)

推荐答案

这应返回具有<$ c的所有用户的 queryset $ c> is_teacher 属性设置为 True

This should return you a queryset of all the Users who have their is_teacher attribute set to True

User .objects.filter（is_teacher = True）

views.py

class MyView(View):
    def get(self, request):
       filtered_users = User.objects.filter(is_teacher=True)
       return render(request, 'home.html', context={'users': filtered_users})

template.html

template.html

{% for user in users %}
    {{user}}
{% endfor %}

这篇关于如何在Django models.py中查询相关模型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！