sequelize.js deep save model instance

Question

With sequelize, I am trying to update a nested attribute without success:

const Product = sequelize.define('product', {
    title: { type: Sequelize.STRING },
    color: { type: Sequelize.STRING },
});

const User = sequelize.define('user', {
    name: { type: Sequelize.STRING },
});

Product.belongsTo(User);
User.hasMany(Product);

// create some data
await User.create({
    name: 'foo',
    products:[
        { title: 'prod1', color:'blue' },
        { title: 'prod2', color:'red' },
    ]
},
{ include: [ Product ] }
);

// query data
var data = await sequelize.models.user.findOne({
    where: { name:'foo' },
    include: [ Product ]
});

// update data
data.products[0].color = 'green';
await data.save();

// result
var data = await sequelize.models.user.findAll({
    include: [ Product ]
});

Here, the product color is still blue. I wondering what is going wrong

edit1: I need to update from the "root" of my model because data update come from a JSON structure, and data of included models are part of this structure

mcranston18 · Accepted Answer · 2018-02-23 18:43:54Z

4

You need to call update on the instance of the product model:

await data.products[0].update({
  color: 'some other color'
});

As it stands now, you are just changing the value of the object returned by findOne. When you call save, the instance of the model does not know that you changed any values yet.

answered Feb 23, 2018 at 18:43

mcranston18

4,8403 gold badges38 silver badges37 bronze badges

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

2 Comments

Franck Freiburger Over a year ago

I need to update from the "root" of my model because data update come from a JSON structure, and data of included models are part of this structure

mcranston18 Over a year ago

I'm not sure what you mean. In my example, you're updating the product model. Which model are you looking to update?

Collectives™ on Stack Overflow

sequelize.js deep save model instance

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related