Python中如何使用MongoDB复合全文本索引进行文本搜索和排序？

pip install pymongo

# 导入pymongo库
import pymongo

# 建立MongoDB连接
client = pymongo.MongoClient("mongodb://localhost:27017/")

# 获取数据库和集合对象
db = client["test_db"]
collection = db["test_collection"]

# 插入测试数据
data = [
  { "title": "皮蛋编程是什么？", "content": "皮蛋编程是一个优秀的技术博客网站。", "timestamp": "2022-01-01 10:00:00" },
  { "title": "pidancode.com是什么？", "content": "pidancode.com是一个专业的编程网站。", "timestamp": "2022-01-02 10:00:00" },
  { "title": "Python全文本索引使用教程", "content": "本文介绍Python如何使用MongoDB复合全文本索引进行文本搜索和排序。", "timestamp": "2022-01-03 10:00:00" }
]
collection.insert_many(data)

# 创建全文本索引
collection.create_index([("title", pymongo.TEXT), ("content", pymongo.TEXT)], name="text_index")

# 文本搜索和排序
results = collection.find({"$text": {"$search": "pidancode.com"}}).sort([("timestamp", pymongo.DESCENDING)])
for result in results:
  print(result)

# 关闭MongoDB连接
client.close()