python - Django:改进查询集

Question

我目前有以下查询集，我想知道是否有办法将该部分 question.answers.all() 引入到 questions= 查询集中。

def get_questions_and_answers(self):
    questions = (
        self.request.event.surveys.get(template=settings.SURVEY_POST_EVENT)
        .questions.exclude(focus=QuestionFocus.EMAIL)
        .all()
    )

    questions_and_answers = {}
    for question in questions:
        questions_and_answers[question] = question.answers.all()

    return questions_and_answers

models.py

class Question(TimeStampedModel[...]):
    survey = models.ForeignKey(related_name='questions')
    type = models.CharField([...])
    focus = models.CharField([...])

class Answer(TimeStampedModel):
    question = models.ForeignKey(related_name='answers')
    response = models.ForeignKey(related_name='answers')
    answer = models.TextField([...])

class Survey(TimeStampedModel):
    event = models.ForeignKey(related_name='surveys')
    template = models.CharField([...])

Answer 1

是的，您可以喜欢下面的小改动:

questions = (
        self.request.event.surveys.get(template=settings.SURVEY_POST_EVENT)
        .questions.exclude(focus=QuestionFocus.EMAIL)
        .all().prefetch_related('answers')
    )

在这里，对于每个问题，您都会得到答案

有关更多信息，请点击 prefetch_related