Query Embedded Document List in MongoEngine

python mongodb mongodb-query mongoengine
Joey Hu picture Joey Hu · Apr 12, 2016 · Viewed 9.4k times · Source

I need query a list with all embedded documents in mongoengine. Here is my schema:

class Variant(EmbeddedDocument):
    name = StringField(required=True)
    value = StringField(required=True)

class Sku(Document):
    variants = ListField(EmbeddedDocumentField(Variant))

I can do it using mongo shell with:

db.sku.find({variants: [{'name': 'xxx', 'value': 'xxx'}]}).pretty()

But I haven't figure out a way to do it in mongoengine. I need the list in the document is exactly the same with the list I put in the query. Any ideas?

Answer

Blakes Seven picture Blakes Seven · Apr 12, 2016

Actually you were doing it "incorrectly" in the shell as well. The format you were using requires an exact match that would "rarely" actually match conditions. It certainly would not should the inner keys of the array be stored in a different order, or most importantly that the array itself actually stored more than one element.

The correct form for the "shell" would be:

db.sku.find({ "variants": { "$elemMatch": { "name": "xxx", "value": "xxx" } } })

By the same token, the "correct" form for MongoEngine is:

Sku.objects(variants__match={ "name": "xxx", "value": "xxx" })

The __match construct here is the same thing as, and actually issues an $elemMatch statement in query to the underlying MongoDB database as a query.

Note that for a "single" element condition the general "double underscore" syntax is just fine:

Sku.objects(variants__name="xxx")

But for "multiple" conditions and/or elements within the array/list, you need $elemMatch as a MongoDB query and therefore __match.

Related questions

mongodb: insert if not exists

Every day, I receive a stock of documents (an update). What I want to do is insert each item that does not already exist. I also want to keep track of the first time I inserted them, and the last …

Read More
Query Mongodb on month, day, year... of a datetime

I'm using mongodb and I store datetime in my database in this way for a date "17-11-2011 18:00" I store: date = datetime.datetime(2011, 11, 17, 18, 0) db.mydatabase.mycollection.insert({"date" : date}) I would like to do a request like that month = 11 db.…

Read More
How to convert a pymongo.cursor.Cursor into a dict?

I am using pymongo to query for all items in a region (actually it is to query for all venues in a region on a map). I used db.command(SON()) before to search in a spherical region, which can …

Read More