find and update in sequelize code example

Example 1: sequelize update sql

const Tokens = db.define('tokens', {
    token: {
        type: sequelize.STRING
    }
});
// Update tokens table where id
Tokens.update(
          { token: 'new token' },
          { where: {id: idVar} }
     ).then(tokens => {
          console.log(tokens);
     }).catch(err => console.log('error: ' + err));

Example 2: update data in sequelize

const objectToUpdate = {
title: 'Hello World',
description: 'Hello World'
}

models.Locale.findAll({ where: { title: 'Hello World'}}).then((result) => {
   if(result){
   // Result is array because we have used findAll. We can use findOne as well if you want one row and update that.
        result[0].set(objectToUpdate);
        result[0].save(); // This is a promise
}
})

Example 3: update column with find sequelize

Project.find({ where: { title: 'aProject' } })
  .on('success', function (project) {
    // Check if record exists in db
    if (project) {
      project.update({
        title: 'a very different title now'
      })
      .success(function () {})
    }
  })