How to update a record using sequelize for node

Question

I m creating a RESTful API with NodeJS  express  express-resource  and Sequelize that is used to manage datasets stored in a MySQL database   I m trying to figure out how to properly update a record using Sequelize   I create a model   module exports   function  sequelize  DataTypes      return sequelize define  Locale         id          type  DataTypes INTEGER        autoIncrement  true        primaryKey  true            locale          type  DataTypes STRING        allowNull  false        unique  true        validate            len  2                    visible          type  DataTypes BOOLEAN        defaultValue  1                Then  in my resource controller  I define an update action   In here I want to be able to update the record where the id matches a req params variable   First I build a model and then I use the updateAttributes method to update the record   const Sequelize   require  sequelize   const   dbconfig     require     config js       Initialize database connection const sequelize   new Sequelize dbconfig database  dbconfig username  dbconfig password      Locale model const Locales   sequelize import   dirname      models Locale       Create schema if necessary Locales sync            PUT  locale  id      exports update   function  req  res      if  req body name        const loc   Locales build        loc updateAttributes         locale  req body name               on  success   id   gt            res json             success  true            200                  on  failure   error   gt            throw new Error error                 else     throw new Error  Data not provided       Now  this does not actually produce an update query as I would expect   Instead  an insert query is executed   INSERT INTO  Locales   id    locale    createdAt    updatedAt    visible   VALUES   1    us    2011-11-16 05 26 09    2011-11-16 05 26 15   1    So my question is  What is the proper way to update a record using Sequelize ORM

User · Answer

January 2020 Answer The thing to understand is that there s an update method for the Model and a separate update method for an Instance  record    Model update   updates ALL matching records and returns an array see Sequelize documentation  Instance update   updates the record and returns an instance object  So to update a single record per the question  the code would look something like this  SequlizeModel findOne  where   id   some-id      then record   gt         if   record        throw new Error  No record found          console log  retrieved record   JSON stringify record null 2         let values         registered   true      email   some email com       name   Joe Blogs           record update values  then  updatedRecord   gt        console log  updated record   JSON stringify updatedRecord null 2            login into your DB and confirm update           catch  error    gt         do seomthing with the error   throw new Error error      So  use Model findOne   or Model findByPkId   to get a handle a single Instance  record  and then use the Instance update

User · Answer

I did it like this  Model findOne       where          condtions            then  j   gt        return j update         field you want to update        then  r   gt          return res status 200  json  msg   succesfully updated            catch e   gt          return res status 400  json  msg   error    e                catch  e   gt        return res status 400  json  msg   error    e

User · Answer

Using async and await in a modern javascript Es6   const title    title goes here   const id   1       try      const result   await Project update              title                where    id                     catch err   gt  console log err      you can return result

User · Answer

If Model update statement does not work for you  you can try like this  try       await sequelize query  update posts set param  param where conditionparam  conditionparam    replacements   param   parameter   conditionparam  condition    type  QueryTypes UPDATE     catch err       console log err

User · Answer

There are two ways you can update the record in sequelize   First  if you have a unique identifier then you can use where clause or else if you want to update multiple records with the same identifier   You can either create the whole object to update or a specific column  const objectToUpdate     title   Hello World   description   Hello World     models Locale update objectToUpdate    where    id  2       Only Update a specific column  models Locale update   title   Hello World      where    id  2      Second  you can use find a query to find it and use set and save function to update the DB    const objectToUpdate     title   Hello World   description   Hello World     models Locale findAll   where    title   Hello World     then  result    gt       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        Always use transaction while updating or creating a new row  that way it will roll back any updates if there is any error or if you doing any multiple updates    models sequelize transaction  tx    gt        models Locale update objectToUpdate    transaction  t  where   id  2

User · Answer

And for people looking for an answer in December 2018  this is the correct syntax using promises   Project update         Values to update               title    a very different title now                  Clause         where                         id  1                   then count   gt        console log  Rows updated     count

User · Answer

I used update method to update my record   models is a  js file where your models place users is model name update is build in function provided by sequelize  I m updating name and city into users table where id equal to 1   models users update              quot name quot   sam    quot city quot   USA             where       id 1

User · Answer

