Is there a way in pymongo to use a string to execute a query instead of a dictionary? I would like to be able to use exactly the same syntax as on MongoDB shell from python/pymongo. Is that possible?
2 Answers
MongoDB shell is full-featured javascript console/interpreter with some bindings to message with a mongodb server. In contrast PyMongo lacks embedded javascript interpreter or even javascript parser so you could not execute MongoDB shell queries as-is.
Note that mongo shell queries are not json documents as they are able to contain some functions and some object constructors such as {value: 2+2}.
1 Comment
jay_t
Yes, you're right that puts everything into context. Then what I'm looking for is a way to execute javascript code through pymongo. I'll have a look at mjhm's proposal of eval()
The eval() function might be what you're looking for. Note that it executes the JS code on the db server -- NOT in a Mongo shell on some client. Therefore it comes with lots of warnings, and I would strongly advise against using it in a serious production situation. See the Mongo db.eval docs for details and examples.
2 Comments
jay_t
That might indeed be what I'm looking for. I'm going to do some testing and let you know the outcome.
Ross
That wont be efficient - I'd recommend using the idiomatic python that pymongo gives you. It will be more efficient and is native python, which maps closely to the native shell.
def find(s): return mongo.db.col.findOne({"_id": s})