如何删除记录之间的重复记录

admin

我有一个像这样的MongoDB

{"currency_type":"alchemy", "currency_value": "0.13", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.13", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.14", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.14", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.16", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.16", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.16", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.13", "created_on": "1605975144322"}

这就是查询应该是什么样子

{"currency_type":"alchemy", "currency_value": "0.13", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.14", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.16", "created_on": "1605975144322"}
{"currency_type":"alchemy", "currency_value": "0.13", "created_on": "1605975144322"}

我尝试过这样的操作，但它删除了所有具有相同值的条目。我只想删除行中重复的条目。

DB.objects.aggregate([
            {"$match": {"currency_type": "alchemy"}},     
            {"$group": {
                "_id": {
                    "currency_value": "$currency_value"                
                },
                "created_on": {"$first": "$created_on"},
                "data": {"$first": "$$ROOT"},
                "count": {"$sum": 1}                 
            }},
            {"$sort":{ "created_on" : 1 }}
        ])

你知道我该往哪个方向走吗？谢谢！！

转载请注明出处:http://www.033230.com/article/20230401/2077882.html