Find Document From MongoDB Collection

To find documents (rows) in a MongoDB collection using Python and the "pymongo" library.

We can use the "find()" method. The find() method allows us to query the collection based on specific criteria.

Here's how we can find documents in a MongoDB collection:

MongoDB Configuration:

After importing "pymongo", we must provide a connection URL and database name to MongoClient.

Example:

# import pymongo library
import pymongo

# Connection URL and database name
uri = "mongodb://localhost:27017/"
database_name = "your_database_name"
collection_name = "your_collection_name"

# Connect to MongoDB server
client = pymongo.MongoClient(uri)

# Access the database
db = client[database_name]

# Access the collection
collection = db[collection_name]

Replace "mongodb://localhost:27017/" with the connection string for your MongoDB server.
Replace "your_database_name" with the name of the database where the collection exists or where you want to insert the document.
Replace "your_collection_name" with the name of the collection where you want to insert the document.

Find Single Document:

Example:

# Find document that match a specific query
query = {"_id": ObjectId("document_id_to_find")}

# Print Document if Document exist in Database
result = collection.find(query)

# Iterate over the result set and print each document
for document in result:
    print(document)

The "find()" method is used to query the collection for documents that match the specified query criteria. We pass the query (in the form of a dictionary) as an argument to this method.
The result of the "find()" method is an iterable cursor object that represents the result set. We can iterate over this cursor to access each document individually.

Find Selected Documents:

We can also use various query operators to perform more complex queries, such as matching documents based on multiple criteria, range queries, etc.

Example:

# Find documents where age is greater than 18
query = {"age": {"$gt": 18}}
result = collection.find(query)

# Find documents where name starts with "S"
query = {"name": {"$regex": "^S"}}
result = collection.find(query)

Note: We can customize the query to match your specific requirements.

Find All Documents:

Example:

# Find All documents In Collection

# {} curly indicates no criteria applied, 
# so all documents are eligible to be return from collection
query = {} 
result = collection.find(query)


# print all record from result array, so Iterating over the result variable and print each document
for document in result:
    print(document)

Note: The "{}" object doesn't have any condition/filter, it wouldn't apply to any document, so all documents will get returned from the above query.

<-- Update Document

Delete Document -->