Pass parameter in string mongo query in python

Question

I have following query in my database

query = u'collection.aggregate([{ "$match": { "code": { "$in": {__sensors__}} } },{"$project" : {"_id" : 0}},{"$group" : {"_id": "$code", "data": {"$last": "$$ROOT"}}}])'

And I have following arguments, Now I want to pass that argument in the above query.

args = {"__sensors__": ["GP0", "GP1", "GP5", "GP6"]}

I'm trying following but it is giving me an error.

query.format(**args)

above statement giving me this error

---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
<ipython-input-44-7db1aba33ea5> in <module>()
----> 1 a.query.format({"__sensors__": []})

KeyError: u' "$match"'

Can anyone give me the solution for the above problem?

Alireza HI · Accepted Answer · 2019-07-21 15:12:36Z

1

Your problem is because of the { and }. When you use them in format python thinks that maybe that is a variable. So to fix that you need to make it double. Like below:

query = u'collection.aggregate([{{ "$match": {{ "code": {{ "$in": {__sensors__}}} }} }},{{"$project" : {{"_id" : 0}}}},{{"$group" : {{"_id": "$code", "data": {{"$last": "$$ROOT"}}}}}}])'

As you see I didn't double the {__sensors__}. Because your're going to replace it in the query.format(**args) line.

The final result would be like this:

'collection.aggregate([{ "$match": { "code": { "$in": [\'GP0\', \'GP1\', \'GP5\', \'GP6\']} } },{"$project" : {"_id" : 0}},{"$group" : {"_id": "$code", "data": {"$last": "$$ROOT"}}}])'

answered Jul 21, 2019 at 15:12

Alireza HI

1,9331 gold badge14 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Pass parameter in string mongo query in python

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