Multiple query in pymongo

Question

I have mongoDB with items of following structure:

{
    "some_field": {
        "date": 123,
        "text": "secondary text"
    },
    "text": "primary text"
}

I want to write queries in pymongo that check for text field of top level and apply conditional query at the "date" field of second level. I'm getting filters of the form:

filter = {
    "text": "some target text",
    "date": {
        "start": some_int_val1,
        "end": some_int_val2
    }
}

I can create query to "text" without any problem:

query = dict()
query["text"] = filter["text"]

But I'm stucked about how to construct an $and query on "some_field.date". I tried to simply combine them in one query:

query["somefield.date"] = [{"$gte": filter["common_date"]["start"]}, {"$lte": filter["common_date"]["end"]}]

But it didn't work. Also, I tried what I thought would work, but it throws an error:

query["somefield.date"] = { $and: [{"$gte": filter["date"]["start"]}, {: filter["date"]["end"]}]}

Saying "statement expected, found Py:AND_KEYWORD". How can I overcome this?

thegreenogre · Accepted Answer · 2015-05-06 12:14:30Z

1

This should work

query["somefield.date"] = {"$gte": filter["date"]["start"],"$lte": filter["date"]["end"]}

Your final query should look like :

{
    'somefield.date': {'$gte': some_int_val1, '$lte': some_int_val2}, 
    'text': 'some target text'}
}

edited May 6, 2015 at 12:14

answered May 6, 2015 at 12:09

thegreenogre

1,57911 silver badges22 bronze badges

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

Comments

chridam · Accepted Answer · 2015-05-06 12:16:28Z

In JavaScript, you can create the query object using the bracket-notation like this:

var filter = {
    "text": "some target text",
    "date": {
        "start": 100,
        "end": 150
    }
};

var query = { "some_field": { "date": {} } };
query["text"] = filter["text"];
query["some_field"]["date"]["$gte"] = filter["date"]["start"];
query["some_field"]["date"]["$lte"] = filter["date"]["end"];
console.log(JSON.stringify(query)); // {"some_field":{"date":{"$gte":100,"$lte":150}},"text":"some target text"}

Use the same concept in python to create your query dictionary as follows:

>>> filter = {
...     "text": "some target text",
...     "date": {
...         "start": 100,
...         "end": 150
...     }
... }
>>>
>>> print(filter)
{'date': {'start': 100, 'end': 150}, 'text': 'some target text'}
>>> query = { "some_field": { "date": {} } }
>>> query["text"] = filter["text"]
>>> query["some_field"]["date"]["$gte"] = filter["date"]["start"]
>>> query["some_field"]["date"]["$lte"] = filter["date"]["end"]
>>> print(query)
{'text': 'some target text', 'some_field': {'date': {'$lte': 150, '$gte': 100}}}
>>>

Collectives™ on Stack Overflow

Multiple query in pymongo

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related