mongodb - 使用 findOneAndUpdate() 更新两个不同属性时的 MongoDB 语法

Question

当我想用相同的 findOneAndUpdate() 更新两个单独的属性时，我试图确定正确的 MongoDB 语法。这就是我所拥有的（它只更新第一个属性：

await Agency.findOneAndUpdate(
  {
    historicId: data.id_number
  },
  {
    $set: {
      "authorizations.supervisor": authorizationsSupervisor,
      $push: {
        "authorizations.policy": firstPolicyObj,
        "authorizations.policy": secondPolicyObj,
        "authorizations.policy": thirdPolicyObj
      }
    }
  },
  {
    returnNewDocument: true
  }
);

构造此语法的正确方法是什么？

文档模型如下所示：

{
   _id: <ObjectId>,
   otherProp: <value>,
   authorizations: {
     supervisor: <ObjectId>,
     department: <value>,
     policy: [ 
       {
         category: <value>,
         requirements: [
           {},
           {}
         ]
       }
     ]
   }
}

标签： mongodb

Answer 1

$set: {
         "authorizations.supervisor": authorizationsSupervisor,
      },
$push: { 
        "authorizations.policy": { $each: [ firstPolicyObj, secondPolicyObj, thirdPolicyObj] 
      }