使用Python对mongo数据库中字符串型正负数值比较大小

# Requires pymonGo 3.6.0+
from pymongo import MongoClient
 
client = MongoClient("mongoDB://root:88888888@192.168.124.49:27017")
database = client["test-mongo"]
collection = database["students2"]
 
# Created with Studio 3T, the IDE for MongoDB - https://studio3t.com/
 
# 查询字符串型正负数值大于 -5.5 的文档
docs = collection.find({
    "$expr": {
        "$gte": [
            {"$toDouble": "$point"},  # 将字符串字段 "point" 转换为数值型
            -5.5  # 比较值，可以根据需求调整
        ]
    }
})
 
try:
    for doc in docs:
        print(doc)
finally:
    client.close()