Pymongo, query on list field, and/or

python mongodb pymongo
Skylar Saveland picture Skylar Saveland · Aug 22, 2012 · Viewed 44.1k times · Source

I have a collection with some documents like:

{
    _id: 5,
    vals: [100, 1100, 1500]
},
{
    _id: 10,
    vals: [1100, 1700]
}

How can I query for documents that have, in vals field:

  • 1100
  • 1700 OR 100
  • 100 AND 1100

I can use some comprehension magic like:

g = lambda codes: (
    d for d in collection.find() if any(code in d["vals"] for code in codes)
)
g([100, 1700]).next()

Or, for the AND:

g = lambda codes: (
    d for d in collection.find() if all(code in d["vals"] for code in codes)
)
g([100, 1100]).next()

This seems a little clunky though if there is some find magic that can be done with the driver.

Answer

locojay picture locojay · Aug 22, 2012 
yourmongocoll.find({"vals":1100})
yourmongocoll.find({"$or":[ {"vals":1700}, {"vals":100}]})
yourmongocoll.find({"$and":[ {"vals":100}, {"vals":1100}]})

i would recommend reading Mongodb Advanced queries

you will also find $in ...useful

Related questions

How to sort mongodb with pymongo

I'm trying to use the sort feature when querying my mongoDB, but it is failing. The same query works in the MongoDB console but not here. Code is as follows: import pymongo from pymongo import Connection connection = Connection() db = connection.…

Read More
How to update values using pymongo?

I've a mongodb collection in this form: {id=ObjectId(....),key={dictionary of values}} where dictionary of values is {'a':'1','b':'2'.....} Let dictionary of values be 'd'. I need to update the values of the key in …

Read More
How do I update a Mongo document after inserting it?

Let's say I insert the document. post = { some dictionary } mongo_id = mycollection.insert(post) Now, let's say I want to add a field and update it. How do I do that? This doesn't seem to work..... post = mycollection.find_one({"_…

Read More