python-Python与MongoDB数据库-使用Python执行MongoDB查询（三）

from pymongo import MongoClient

# 连接数据库
client = MongoClient("mongodb://localhost:27017/")
database = client["mydatabase"]
collection = database["mycollection"]

# 插入文档
document = {"name": "John", "age": 30}
collection.insert_one(document)

# 查询文档
document = collection.find_one()
print(document)

# 更新文档
query = {"name": "John"}
new_values = {"$set": {"age": 40}}
collection.update_one(query, new_values)

# 查询更新后的文档
updated_document = collection.find_one({"name": "John"})
print(updated_document)

# 删除文档
query = {"name": "John"}
collection.delete_one(query)

# 查询删除后的文档
deleted_document = collection.find_one({"name": "John"})
print(deleted_document)

# 插入多个文档
documents = [
    {"name": "Mike", "age": 25},
    {"name": "Sarah", "age": 35},
    {"name": "Tom", "age": 45}
]
collection.insert_many(documents)

# 查询年龄大于30的文档并按照名字升序排序
cursor = collection.find({"age": {"$gt": 30}}).sort("name")

# 遍历查询结果
for document in cursor:
    print(document)