如何在MongoDB中删除指定数组内的指定对象？

问题描述 #

我的MongoDB集合文档如下：

{
  "_id": {
    "$oid": "63e9e567a71412b168b38172"
  },
  "Love": [
    {
      "key": 1,
      "title": "Love",
      "content": "Q. How many programmers does ittake to change a light bulb? A. None – It’s a hardware problem"
    },
    {
      "key": 2,
      "title": "Love",
      "content": "How to keep a programmer in the shower forever.Show him the shampoo bottle instructions: Lather. Rinse. Repeat."
    }
  ],
  "Happy": [
    {
      "key": 1,
      "title": "HAPPY",
      "content": "Q. Why did the programmer quit his job? A. Because he didn't get arrays."
    },
    {
      "key": 2,
      "title": "HAPPY",
      "content": "What's the difference between hardware and software? You can hit your hardware with a hammer, but you can only curse at your software."
    }
  ],
  "Dull": [
    {
      "key": 1,
      "title": "DULL",
      "content": "Job trails from HCL"
    },
    {
      "key": 2,
      "title": "DULL",
      "content": "Job trails from NOWhere"
    }
  ],
  "Angry": [
    {
      "key": 1,
      "title": "ANGRY",
      "content": "Q. How many programmers doesit take to change a light bulb? A. None – It’s a hardware problem"
    },
    {
      "key": 2,
      "title": "ANGRY",
      "content": "Job trails from NOWhere"
    }
  ]
}

我需要根据用户传入的分类值（如Love、Dull、Angry或Happy）和要删除的对象的key值，移除对应分类数组中的目标对象。比如当传入分类为Love、key为1时，期望得到的文档如下：

{
  "_id": {
    "$oid": "63e9e567a71412b168b38172"
  },
  "Love": [
    {
      "key": 2,
      "title": "Love",
      "content": "How to keep a programmer in the shower forever.Show him the shampoo bottle instructions: Lather. Rinse. Repeat."
    }
  ],
  "Happy": [
    {
      "key": 1,
      "title": "HAPPY",
      "content": "Q. Why did the programmer quit his job? A. Because he didn't get arrays."
    },
    {
      "key": 2,
      "title": "HAPPY",
      "content": "What's the difference between hardware and software? You can hit your hardware with a hammer, but you can only curse at your software."
    }
  ],
  "Dull": [
    {
      "key": 1,
      "title": "DULL",
      "content": "Job trails from HCL"
    },
    {
      "key": 2,
      "title": "DULL",
      "content": "Job trails from NOWhere"
    }
  ],
  "Angry": [
    {
      "key": 1,
      "title": "ANGRY",
      "content": "Q. How many programmers doesit take to change a light bulb? A. None – It’s a hardware problem"
    },
    {
      "key": 2,
      "title": "ANGRY",
      "content": "Job trails from NOWhere"
    }
  ]
}

我试过多种MongoDB操作都没成功，求解决方法。

解决方案：使用$pull操作符动态更新数组 #

要实现这个需求，核心是用MongoDB的$pull操作符，结合动态字段名来定位目标数组，移除匹配条件的元素。

1. Node.js/Mongoose环境代码示例 #

假设你从请求体中获取到分类名和目标key：

const { category, key: targetKey } = req.body; // 示例值：category="Love"，targetKey=1
const docId = "63e9e567a71412b168b38172";

// 构建更新规则，用计算属性名动态指定操作的数组字段
const updateRule = {
  $pull: {
    [category]: { key: targetKey }
  }
};

// 执行更新操作
await db.collection('你的集合名').updateOne(
  { _id: ObjectId(docId) }, // 根据文档ID定位
  updateRule
);

2. 原生MongoDB Shell命令示例 #

db.你的集合名.updateOne(
  { _id: ObjectId("63e9e567a71412b168b38172") },
  { $pull: { Love: { key: 1 } } }
)

关键说明 #

• $pull操作符：从指定数组中移除所有匹配key: targetKey条件的元素，正好符合需求。
• 动态字段名：利用ES6计算属性名[category]，可以灵活适配不同的分类参数，无需为每个分类写单独的逻辑。
• 批量更新：如果需要修改多个文档，将updateOne替换为updateMany，并调整查询条件即可。

内容的提问来源于stack exchange，提问作者Kunal_Reddy