Nominating Presidential Muppets

npm

npm’s 2019 JavaScript ecosystem survey analysis is now available! Get your copy here »

sequelize-deep-update

1.3.1 • Public • Published

sequelize-deep-update

Update a sequelize instance and its associated records (and their associated records, and so on).

Full disclosure: This is not well battle-tested yet. The function should behave as described; however, it can likely be optimized and may not be suitable for a large-scale production app.

Usage

Suppose you have a poll with two choices, labelled "Choice A" and "Choice B". The following code will:

  1. Update the label of "Choice A" to "ChoiceA2".
  2. Drop Choice B.
  3. Create a new associated choice, labelled "Choice C".
const deepUpdate = require("sequelize-deep-update");
Poll.findById(1, {include: [Choice]})
  .then((poll)=>{
    console.log(poll.title); // "Title A"
    console.log(poll.choices[0].label); // "Choice A"
    console.log(poll.choices[1].label); // "Choice B"
    return deepUpdate(poll, {
      title: 'Title B',
      choices: [{
        label: 'Choice A2'
        id: 1,
      }, {
        label: 'Choice C'
      }]
    });
  })
  .then((poll)=>{
    console.log(poll.title); // "Title B"
    console.log(poll.choices[0].label); // "Choice A2"
    console.log(poll.choices[1].label); // "Choice C"
  })

Limitations

This has not been tested with scopes.

This will almost definitely need to be refactored for Sequelize 4.0!

Testing

To test, run npm run test. The tests expect you to have a local mysql db called test with username root and password root. You can modify this with environment variables DB_NAME, DB_USER, DB_PASS.

Keywords

install

npm i sequelize-deep-update

Downloadsweekly downloads

14

version

1.3.1

license

ISC

homepage

github.com

repository

Gitgithub

last publish

collaborators

  • avatar
Report a vulnerability