Assume that there is simple User and Post model.
class User(Document):
user_id = StringField(primary_key=True)
gender = StringField(default='M')
class Post(Document):
user = ReferenceField(User)
body = StringField()
if __name__ == '__main__':
hide = User(user_id='hide', gender='M').save()
john = User(user_id='john', gender='M').save()
test = User(user_id='test', gender='W').save()
admin = User(user_id='admin', gender='W').save()
Post(user=hide, body='hide post').save()
Post(user=john, body='john post').save()
Post(user=test, body='test post').save()
Post(user=admin, body='admin post').save()
hide = User.objects(user_id='hide').first()
posts = Post.objects(user__ne=hide)
for post in posts:
print(post.body)
Result is
john post test post admin post
I triggered condition user__ne=hide, So every posts printed except hide's post.
In this case, How can I add more condition likes, gender='W'?
Below code is result of I tried.
posts = Post.objects(user__ne=hide, user__gender__ne='M')
and
from mongoengine.queryset.visitor import Q
posts = Post.objects(Q(user__ne=hide) & Q(user__gender__ne='M'))
But both code throw errors -> mongoengine.errors.InvalidQueryError: Cannot perform join in mongoDB: user__gender
I know it can be implemented with this.
gender = User.objects(gender__ne='M')
posts = Post.objects(Q(user__ne=hide) & Q(user__nin=gender))
But if users has too many rows, it maybe occur memory issue.
Question
Is it possible to querying with condition at once?
Do .objects() actually querying to database?