Prerequisites: MongoDB Python Basics
This article is about converting the PyMongo Cursor to JSON. Functions like find() and find_one() returns the Cursor instance.
- Importing Required Modules: Import the required module using the command:
from pymongo import MongoClient from bson.json_util import dumps
If MongoDB is already not installed on your machine you can refer to the guide: Guide to Install MongoDB with Python
- Creating a Connection: Now we had already imported the module, its time to establish a connection to the MongoDB server, presumably which is running on localhost (host name) at port 27017 (port number).
client = MongoClient(‘localhost’, 27017)
- Accessing the Database: Since the connection to the MongoDB server is established. We can now create or use the existing database.
mydatabase = client.name_of_the_database
- Accessing the Collection: We now select the collection from the database using the following syntax:
collection_name = mydatabase.name_of_collection
- Getting the documents: Getting all the documents from the collection using find() method. It returns the instance of the Cursor.
cursor = collection_name.find()
- Converting the Cursor to JSON: Converting the Cursor to the JSON.
First, we will convert the Cursor to the list of dictionary.
list_cur = list(cursor)
Now, converting the list_cur to the JSON using the method dumps() from bson.json_util
json_data = dumps(list_cur)
You can now save it to the file or can use it in the program using loads() function.
Below is the implementation.
- Convert PyMongo Cursor to Dataframe
- What is a PyMongo Cursor?
- How to check if the PyMongo Cursor is Empty?
- Python - Difference between json.dump() and json.dumps()
- Get the Names of all Collections using PyMongo
- Update all Documents in a Collection using PyMongo
- Difference Between insert(), insertOne(), and insertMany() in Pymongo
- Get all the information of a Collection's indexes using PyMongo
- How to rebuild all the indexes of a collection using PyMongo?
- Nested Queries in PyMongo
- Get all the Documents of the Collection using PyMongo
- How to Drop all the indexes in a Collection using PyMongo?
- Python | Ways to convert string to json object
- Convert JSON to dictionary in Python
- Convert JSON to CSV in Python
- Convert Text file to JSON in Python
- Python - Convert JSON to string
- How To Convert Python Dictionary To JSON?
- How to convert pandas DataFrame into JSON in Python?
- Convert CSV to JSON using Python
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.