How to perform a $and search with Python and MongoDB

Question

Let's say I have a list of keywords and I want to match against MongoDB documents in which they all appear in the keys field (that is, a AND clause).

How can I do that in Python?

I've tried:

keywords = ['a', 'b', 'c']
keywords_dict = {'keys' : keywords}
results = collection.find(keywords_dict)

But it seems to return no result.

I'm using Python3.5 with PyMongo.

Any hints?

I've figured it out: I need to make a list of dictionaries, e.g. { '$and' : [ {'keys' : key1} , {'keys' : key2} ] } - any hints on other ways to do this is welcome! — Laurent
– Laurent, Commented Nov 11, 2015 at 18:37

chridam · Accepted Answer · 2015-11-11 18:44:50Z

1

You can use the $all operator which is also equivalent to an $and operation of the specified values; i.e. the following statement:

{ 'keys': { '$all': ['a', 'b', 'c'] } }

is equivalent to:

{ '$and': [ { 'key': a }, { 'key': b }, { 'key': c} ] }

answered Nov 11, 2015 at 18:44

chridam

104k26 gold badges246 silver badges243 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to perform a $and search with Python and MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related