I think using UPDATE     WHERE as explained here and here is a lean approach  Project update          title   a very different title no       set attributes  value              where     id   1       where criteria      then function affectedRows    Project findAll   then function Projects         console log Projects

User · Answer

public static update values  Object  options  Object   Promise   check documentation once http   docs sequelizejs com class lib model js Model html static-method-update    Project update         Set Attribute values        title  a very different title now          Where clause   criteria          id   1            then function result         it returns an array as  affectedCount  affectedRows

User · Answer

Since sequelize v1 7 0 you can now call an update   method on the model  Much cleaner  For Example    Project update        Set Attribute values            title  a very different title now           Where clause   criteria              id   1            success function            console log  Project with id  1 updated successfully          error function err           console log  Project update failed             handle error here

User · Answer

If you re here looking for a way to increment a specific field value in a model     This worked for me as of sequelize 5 21 3  User increment  field    by  1  where   id  1     REF  https   github com sequelize sequelize issues 7268

User · Answer

Since version 2 0 0 you need to wrap your where clause in a where property     Project update      title   a very different title now         where     id  1          success result   gt      handleResult result         error err   gt      handleError err          Update 2016-03-09  The latest version actually doesn t use success and error anymore but instead uses then-able promises   So the upper code will look as follows   Project update      title   a very different title now         where     id  1          then result   gt      handleResult result         catch err   gt      handleError err        Using async await  try     const result   await Project update        title   a very different title now           where     id  1           handleResult result    catch  err      handleError err      http   docs sequelizejs com en latest api model  updatevalues-options-promisearrayaffectedcount-affectedrows

User · Answer

I have not used Sequelize  but after reading its documentation  it s obvious that you are instantiating a new object  that s why Sequelize inserts a new record into the db   First you need to search for that record  fetch it and only after that change its properties and update it  for example   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

User · Answer

hi to update the record it very simple    sequelize find the record by ID  or by what you want   then you pass the params with result feild   updatedField  if the record doesn texist in database sequelize create a new record with the params watch the exemple for more understand Code  1 test that code for all version under V4    const sequelizeModel   require     models sequelizeModel        const id   req params id              sequelizeModel findAll id               then  result   gt                   result name   updatedName                  result lastname   updatedLastname                  result price   updatedPrice                  result tele   updatedTele                  return result save                               then  result   gt                       console log  the data was Updated                                    catch  err   gt                   console log  Error     err                        Code for V5  const id   req params id              const name   req body name              const lastname   req body lastname              const tele   req body tele              const price   req body price      StudentWork update                        name          name              lastname      lastname              tele          tele              price         price                     returning  true  where   id  id                         then  result   gt                   console log  data was Updated                    res redirect                           catch  err   gt           console log  Error     err

User · Answer

This solution is deprecated     failure fail error   is deprecated  and will be removed in 2 1  please   use promise-style instead    so you have to use   Project update          Set Attribute values                title   a very different title now                 Where clause   criteria                 id  1          then function          console log  Project with id  1 updated successfully         catch function e        console log  Project update failed              And you can use  complete   as well   Regards

User · Answer

I have used sequelize js  node js and transaction in below code and added proper error handling if it doesn t find data it will throw error that no data found with that id editLocale  async  req  res    gt         sequelize sequelize transaction async  t1    gt             if   req body id                logger warn error MANDATORY FIELDS               return res status 500  send error MANDATORY FIELDS                      let id   req body id           let checkLocale  await sequelize Locale findOne               where                    id   req body id                                    checkLocale   checkLocale get            if  checkLocale                 let Locale  await sequelize Locale update req body                    where                        id  id                                                let result   error OK              result data   Locale               logger info result               return res status 200  send result                     else               logger warn error DATA NOT FOUND               return res status 404  send error DATA NOT FOUND                    catch function  err            logger error err           return res status 500  send error SERVER ERROR

User · Answer

You can use Model update   method   With async await   try    const result   await Project update        title   Updated Title       what going to be updated       where    id  1       where clause         catch  error         error handling     With  then   catch     Project update        title   Updated Title       what going to be updated       where    id  1       where clause    then result   gt         code with result     catch error   gt         error handling

[mysql] How to update a record using sequelize for node?

Examples related to mysql

Examples related to node.js

Examples related to express

Examples related to sequelize.js