Question

Im writing a mongodb aggregate pipeline. My documents are of the form below :

   {
  name: "01"
  tags {
  tag_01: {
    a: "a01-val",
    b: "b01-val"
  },
  tag_02: {
    a: "a02-val",
    b: "b02-val"
  }
  }
},
{
  name: "02"
  tags {
  tag_03: {
    a: "a03-val",
    b: "b03-val"
  },
  tag_04: {
    a: "a04-val",
    b: "b04-val"
  }
  }
}

我的管道应当产生以下文件:

{
  name: "01"
  tags {
  tag_01: {
    a: "a01-val",
    b: "b01-val",
    tagName: "tag_01"
  },
  tag_02: {
    a: "a02-val",
    b: "b02-val",
    tagName: "tag_02"
  }
  }
},
{
  name: "02"
  tags {
  tag_03: {
    a: "a03-val",
    b: "b03-val",
    tagName: "tag_03"
  },
  tag_04: {
    a: "a04-val",
    b: "b04-val",
    tagName: "tag_04"
  }
  }
}

In other words, a new field is added inside each subdocument whose value is the name of the parent field. Is it possible to do this?

Answer 1

使用<代码>$object ToArray,将tags转换成一系列k-v tuples。使用<条码> 地图,通过阵列元素和<条码>,将现场定位为<条码>k。然后使用<代码>$array ToObject,以重回原物体表格。

db.collection.update({},
[
  {
    "$set": {
      "tags": {
        "$objectToArray": "$tags"
      }
    }
  },
  {
    "$set": {
      "tags": {
        "$map": {
          "input": "$tags",
          "as": "tag",
          "in": {
            k: "$$tag.k",
            v: {
              "$mergeObjects": [
                "$$tag.v",
                {
                  "tagName": "$$tag.k"
                }
              ]
            }
          }
        }
      }
    }
  },
  {
    $set: {
      tags: {
        "$arrayToObject": "$tags"
      }
    }
  }
],
{
  multi: true
})

Mongo 游乐场

友情链接