Mongoose populate embedded

Question

I use Mongoose.js and cannot solve problem with 3 level hierarchy document.

There 2 ways to do it.

First - without refs.

C = new Schema({
    'title': String,
});

B = new Schema({
    'title': String,
    'c': [C]
});

A = new Schema({
    'title': String,
    'b': [B]
});

I need to show C record. How can i populate / find it, knowing only _id of C?

I was try use:

A.findOne({'b.c._id': req.params.c_id}, function(err, a){
    console.log(a);
});

But i dont know how to get from returnet a object only c object that i need.

Second if working with refs:

C = new Schema({
    'title': String,
});

B = new Schema({
    'title': String,
    'c': [{ type: Schema.Types.ObjectId, ref: 'C' }]
});

A = new Schema({
    'title': String,
    'b': [{ type: Schema.Types.ObjectId, ref: 'B' }]
});

How to populate all B, C records to get hierarchy?

I was try to use something like this:

A
.find({})
.populate('b')
.populate('b.c')
.exec(function(err, a){
    a.forEach(function(single_a){
        console.log('- ' + single_a.title);
        single_a.b.forEach(function(single_b){
            console.log('-- ' + single_b.title);
            single_b.c.forEach(function(single_c){
                console.log('--- ' + single_c.title);
            });
        });
    });
});

But it will return undefined for single_c.title. I there way to populate it?

Thanks.

Would be good to choose a new accepted answer now that this is supported. — JohnnyHK, Jan 28 '15 at 01:56

BoxerBucks · Answer 1 · 2013-08-14T15:18:03.037

44

As of Mongoose 3.6 the ability to recursively populate related documents in a query has been added. Here is an example of how you might do it:

 UserList.findById(listId)
         .populate('refUserListItems')
         .exec(function(err, doc){
             UserListItem.populate(doc.refUserListItems, {path:'refSuggestion'},
                   function(err, data){
                        console.log("User List data: %j", doc);
                        cb(null, doc);
                   }
             );     
          });

In this case, I am populating an array of id's in 'refUserListItems' with their referenced documents. The result of the query then gets passed into another populate query that references the field of the original populated document that I want to also populate - 'refSuggestion'.

Note the second (internal) populate - this is where the magic happens. You can continue to nest these populates and tack on more and more documents until you have built your graph the way you need it.

It takes a little time to digest how this is working, but if you work through it, it makes sense.

edited Aug 14 '13 at 15:18

answered Aug 14 '13 at 15:11

BoxerBucks

3,124
2
21
26

this works, but deep populate given by Buu Nguyen above, is more convenient. No need to do nested loops.. – Cédric NICOLAS Jul 02 '15 at 20:52
How can I do this using promises? – steampowered Aug 14 '15 at 20:13
@steampowered - Which part? You could wrap the whole thing in a function that returns a promise and resolve the promise in the callback to .populate. It looks like .populate also returns a promise so you could capture this promise on either of the .populate functions and then call .then on it when you wanted to run it. – BoxerBucks Aug 17 '15 at 13:48
1

@BoxerBucks I decided to return the promise that `.populate()` returns in a chain of `.then()` functions, and finally run it with the last `.then()`. I think this looks cleaner than nesting n level of populations. http://stackoverflow.com/a/32018947/404699 – steampowered Aug 17 '15 at 15:48
What if I have to find docs and not a single document, should I iterate over each of them to populate the inner path or there is a way to do it on all of them – Harshit Laddha Nov 01 '15 at 19:40
Why don't you need exec the second time @BoxerBucks – Daniel Kobe Apr 11 '16 at 17:08

score 35 · Answer 2 · answered Dec 23 '15 at 22:22

35

in Mongoose 4 you can populate multilevel like this (even in different database or instance)

A
.find({})
.populate({
  path: 'b', 
  model: 'B',
  populate: {
    path: 'c',
    model: 'C'
  }
})
.exec(function(err, a){});

answered Dec 23 '15 at 22:22

James

13,571
6
61
83

10

This should definitely be marked as the correct answer +1 – Doug Molineux Jan 11 '16 at 23:22
A small deviation.. what happens if `B = new Schema({ 'title': String, 'c': [{ type: Schema.Types.ObjectId, ref: 'C' }], 'cc': [{ type: Schema.Types.ObjectId, ref: 'C' }] });` How do I populate both c and cc ? – pravin Aug 18 '16 at 09:42
You can do .populate('c').populate('cc') in chain populate like that. Is that what you want? – James Aug 18 '16 at 17:02
Or even B.populate([{path: 'c'}, {path: 'cc'}]) – James Aug 18 '16 at 17:04

Gianfranco P. · Accepted Answer · 2018-11-22T14:27:08.433

32

In Mongoose 4 you can populate documents across multiple levels:

Say you have a User schema which keeps track of the user's friends.

var userSchema = new Schema({
  name: String,
  friends: [{ type: ObjectId, ref: 'User' }]
});

Firstly populate() lets you get a list of user friends. But what if you also wanted a user's friends of friends? In that case, you can specify a populate option to tell mongoose to populate the friends array of all the user's friends:

User.
  findOne({ name: 'Val' }).
  populate({
    path: 'friends',
    // Get friends of friends - populate the 'friends' array for every friend
    populate: { path: 'friends' }
  });

Taken from: http://mongoosejs.com/docs/populate.html#deep-populate

edited Nov 22 '18 at 14:27

answered Oct 31 '12 at 17:44

Gianfranco P.

10,049
6
51
68

Same answer from aaron from similar question http://stackoverflow.com/q/11137239/728287 – Gianfranco P. Oct 31 '12 at 17:45
2

FYI - this has been resolved in version 3.6 - https://github.com/LearnBoost/mongoose/wiki/3.6-Release-Notes – BoxerBucks Jun 05 '13 at 17:37
@BoxerBucks could you provide an example? (the case with refs) – fusio Aug 13 '13 at 22:51
@fusio - I added an answer as an example of how I did it – BoxerBucks Aug 14 '13 at 15:12
i'll delete my answer as soon as @Oleg2tor accepts the correct answer. – Gianfranco P. Oct 14 '15 at 10:05
1

Not make sense down upvoted this answer because that is invalid right now! @GianPaJ update your answer, not delete. – Marcos Bergamo May 13 '16 at 16:24

score 5 · Answer 4 · answered Dec 10 '14 at 19:44

5

I'm late to this, but I wrote a Mongoose plugin that makes it extremely simple to perform deep model population. For your example, you can do this to populate b and c:

A.find({}, function (err, docs) {
  A.deepPopulate(docs, 'b.c', cb)
}

You can also specify Mongoose populate options for each of the populated paths, like this:

A.deepPopulate(docs, 'b.c', {
  b: { 
    select: 'name'
  }
}, cb)

Check out the plugin documentation for more information.

answered Dec 10 '14 at 19:44

Buu

49,745
5
67
85

This looks really cool. I might use it in production when it becomes more mature. – steampowered Aug 14 '15 at 21:28
Isn't the b: ment to be a c: ? – Matthias Max Feb 24 '16 at 20:19

Mongoose populate embedded

4 Answers4

Linked

Related