如何替换mongodb中的动态键

一个选项是将$objectToArray与更新管道一起使用:

db.collection.update({},
[
  {$set: {GENUS_DATA: {$objectToArray: "$GENUS_DATA"}}},
  {$project: {GENUS_DATA: {"File-Name": {$first: "$GENUS_DATA.k"},
        "data": {$first: "$GENUS_DATA.v"}}}
  }
],
{multi: true})

查看它在playground example上的工作方式

EDIT:

db.collection.aggregate([
  {$project: {GENUS_DATA: {$objectToArray: "$GENUS_DATA"}}},
  {
    $project: {
      GENUS_DATA: {
        $map: {
          input: "$GENUS_DATA",
          as: "item",
          in: {"File-Name": "$$item.k", met: {$objectToArray: "$$item.v"}}
        }
      }
    }
  },
  {
    $project: {
      GENUS_DATA: {
        $map: {
          input: "$GENUS_DATA",
          as: "file",
          in: {"File-Name": "$$file.File-Name",
            met: {
              $map: {
                input: "$$file.met",
                as: "met",
                in: {"METNO": "$$met.k", data: "$$met.v"}
              }
            }
          }
        }
      }
    }
  }
])

查看它在playground example - generic multi keys上的工作方式