Sequelize js delete query

Question

Is there a way to write a delete deleteAll query like findAll   For example I want to do something like this  assuming MyModel is a Sequelize model       MyModel deleteAll   where    some field        something          on  success   function

User · Answer

Here s a ES6 using Await   Async example       async deleteProduct id             if   id                return  msg   No Id specified     payload  1                      try               return   await products destroy                   where                        id  id                                             catch  e                return false                     Please note that I m using the    Bang Bang Operator on the result of the await which will change the result into a Boolean

User · Answer

This example shows how to you promises instead of callback   Model destroy      where          id  123   this will be your id that you want to delete         then function rowDeleted      rowDeleted will return number of rows deleted   if rowDeleted     1        console log  Deleted successfully            function err       console log err          Check this link out for more info http   docs sequelizejs com en latest api model  destroyoptions-promiseinteger

User · Answer

Sequelize methods return promises  and there is no delete   method  Sequelize uses destroy   instead  Example Model destroy     where        some field            any selection operation          for example  Op lte  new Date                then result   gt        some operation    catch error   gt      console log error      Documentation for more details  https   www codota com code javascript functions sequelize Model destroy

User · Answer

I ve searched deep into the code  step by step into the following files   https   github com sdepold sequelize blob master test Model destroy js  https   github com sdepold sequelize blob master lib model js L140  https   github com sdepold sequelize blob master lib query-interface js L207-217  https   github com sdepold sequelize blob master lib connectors mysql query-generator js  What I found   There isn t a deleteAll method  there s a destroy   method you can call on a record  for example   Project find 123  on  success   function project      project destroy   on  success   function u        if  u  amp  amp  u deletedAt             successfully deleted the project

User · Answer

I wrote something like this for Sails a while back  in case it saves you some time   Example usage      Delete the user with id 4 User findAndDelete 4 function error result        all done         Delete all users with type      suspended  User findAndDelete     type   suspended    function error result        all done       Source          Retrieve models which match  where   then delete them     function findAndDelete  where callback            Handle  where  argument which is specified as an integer     if    isFinite  where             where                 id  where                       Model findAll           where where        success function collection            if  collection                if    isArray collection                     Model deleteAll collection  callback                             else                   collection destroy                    success   unprefix callback                    error callback                                   else               callback null collection                    error callback             Delete all  models  using the query chainer     deleteAll  function  models        var chainer   new Sequelize Utils QueryChainer          each models function m index            chainer add m destroy                 return chainer run        from  orm js   Hope that helps

User · Answer

the best way to delete a record is to find it firstly  if exist in data base in the same time you want to delete it  watch this code     const StudentSequelize   require     models studientSequelize    const StudentWork   StudentSequelize Student   const id   req params id      StudentWork findByPk id     here i fetch result by ID sequelize V  5      then  resultToDelete  gt           resultToDelete destroy id      when i find the result i deleted it by destroy function             then  resultAfterDestroy  gt           console log  Deleted    resultAfterDestroy               catch err  gt  console log err

User · Answer

I have used sequelize js  node js and transaction in belowcode and added proper error handling if it doesn t find data it will throw error that no data found with that id deleteMyModel  async  req  res    gt         sequelize sequelize transaction async  t1    gt             if   req body id                return res status 500  send error MANDATORY FIELDS                      let feature   await sequelize MyModel findOne               where                    id  req body id                                   if  feature                let feature   await sequelize MyModel destroy                   where                        id  req body id                                                let result   error OK              result data   MyModel              return res status 200  send result              else               return res status 404  send error DATA NOT FOUND                    catch function  err            return res status 500  send error SERVER ERROR

User · Answer

In new version  you can try something like this  function  req res                model destroy               where                    id  req params id                                   then function  deletedRecord                if deletedRecord     1                   res status 200  json  message  Deleted successfully                                         else                               res status 404  json  message  record not found                                      catch function  error               res status 500  json error

User · Answer

Delete all  no conditions  Model destroy       truncate  true

User · Answer

For anyone using Sequelize version 3 and above  use   Model destroy       where               criteria            Sequelize Documentation - Sequelize Tutorial

User · Answer

Don t know if the question is still relevant but I have found the following on Sequelize s documentation   User destroy   name  LIKE  J     success function            We just deleted all rows that have a name starting with  J       http   sequelizejs com blog state-of-v1-7-0  Hope it helps

[javascript] Sequelize.js delete query?

Examples related to javascript

Examples related to node.js

Examples related to sequelize.js