MongoDb 4.0 ‘Cursor‘ object has no attribute ‘count_documents‘ for select
'Cursor' object has no attribute 'count_documents'
·
问题描述:
最近将项目部署转移到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
使用描述:
示例
更多推荐
已为社区贡献1条内容
所有评论(0)