我有以下 mongodb (3.4.x) 文档，我使用 mgo 驱动程序在 golang 中编码

{
"id": "5981d4c2795a1b4a801ee027",
"scenarioId": "59804b10d8ee910085e33865",
"messages": [
    {
        "id": "5981d4c2795a1b4a801ee028",
        "toQueue": [
            {
                "id": "5981d4c2795a1b4a801ee029",
                "to": {
                    "email": "some@email.com"
                },
                "channel": "EMAIL",
                "toType": "EMAIL",
                "status": {
                    "id": 1,
                    "groupId": 1,
                    "groupName": "PROCESSING",
                    "name": "APPROVED",
                    "description": "MessageChain approved for processing"
                }
            },
            {
                "id": "5981d4c2795a1b4a801ee02a",
                "to": {
                    "phone": "+381631891245"
                },
                "channel": "SMS",
                "toType": "PHONE",
                "status": {
                    "id": 1,
                    "groupId": 1,
                    "groupName": "PROCESSING",
                    "name": "APPROVED",
                    "description": "MessageChain approved for processing"
                }
            }
        ],
        "status": {
            "id": 1,
            "groupId": 1,
            "groupName": "PROCESSING",
            "name": "APPROVED",
            "description": "MessageChain approved for processing"
        }
    },
    {
        "id": "5981d4c2795a1b4a801ee02b",
        "toQueue": [
            {
                "id": "5981d4c2795a1b4a801ee02c",
                "to": {
                    "phone": "+123456789"
                },
                "channel": "SMS",
                "toType": "PHONE",
                "status": {
                    "id": 1,
                    "groupId": 1,
                    "groupName": "PROCESSING",
                    "name": "APPROVED",
                    "description": "MessageChain approved for processing"
                }
            }
        ],
        "status": {
            "id": 1,
            "groupId": 1,
            "groupName": "PROCESSING",
            "name": "APPROVED",
            "description": "MessageChain approved for processing"
        }
    }
],
"messageStages": [
    {
        "id": "5981d4c2795a1b4a801ee033",
        "validityPeriod": 5,
        "validityPeriodTimeUnit": "MINUTES",
        "providerId": 5,
        "email": {
            "text": "this is the email text",
            "subject": "and here the email subject"
        },
        "status": {
            "id": 1,
            "groupId": 1,
            "groupName": "PROCESSING",
            "name": "APPROVED",
            "description": "MessageChain approved for processing"
        }
    }
]

并且我知道 messages.$.toQueue.id 的值，我想在其中更新相关的 toQueue 数组项中的 status.id。

我试过这样做:

query = bson.M{
    "messages.toQueue._id": toQueueId,
}

update = bson.M{
    "$set": bson.M{
        "messages.$.toQueue.$.status.id": status.Id,
        "messages.$.toQueue.$.status.name": status.Name,
        "messages.$.toQueue.$.status.groupId": status.GroupId,
        "messages.$.toQueue.$.status.groupName": status.GroupName,
        "messages.$.toQueue.$.status.description": status.Description,

    },
}
err = cr.Update(query,update)

但是多个$是不允许的。没有它也不可更新。

有没有办法只更新我在查询中找到的子文档？

最佳答案

Neil Lunn 给出了正确的答案。 不可能像我尝试的那样使用嵌套数组。而且他也是对的，这个问题来自设计错误。 所以我按照他和 Markus W Mahlberg 建议将 toQueue 部分移动到一个单独的集合中进行了更改，并以 messageId 作为引用。

关于mongodb - 在 mgo 中更新多个数组中的单个子文档，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/45476354/