Create n:m objects using json and sequelize?

Question

I am trying to learn sequelize, but am having trouble getting a n:m object created. So far I have my 2 models that create 3 tables (Store, Product, StoreProducts) and the models below:

models/Store.js

module.exports = (sequelize, DataTypes) => {
    return Store = sequelize.define('Store', {
        name: {
            type: DataTypes.STRING,
        },
        address: {
            type: DataTypes.STRING,
        }
    });
};

models/Product.js

module.exports = function(sequelize, DataTypes) {
  return Product = sequelize.define('Product', { 
        name: {
            type: DataTypes.STRING,
        }
  });
};

models/Index.js

 models.Store.belongsToMany(models.Products, {through: 'StoreProducts', foreignKey: 'storeId'});
 models.Products.belongsToMany(models.Store, {through: 'StoreProducts', foreignKey: 'productId'});

I want to "add" the following json object.

 var store = {
   name:'corner store',
   address: '123 Main Street',
   products: [
     'string beans', 'coffee', 'milk'
   ]
 };

Looking for any direction, I've tried about 10 routes and the best I was able to get was the Store and Product records created, but nothing relational.

Jan Aagaard Meier · Accepted Answer · 2015-06-23 07:59:56Z

4

Have a look at nested creation (the feature is not documented yet)

Store.create({
  name:'corner store',
  address: '123 Main Street',
  products: [
    { name: 'string beans' }, { name: 'coffee' }, { name: 'milk' }
  ]
}, {
  include: [Product]
});

This will create both stores and products and associate the two.

Note, that this only works for creation - you cannot use it to associate new products with an already existing store etc.

Store.find().then(function (store) {
  store.createProduct({ name: 'hats' });
});

answered Jun 23, 2015 at 7:59

Jan Aagaard Meier

28.9k8 gold badges99 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dan Rocha Over a year ago

doesn't products needs to be Products ?

Jan Aagaard Meier Over a year ago

In this case yes - I'm just used to naming my models lower-cased :)

Dave Over a year ago

Thanks for the reply, going to give it a try.

Collectives™ on Stack Overflow

Create n:m objects using json and sequelize?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related