How to convert a pymongo cursor Cursor into a dict

Question

I am using pymongo to query for all items in a region  actually it is to query for all venues in a region on a map   I used db command SON    before to search in a spherical region  which can return me a dictionary and in the dictionary there is a key called results which contains the venues  Now I need to search in a square area and I am suggested to use db places find  however  this returns me a pymongo cursor Cursor class and I have no idea how to extract the venue results from it    Does anyone know whether I should convert the cursor into a dict and extract the results out  or use another method to query for items in a square region  BTW  db is pymongo database Database class  The codes are    gt  gt  gt  import pymongo  gt  gt  gt  db   pymongo MongoClient host  PSRC   gt  gt  gt  resp   db places find   loc      within      box     ll lng ll lat    ur lng ur lat        gt  gt  gt  for doc in resp   gt  gt  gt      print doc    I have values of ll lng  ll lat  ur lng and ur lat  use these values but it prints nothing from this codes

User · Answer

The MongoDB find method does not return a single result  but a list of results in the form of a Cursor  This latter is an iterator  so you can go through it with a for loop   For your case  just use the findOne method instead of find  This will returns you a single document as a dictionary

User · Answer

Easy  import pymongo conn   pymongo MongoClient   db   conn test  test is my database col   db spam  Here spam is my collection array   list col find     print array   There you go

User · Answer

to dict   Convert a SON document to a normal Python dictionary instance   This is trickier than just dict      because it needs to be recursive   http   api mongodb org python current api bson son html

User · Answer

I suggest create a list and append dictionary into it   x        cur   db dbname find   for i in cur      x append i  print x    Now x is a list of dictionary  you can manipulate the same in usual python way

User · Answer

Map function is fast way to convert big collection  from time import time   cursor   db collection find    def f x       return x  name    t1   time   blackset   set map f  cursor   print time   - t1

User · Answer

The find method returns a Cursor instance  which allows you to iterate over all matching documents   To get the first document that matches the given criteria you need to use find one  The result of find one is a dictionary   You can always use the list constructor to return a list of all the documents in the collection but bear in mind that this will load all the data in memory and may not be what you want   You should do that if you need to reuse the cursor and have a good reason not to use rewind       Demo using find    gt  gt  gt  import pymongo  gt  gt  gt  conn   pymongo MongoClient    gt  gt  gt  db   conn test  test is my database  gt  gt  gt  col   db spam  Here spam is my collection  gt  gt  gt  cur   col find      gt  gt  gt  cur  lt pymongo cursor Cursor object at 0xb6d447ec gt   gt  gt  gt  for doc in cur          print doc     or do something with the document        a   1    id   ObjectId  54ff30faadd8f30feb90268f     b   2    a   1   c   3    id   ObjectId  54ff32a2add8f30feb902690     b   2      Demo using find one    gt  gt  gt  col find one     a   1    id   ObjectId  54ff30faadd8f30feb90268f     b   2

[python] How to convert a pymongo.cursor.Cursor into a dict?

Examples related to python

Examples related to mongodb

Examples related to dictionary

Examples related to mongodb-query

Examples related to pymongo