如何多次推送到嵌套数组 [英] How to multiple push to nested array

问题描述

我有以下对象:

{
    "_id" : ObjectId("5d7052a3807ab14e286ba5bd"),
    "companyBases" : [
        {
            "vehicles" : [],
            "_id" : ObjectId("5d7052a3807ab14e286ba5b0"),
            "name" : "Tech Parking 3",
            "location" : {
                "lng" : 50.01744,
                "lat" : 20.033522
            },
            "country" : ObjectId("5d7052a2807ab14e286ba578"),
            "__v" : 0
        },
        {
            "vehicles" : [],
            "_id" : ObjectId("5d7052a3807ab14e286ba5af"),
            "name" : "Tech Parking 2",
            "location" : {
                "lng" : 50.036017,
                "lat" : 20.086752
            },
            "country" : ObjectId("5d7052a2807ab14e286ba578"),
            "__v" : 0
        }
    ],
    "nameOfCompany" : "Transport Tech Service 2 ",
    "plan" : {
        "name" : "Enterprise",
        "vehicles" : 56,
        "companyBases" : 10,
        "users" : 10,
        "price" : 1200
    },
    "__v" : 0
}

我尝试过这样做:

 db.companies.update(
        {
          _id: ObjectId("5d7052a3807ab14e286ba5bd")
        },
        {
          $push: {
            "companyBases.$[filter1].vehicles": {
                "name": "Truck 1",
                "combustion": 28
            },
            "companyBases.$[filter2].vehicles": {
                "name": "Truck 2",
                "combustion": 28
            }
          }
        },
        {
            "arrayFilters": [
                {
                    "filter1._id": "5d7052a3807ab14e286ba5b0"
                },
                {
                    "filter2._id": "5d7052a3807ab14e286ba5af"
                }
            ]
        }
      )

但是，它不会更新我的嵌套数组车辆"

But, it doesn't update my nested arrays "vehicles"

它返回我:

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 0 })

我检查了身份证，没关系.几天前我创建了类似的问题，但 $set 管道不是 $push - 如何在一个查询中多次更新而不共享到简单查询?，但我认为可以将该示例重写为 $push.

I checked IDs and it's ok. I've created similar question a few days ago but with $set pipeline not $push - How to update in one query, multiple times without sharing to simple queries? , but i was thinking it's possible to rewrite that example to $push.

推荐答案

问题:在数组过滤器中，_id 匹配的是字符串而不是 ObjectId

以下查询将精确地更新集合:

The following query would precisely update the collection:

db.companies.update(
    {
        _id: ObjectId("5d7052a3807ab14e286ba5bd")
    }, 
    {
        $push: {
            "companyBases.$[filter1].vehicles": {
                "name": "Truck 1",
                "combustion": 28
            },
            "companyBases.$[filter2].vehicles": {
                "name": "Truck 2",
                "combustion": 28
            }
        }
    }, 
    {
        "arrayFilters": [{
                "filter1._id": ObjectId("5d7052a3807ab14e286ba5b0")
            },
            {
                "filter2._id": ObjectId("5d7052a3807ab14e286ba5af")
            }
        ]
    }
)

这篇关于如何多次推送到嵌套数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！