query string issue mongodb using python

Question

I have the following python script:

import pdb
import sys
import os
import csv
import pymongo
from pymongo import MongoClient

def main():
    pass

def getWholeCollection(collection_name):
    for property in collection_name.find("{"zip":33801}"):
        print property


if __name__ == '__main__':
    client = MongoClient()
    data_base = client.hkpr_dbw
    properties_collection = data_base.properties

    getWholeCollection(properties_collection)

I keep getting an error around {"zip":33801} which works fine in the mongo shell. I tried """{"zip":33801}""".

I'd like to make the query a variable at some point. How do I use these strings?

that's it. no need for quotes. Thanks! want to put that as the answer? — DBWeinstein
– DBWeinstein, Commented Apr 15, 2015 at 20:32
No worries :-) I think @DanielRoseman answer below suffices. — chridam
– chridam, Commented Apr 15, 2015 at 20:37

Daniel Roseman · Accepted Answer · 2015-04-15 20:32:46Z

4

You don't need to put it in a string. The MongoDB driver will convert the Python dict into the relevant format.

collection_name.find({"zip": 33801})

answered Apr 15, 2015 at 20:32

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

Collectives™ on Stack Overflow

query string issue mongodb using 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