替换 MongoDB 数组中的嵌入文档

发布于 2025-01-03 13:51:55 字数 564 浏览 2 评论 0原文

有没有一种简单的方法来替换数组中的整个嵌入文档？假设将：替换

{
   "_id" : "2",
      "name" : "name2",
      "xyz..." : "xyz2..."
}

为：

{
   "_id" : "2",
      "name" : "name6",
      "xyz..." : "xyz5..."
      "morefields..." : "fields..."
}

搜索 _id（嵌入）。或者我是否需要使用 $set 单独替换每个字段？

{
  "_id" : "2",
  "users" : [{
      "_id" : "1",
      "name" : "name1",
      "xyz..." : "xyz1..."
    }, {
      "_id" : "2",
      "name" : "name2",
      "xyz..." : "xyz2..."
    }],
  "name" : "main name"
}

原文

Is there an easy way to replace an entire embedded document in an array?
Say replacing:

{
   "_id" : "2",
      "name" : "name2",
      "xyz..." : "xyz2..."
}

with:

{
   "_id" : "2",
      "name" : "name6",
      "xyz..." : "xyz5..."
      "morefields..." : "fields..."
}

Searching for _id (embedded). Or do I need to replace each field individually using $set?

{
  "_id" : "2",
  "users" : [{
      "_id" : "1",
      "name" : "name1",
      "xyz..." : "xyz1..."
    }, {
      "_id" : "2",
      "name" : "name2",
      "xyz..." : "xyz2..."
    }],
  "name" : "main name"
}

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

情绪操控生活 2025-01-10 13:51:55

您正在使用“对象数组”模式。您可以使用位置运算符，它应该看起来像这样：

coll.update( {'_id':'2', 'users._id':'2'}, {$set:{'users.
根据我的经验，如果对象具有自然 ID，则“对象数组”模式不是最佳的。在您的情况下，这可以建模如下：
{
  "_id" : "2",
  "users" : 
    { "1" : { "name" : "name1", "xyz..." : "xyz1..." }, 
      "2" : { "name" : "name2", "xyz..." : "xyz2..." }
    }
  "name" : "main name"
}

在这种情况下，您可以使用 点符号轻松更新您想要的项目。
var newValue = {  "name" : "name6", "xyz..." : "xyz5...", "morefields..." : "fields..." };
coll.update({_id: 2}, { $set: { "users.2" : newValue } });

:{ "_id":2,"name":"name6",... }}}, false, true)

根据我的经验，如果对象具有自然 ID，则“对象数组”模式不是最佳的。在您的情况下，这可以建模如下：

在这种情况下，您可以使用点符号轻松更新您想要的项目。

You are using the "array of objects" pattern. You can use the positional operator, it should look something like this:

coll.update( {'_id':'2', 'users._id':'2'}, {$set:{'users.
In my experience, the "array of objects" pattern is not optimal if the objects have a natural ID. In your case, this could be modeled as the following:
{
  "_id" : "2",
  "users" : 
    { "1" : { "name" : "name1", "xyz..." : "xyz1..." }, 
      "2" : { "name" : "name2", "xyz..." : "xyz2..." }
    }
  "name" : "main name"
}

In this case you can use the dot notation to easily update the item you want.
var newValue = {  "name" : "name6", "xyz..." : "xyz5...", "morefields..." : "fields..." };
coll.update({_id: 2}, { $set: { "users.2" : newValue } });

:{ "_id":2,"name":"name6",... }}}, false, true)

In my experience, the "array of objects" pattern is not optimal if the objects have a natural ID. In your case, this could be modeled as the following:

In this case you can use the dot notation to easily update the item you want.

回复收藏 0 原文

~没有更多了~