I'm using python's mongoengine to query MongoDB, and have loved it for the most part, but I'm having an issue with an advanced query.
Here's my model
class ContentItem(Document):
account = ReferenceField(Account)
creator = ReferenceField(User)
public = BooleanField(default=False)
last_used = DateTimeField(default=datetime.now)
I would like to make a query for all ContentItem
's that are of a particular account, and are either created by the logged in user or are public. Here's the query I wrote
query = ContentItem.objects.filter( (Q(account=account) & Q(public=True)) | (Q(account=account) & Q(creator=logged_in_user)) ).order_by('-last_used')
or:
query = ContentItem.objects.filter( Q(account=account) & ( Q(public=True) | Q(creator=logged_in_user) ) ).order_by('-last_used')
But these seem to be XOR where if either public
, or the creator
but not both. Is this expected?
Am I overlooking something? Should I do this directly with mongodb instead of mongoengine?
My current workaround is to make two different queries and combine the results, but as the # of Content Items gets larger the result is taking a long time to come back because I need to get all items before I can order them, thereby losing all the benefit of (django) paginated results.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…