Using Models

Just like using express and the other modules, your models must be required in order to access them in your app.

const db = require('./models')

CRUD with Sequelize (Using our User model)

Create

db.user.create({
    firstName: 'Rome',
    lastName: 'Bell',
    age: 33
}).then(createdUser=>{
    // the create promise returns the
    // new row of data that has been created
    // (otherwise it throws an error)
    console.log(createdUser)
})


const anotherUser = await db.user.create({ firstName: 'Josh', lastName: 'Smith', age: 49000 });

Read One

db.user.findOne({
    where: {firstName: 'Rome'}
}).then(foundUser=>{
    console.log(foundUser)
})

What happens if you include a where clause that doesn't match any rows of data? Try it!

Find or Create

The method findOrCreate can be used to check if a certain element is already existing in the database. If that is the case the method will result in a respective instance. If the element does not yet exist, it will be created with the provided attributes (a combination of where and defaults)

db.user.findOrCreate({
  where: {
    firstName: 'Brian',
    lastName: 'Smith'
  },
  defaults: { age: 88 }
}).then(([user, created])=>{
  console.log(user); // returns info about the user
});

Find All

findAll returns more than one instance, which is useful if you need more than one record. find only returns one record.

db.user.findAll().then(users=>{
  console.log(users);
  // users will be an array of all User instances
});

Update

db.user.update({
    lastName: 'Taco'
  }, {
    where: {
      firstName: 'Brian'
    }
}).then(numRowsChanged=>{
    console.log(numRowsChanged)
});

See this stack overflow for more on what the promise returns.

Delete (destroy)

  db.user.destroy({
    where: { firstName: 'Brian' }
  }).then(numRowsDeleted=>{
      console.log(numRowsDeleted)
    // do something when done deleting
  });

Promises

After a sequelize statement, we can interact with the return of that object using .then.

Finding a user

db.user.findOne({where: {id: 4}})
.then(foundUser=>{
    console.log(foundUser)
})

db.user.findByPk(1).then(foundUser)\=>{
  console.log(foundUser);
  //res.send("myTemplate", {user: foundUser);
});

In a findOrCreate, a callback will return back an array, instead of a single object. The array parameter syntax shown below is the sequelize 5 syntax that mimics the old .spread() operator

db.user.findOrCreate({
  where: { firstName: 'Brian' }
}).then(([user, created]) {
  console.log(user); // returns info about the user
});

Sequelize Promises

The main callback handlers to be used are as follows.

• .then - default promise called when a query is completed.

• .catch - triggered if something goes wrong (an error).

• .finally - triggered after all other callbacks. Can be used for cleanup.

The important thing to remember is that all queries take time and are asynchronous, so you MUST use promises to execute code that needs to happen after the query is completed.