Dynamically building queries in pymongo

Question

I have a web page where users can see data from MongoDB on a map. I want to have several check boxes, radio buttons, etc to filter what is seen on the map. If I was using MySQL I would do

query = "SELECT * FROM table WHERE x = 1" 
if checkbox == "checked":
  query += "AND WHERE y = 2"

How can I replicate that with pymongo?

Trevor · Accepted Answer · 2012-06-29 22:35:00Z

6

You simply build up the query dict instead:

query = {'x': 1}
if checkbox == 'checked':
    query['y'] = 2

results = db.collection.find(query)

Doing an OR query would look like this:

query = [{'x': 1}]
if checkbox == 'checked':
    query.append({'y': 2})

results = db.collection.find({'$or': query})

edited Jun 29, 2012 at 22:35

answered Jun 29, 2012 at 22:26

Trevor

9,6082 gold badges27 silver badges26 bronze badges

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

4 Comments

jdi Over a year ago

And its even cleaner to build a mongo query dynamically than it is to build raw sql text (not talking about an ORM)

user1084826 Over a year ago

That worked like a charm! Now, what if I want to do OR instead of AND?

jdi Over a year ago

@user1084826: You should really read the docs. Its all right there on how to format queries.

Trevor Over a year ago

@user1084826 Again, you've just got to build up the mongo query object. I updated the answer to give you an example.

Collectives™ on Stack Overflow

Dynamically building queries in pymongo

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related