MongoDB – 嵌套,将一个集合插入另一个集合中

huangapple go评论61阅读模式
英文:

MongoDB - embedding, inserting one collection into another

问题

如果我有一个集合(例如名为people)看起来像这样:

{
   _id: ObjectID("5e12f6260c190f8ee91b162d"),
   name: "Joe Bookreader",
   address: "Highway To Hell 21"
}

并且我想要删除address的值,并将集合(addresses)嵌入其中:

{
   _id: ObjectID("5e25fg3gjh48ee91b2653"),
   street: "123 Fake Street",
   city: "Faketon",
   state: "MA",
   zip: "12345"
}

使其看起来像这样:

{
   _id: ObjectID("5e12f6260c190f8ee91b162d"),
   name: "Joe Bookreader",
   address: [
                {
                  street: "123 Fake Street",
                  city: "Faketon",
                  state: "MA",
                  zip: "12345"
                }
              ]
}

我该如何做?

是否类似于插入新列,就像下面的代码一样(或者完全不同)?

var bulkInsert = db.people.initializeUnorderedBulkOp()
db.addresses.find().forEach(
    function(doc){
      bulkInsert.insert(doc);
    }
  )

任何帮助都将不胜感激,谢谢!

英文:

If I have a collection (named e.g. people) that looks like

{
   _id: ObjectID("5e12f6260c190f8ee91b162d"),
   name: "Joe Bookreader",
   address: "Highway To Hell 21"
 }

and I want to remove this value for address, and embed the collection (addresses) into it:

               {
                  _id: ObjectID("5e25fg3gjh48ee91b2653"),
                  street: "123 Fake Street",
                  city: "Faketon",
                  state: "MA",
                  zip: "12345"
                }

to look like:

{
   _id: ObjectID("5e12f6260c190f8ee91b162d"),
   name: "Joe Bookreader",
   address: [
                {
                  street: "123 Fake Street",
                  city: "Faketon",
                  state: "MA",
                  zip: "12345"
                }
              ]
 }

How would I do this?

Would it be something similar to inserting the new column, like in the code below (or something completely different)?

 var bulkInsert = db.people.initializeUnorderedBulkOp()
 db.addresses.find().forEach(
    function(doc){
      bulkInsert.insert(doc);
    }
  )

Any help would be appreciated, thanks!

答案1

得分: 2

你可以运行$lookup with empty pipeline,将一个集合嵌入到另一个集合中。

db.people.aggregate([
    {
        $lookup: {
            from: "addresses",
            pipeline: [ ],
            as: "addresses"
        }
    }
])

Mongo Playground

然后,你可以使用$out(完全替换输出集合为聚合结果)或$merge(将聚合结果合并到现有集合中)。

编辑:

你可以添加$match以定位单个文档,而不是整个集合:

db.people.aggregate([
    {
        $lookup: {
            from: "addresses",
            pipeline: [ { $match: { street: "123 Fake Street" } } ],
            as: "addresses"
        }
    }
])
英文:

You can run $lookup with empty pipeline to embed one (entire collection) into another.

db.people.aggregate([
    {
        $lookup: {
            from: "addresses",
            pipeline: [ ],
            as: "addresses"
        }
    }
])

Mongo Playground

Then you can either use $out (replace the output collection entirely with aggregation result) or $merge (incorporates aggregation results into existing collection):

EDIT:

You can add $match to target single document instead of entire collection:

db.people.aggregate([
    {
        $lookup: {
            from: "addresses",
            pipeline: [ { $match: { street: "123 Fake Street" } } ],
            as: "addresses"
        }
    }
])

huangapple
  • 本文由 发表于 2020年1月6日 18:04:03
  • 转载请务必保留本文链接:https://go.coder-hub.com/59610072.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定