How to set data on a join table embodying an N:M relationship? about sequelize-fixtures HOT 3 CLOSED

Hi,
I'm afraid sequelize-fixtures does not currently support setting data on a through table for N:M. A pull request is welcome though

from sequelize-fixtures.

I'll consider diving into the code and giving it a go. There seem to be some gotchas I've read about how to load this data even when you're using the pure JS api for sequelize, but it seems basically doable.

Any general guidance on what syntax in the fixtures files would be reasonable to use to trigger this behavior? Is my example above (with the doubly-nested "data") in the territory of reasonable?

from sequelize-fixtures.

I think there's an error in your example, settings m2m entries is done via plural of the related entity. So for a Project instance you'll want to set it's user list by providing a 'users' data property.

For setting extra data on the rel table my first thought is to add a special 'rel_data' property, like so:

{
   'model': 'User',
   'data': { 'name': 'Bob' }
},
{
  'model': 'Project',
  'data': { 
     'name': 'S00per secret',
     'users': [
          {
                'name': 'Bob',
                'rel_data': {
                    'role': 'Manager'
               }
          }
     ]
}

from sequelize-fixtures.