creating and using associations

[bob.l...@halton.ca]

I have a widgets table and an attributes table.  I have the following code

attributes.belongsTo(widgets, {as: 'widgets'}, {foreignKey: 'widgets_id'})
widget.hasMany(attributes, {as: 'attributes'}, {foreignKey: 'widgets_id'})
widget.findAll().then(function(widgets){

how do I now show each widget and its attributes? 

[Mick Hansen]

Prefetching/Includes help you here, (http://sequelize.readthedocs.org/en/latest/docs/models-usage/#eager-loading)

Basically something like:

widget.findAll({
  include: [attributes]
})

--

Mick Hansen

@mhansendev
mhansen.io

[bob.l...@halton.ca]

thank you Mitch. 

once I've done that, i'm not sure how to access widgets[0].attribute[0] or preferably widget['name_of_widget'].attribute['name_of_attribute']

[Mick Hansen]

widgets[0].get('attributes')[0] depending on your naming.
We don't do any kind of pivoting like that, you'll have to do that mapping on your own :)

[bob.l...@halton.ca]

thanks again Mitch,

I have it working now.  if I understand you correctly I have to refer to attributes by their index (the order they are returned) is there any way to return them based on a column 'name'?

[Mick Hansen]

Nope, you'll have to do that sort of mapping on your own :)

[bob.l...@halton.ca]

is there a suggested (standard) way to do this?  do I create a new object and then map to that?  it seems counterintuitive.

[Mick Hansen]

I usually use something like lodash indexBy/groupBy, but i rarely have API's like that.