How to convert a pymongo.cursor.Cursor into a dict?

by

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:

>>> import pymongo
>>> conn = pymongo.MongoClient()
>>> db = conn.test #test is my database
>>> col = db.spam #Here spam is my collection
>>> cur = col.find()  
>>> cur
<pymongo.cursor.Cursor object at 0xb6d447ec>
>>> 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:

>>> col.find_one()
{'a': 1, '_id': ObjectId('54ff30faadd8f30feb90268f'), 'b': 2}

More Related Contents:

  1. Query Mongodb on month, day, year… of a datetime
  2. Append item to MongoDB document array in PyMongo without re-insertion
  3. Append item to MongoDB document array in PyMongo without re-insertion
  4. How to continue insertion after duplicate key error using PyMongo
  5. mongodb: insert if not exists
  6. How to import data from mongodb to pandas?
  7. search by ObjectId in mongodb with pymongo
  8. Insert a Pandas Dataframe into mongodb using PyMongo
  9. How to sort mongodb with pymongo
  10. Authenticate After Picking the Database
  11. Fast or Bulk Upsert in pymongo
  12. How to make a query date in mongodb using pymongo?
  13. How to Ignore Duplicate Key Errors Safely Using insert_many
  14. Getting Spark, Python, and MongoDB to work together
  15. Using .sort with PyMongo
  16. How to run raw mongodb commands from pymongo
  17. ImportError: No module named objectid
  18. open .txt file and place every word within a dictionary [closed]
  19. How does collections.defaultdict work?
  20. TypeError: ObjectId(”) is not JSON serializable
  21. How do I combine two lists into a dictionary in Python? [duplicate]
  22. How to reverse a dictionary that has repeated values
  23. How do I serialize a Python dictionary into a string, and then back to a dictionary?
  24. How to create a dictionary of two pandas DataFrame columns
  25. Collections.defaultdict difference with normal dict
  26. Right way to initialize an OrderedDict using its constructor such that it retains order of initial data?
  27. How to update the value of a key in a dictionary in Python?
  28. How to raise error if duplicates keys in dictionary
  29. How to make a list as the default value for a dictionary? [duplicate]
  30. TypedDict when keys have invalid names

Leave a Comment