python - 需要基于更多模型构建Django查询集

Question

所以我说的可能看起来很复杂，但我认为答案很简单。我就是想不通。我有一个讲座模型的表格，登录的教师可以使用该表格仅发布其特定类(class)的讲座。问题是，在我的数据库中，我有一个 TeacherData 模型，其中包含用于验证的教师 ID 字段，因此如果输入的教师 ID 不匹配，教师无法在其他教师模型上创建自己的帐户。但是，当在数据库中创建类(class)时，使用的教师是来自 TeacherData 的教师。因此，要创建查询，我必须根据 TeacherData 过滤类(class)，然后使用 Teacher_ID 链接到教师模型。我只是不知道如何构建这个查询集，但我在模板中复制了所需的行为:

{% if user.is_authenticated and user.is_teacher %}
                <ul>
                    {% for data in teacher_data %}
                        {% if data.teacher_ID == user.teacher.teacher_ID %}
                            {% for course in courses %}
                                {% if course.teacher1 == data or course.teacher2 == data %}
                                     <li>
                                        <a href="{% url 'courses:courses' slug=course.slug %}">{{ course.name }}</a>
                                    </li>
                                {% endif %}
                            {% endfor %}
                        {% endif %}
                    {% endfor %}
                </ul>
{% endif %}




class Teacher(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, primary_key=True)
    name = models.CharField(max_length=30, null=True, blank=True, default=None)
    surname = models.CharField(max_length=50, null=True, blank=True, default=None)
    email = models.EmailField(unique=True, null=True, blank=True, default=None)
    teacher_ID = models.CharField(unique=True, max_length=14,
                                  validators=[RegexValidator(regex='^.{14}$',
                                                             message='The ID needs to be 14 characters long.')],
                                  null=True, blank=True, default=None)


class TeacherData(models.Model):
    name = models.CharField(max_length=30)
    surname = models.CharField(max_length=50)
    teacher_ID = models.CharField(unique=True, max_length=14)
    notes = models.CharField(max_length=255, default=None, blank=True)


class Lecture(models.Model):
    LECTURE_CHOICES = (
        ('Courses', 'Courses'),
        ('Seminars', 'Seminars'),
    )
    course = models.ForeignKey('Course', on_delete=models.CASCADE, default='', related_name='lectures', )
    lecture_category = models.CharField(max_length=10, choices=LECTURE_CHOICES, default='Courses', )
    lecture_title = models.CharField(max_length=100, blank=True, null=True)
    content = models.TextField(blank=False, default=None)

class Course(models.Model):
    study_programme = models.ForeignKey('StudyProgramme', on_delete=models.CASCADE, default='')
    name = models.CharField(max_length=50, unique=True)
    ects = models.PositiveSmallIntegerField(validators=[MaxValueValidator(99)])
    description = models.TextField()
    year = models.PositiveSmallIntegerField(validators=[MaxValueValidator(99)])
    semester = models.IntegerField(choices=((1, "1"),
                                            (2, "2"),
                                            ), default=None)
    teacher1 = models.ForeignKey('TeacherData', on_delete=models.CASCADE, default=None,
                                 verbose_name="Course Teacher", related_name='%(class)s_course_teacher')
    teacher2 = models.ForeignKey('TeacherData', on_delete=models.CASCADE, default=None, null=True,
                                 verbose_name="Seminar Teacher", related_name='%(class)s_seminar_teacher')




class LectureForm(forms.ModelForm):
    lecture_title = forms.CharField(max_length=100, required=True)
    course = forms.ModelChoiceField(initial=Course.objects.first(), queryset=Course.objects.filter(
        Q(teacher1__id__in=[t.id for t in TeacherData.objects.filter(
            teacher_ID__iexact=[t.teacher_ID for t in Teacher.objects.all()])])))

    class Meta:
        model = Lecture
        fields = ('course', 'lecture_category', 'lecture_title', 'content')

Answer 1

试试这个，

from django.contrib.auth.decorators import permission_required
from .models import Teacher


@permission_required(  # permission class to check 'is_authenticated' and 'is_teacher')
def my_view(request):
    queryset = Teacher.objects.filter(teacher_ID=request.user.teacher_ID)
    if queryset:
    # do something with teacher data ('queryset' holds those data)
    else:
        return HttpResponse("teacher id not found")