MongoDB Sort in Python

Sorting in MongoDB allows you to retrieve documents in ascending or descending order based on a specific field. In Python, you can use the sort() method from the pymongo library to sort query results.

1. Install pymongo

Ensure you have the pymongo library installed:

pip install pymongo

2. Connect to MongoDB

Before sorting, establish a connection to MongoDB and select a database and collection.

import pymongo# Connect to MongoDBclient = pymongo.MongoClient("mongodb://localhost:27017/")# Select databasedb = client["mydatabase"]# Select collectioncollection = db["mycollection"]

3. Sorting with sort()

The sort() method sorts documents based on a specified field. The sorting order can be:

• Ascending (pymongo.ASCENDING or 1) ? Smallest to largest.

• Descending (pymongo.DESCENDING or -1) ? Largest to smallest.

a) Sort in Ascending Order

Sort by the age field in ascending order:

documents = collection.find().sort("age", pymongo.ASCENDING)for doc in documents:    print(doc)

You can also use 1 instead of pymongo.ASCENDING:

documents = collection.find().sort("age", 1)

b) Sort in Descending Order

Sort by the age field in descending order:

documents = collection.find().sort("age", pymongo.DESCENDING)for doc in documents:    print(doc)

You can also use -1 instead of pymongo.DESCENDING:

documents = collection.find().sort("age", -1)

4. Sorting Multiple Fields

You can sort by multiple fields by passing a list of tuples to sort().

Example: Sort by Age (Ascending) and Name (Descending)

documents = collection.find().sort([("age", pymongo.ASCENDING), ("name", pymongo.DESCENDING)])for doc in documents:    print(doc)

• First, it sorts age in ascending order.

• If multiple documents have the same age, it sorts name in descending order.

5. Sorting with a Query

You can filter results before sorting them.

query = {"city": "New York"}  # Find only users in New Yorkdocuments = collection.find(query).sort("age", pymongo.ASCENDING)for doc in documents:    print(doc)

6. Sorting with Limit

You can sort and limit the number of documents returned.

documents = collection.find().sort("age", pymongo.DESCENDING).limit(3)for doc in documents:    print(doc)

This retrieves only the top 3 oldest users.

7. Closing the Connection

Always close the MongoDB connection when done.

client.close()

Conclusion

Sorting helps organize data efficiently, making it easier to retrieve the most relevant information! ?