MongoDb 4.0 ‘Cursor‘ object has no attribute ‘count_documents‘ for select

问题描述：

最近将项目部署转移到Docker里面进行部署，部署时将MongoDb升级到4.2.6，使用后发现有一条计数的sql出现问题出现以下错误告警：

 'Cursor' object has no attribute 'count_documents' for select

---

---

原因分析：

查询官方文档发现，count()在4.0时已经被弃用

https://pymongo.readthedocs.io/en/stable/common-issues.html?highlight=count()#deprecationwarning-count-is-deprecated

---

解决方案：

PyMongo no longer supports pymongo.cursor.count(). Instead, use pymongo.collection.count_documents()

官方已经给出答案
pymongo.cursor.count()已经弃用，
pymongo.collection.count_documents()代替

client = MongoClient()
d = datetime.datetime(2009, 11, 12, 12)
list(client.db.coll.find({"date": {"$lt": d}}, limit=2))
[{'_id': ObjectId('6247b058cebb8b179b7039f8'), 'date': datetime.datetime(1, 1, 1, 0, 0)}, {'_id': ObjectId('6247b059cebb8b179b7039f9'), 'date': datetime.datetime(1, 1, 1, 0, 0)}]
client.db.coll.count_documents({"date": {"$lt": d}}, limit=2)
2

具体使用细则可以参照手册：

https://pymongo.readthedocs.io/en/stable/api/pymongo/collection.html#pymongo.collection.Collection.count_documents

使用描述：

示例