from pymongo import MongoClient

# 创建数据库连接
client = MongoClient('mongodb://localhost:27017/')
# 选择数据库
db = client['mydatabase']
# 选择集合
collection = db['mycollection']
# 插入单个文档
# 要插入的多个文档
docs = [
    {"name": "John", "age": 30, "city": "New York"},
    {"name": "Emma", "age": 28, "city": "London"},
    {"name": "Michael", "age": 35, "city": "Tokyo"}
]
result = collection.insert_many(docs)
print(result.inserted_ids)

# 查询所有文档
for doc in collection.find():
    print(doc)

# 更新单个文档 使用update_one()或update_many()方法来更新文档
query = {"name": "John"}
new_values = {"$set": {"age": 35}}
result = collection.update_one(query, new_values)
print(result.modified_count)

# 删除单个文档 使用delete_one()或delete_many()方法来删除文档。
query = {"name": "John"}
result = collection.delete_one(query)
print(result.deleted_count)

# 使用过滤器查询文档
query = {"city": "London"}
docs = collection.find(query)
for doc in docs:
    print(doc)