nodejs + sequelize :: include where required false

Question

i have the following hierarchy of objects:

1. user
2. parent (hasOne)
3. children (hasMany)

once i have a user object, im attempting to load the associated parent object along with some of its children. the following works:

user.getParent({
  include: [{
    model: Child
  }]
}).then(function(parent) {
  var children = parent.children;
});

but if i want to selectively load some of the parent's children, like so:

user.getParent({
  include: [{
    model: Child,
    where: { gender: 'FEMALE' }
  }]
}).then(function(parent) {
  var daughters = parent.daughters;
});

if the parent has one or more daughters, the query works and i get the parent data along with all daughters' data. however, if the parent has only sons, the parent object returned is null..

i want that if the parent has no daughters, the parent object should still be resolved with children = null or children = []..

also, if i wanted to simply load a count of children while loading the parent, how can i go about doing that?

thanks

Answer 1

it turned out to be an issue with my own code.. sequelize fails to load a model if a nested include has a where clause that returns no models.. to ensure it doesnt fail completely, you can set a required: false clause along with the where clause.. this makes sequelize return a blank array instead of failing the load completely..

more info at https://github.com/sequelize/sequelize/issues/4019