python mongoenqine 查询文档

Question

我正在从 mongodb 查询 2 个集合。我正在查询一个具有名为“quiz_id”字段的集合。我想搜索该字段的值（例如第一个 quiz_id 值是“M7001”）。在第二个集合中，我想从第一个查询中搜索“quiz_id”的值（它是从 0 到 10 的测验的分数），该查询是一个键并返回该值。这是我所拥有的：

quizzes = Topic_maths.objects.order_by('quiz_id')
quiz_chk = User.objects.filter(username=current_user)

for quiz_id in quizzes:
    print (quiz_id.quiz_id)
    key = quiz_id.quiz_id
    if key in quiz_chk:
        print ("score: ", key.quiz_id)
    else:
        print ("no score")

所以第一部分“print (quiz_id.quiz_id)”打印每个测验 ID 号。但我不知道如何搜索为键返回的 mongo 查询集。信息：

print (quiz_id.quiz_id)
<class 'flask_mongoengine.BaseQuerySet'>

任何帮助将不胜感激，谢谢

Answer 1

quiz_chk需要额外的迭代：

[q [q ['quiz_id']对于quiz_chk中的q]，

它会使整个代码看起来像：

from mongoengine import *

connect('test')


class TopicMaths(Document):
    quiz_id = StringField()


class User(Document):
    username = StringField()
    quiz_id = StringField()


current_user = 'Bob'

quizzes = TopicMaths.objects.order_by('quiz_id')
quiz_chk = User.objects.filter(username=current_user)

for quiz_id in quizzes:
    print(quiz_id.quiz_id)
    key = quiz_id.quiz_id
    if key in [q['quiz_id'] for q in quiz_chk]:
        print("score: ", key)
    else:
        print("no score")

输出：输出：

M7001
no score
M7002
score:  M7002
M7003
no score