populate mongoose key as part of object

Asked Apr 03 '17 at 19:53

Active Apr 30 '17 at 01:14

Viewed 984 times

It's easier to explain in code than English. The following code works, but it feels like there's gotta be an easier, more MongoDBy/mongoosy way ...

// recipeModel.js, relevant part of the schema
equipments: [{
  _id: {
    type: Schema.Types.ObjectId,
    ref: 'equipments',
  },
  quantity: {
    type: Number,
    required: true,
  },
}],

// recipeController.js
const equipmentsWorkaround = recipe => Object.assign({}, recipe.toObject(), {
  equipments: recipe.toObject().equipments.map(equip => ({
    quantity: equip.quantity,
    name: equip._id.name,
    _id: equip._id._id,
  })),
})

const getItem = (req, res, next) => {
  Recipes.findById(req.params.id)
    .populate('equipments._id')
    .then(equipmentsWorkaround) // <--- ugh ...
    .then(recipe => res.json(recipe))
    .catch(next)
}

I know how to do a "conventional" ref in mongoose, but is what I'm after here even possible in mongo?

desired outcome:

equipments: [
  {
    quantity: 1,
    name: "Pan",
    _id: 'some mongo object here...'
  },
  {
    quantity: 3,
    name: "Big Knife",
    _id: 'some mongo object here...'
  }
]

edited Apr 21 '17 at 01:49

asked Apr 03 '17 at 19:53

Shining Love Star

5,734
5
39
49

1

Are you trying to populate ref of sub document from the same collection ? What is `.populate('equipments._id')` expected to do ? Can you explain a little bit more here ? Why cant you use embedded doc here ? – s7vr Apr 15 '17 at 00:51
Could you post you expected outcome (in JSON)? – Dan Green-Leipciger Apr 16 '17 at 18:44
@DanGreen-Leipciger Added at the end of the question. is that what you meant? – Shining Love Star Apr 17 '17 at 00:54
Could you post what the raw (from mongo, unprocessed by mongoose) `equipments` array looks like – Dan Green-Leipciger Apr 17 '17 at 14:27
Right now, it look self-referencing – Dan Green-Leipciger Apr 17 '17 at 14:28
Not sure if this is what you are after. You can get the desired outcome by changing your `equipments` to embedded `equipments: [{ _id: Schema.Types.ObjectId, name:String, quantity: { type: Number, required: true, }, }]`. Now mongoose should be able to map it when you fetch the recipes. Populate is not applicable here. – s7vr Apr 19 '17 at 00:30
@Veeram tried it with and without Populating, didn't work – Shining Love Star Apr 20 '17 at 02:58
@Veeramthe I've added the expected result to the question's body. `equipments` is a standalone model, with it's own `CRUD` methods. – Shining Love Star Apr 20 '17 at 03:11
1

Can you provide a minimally reproducible set up ? – s7vr Apr 20 '17 at 14:06
@Veeram Added to the top of the body, thanks :) – Shining Love Star Apr 21 '17 at 01:51
Can you try with the latest 4.9.6 mongoose version ? – s7vr Apr 30 '17 at 07:01

populate mongoose key as part of object

0 Answers0