Hello Friends,

Welcome To Infinitbility!

This article help you to write query in node with sequelize. here you get examples query of insert, update, select, delete, and join query with code snippest.

Let’s start today topic Node.js sequelize query examples Or how to write query in node sequelize

Table of content

  1. Insert query
  2. Update query
  3. Select query
  4. Delete query
  5. Join or Eager query

Insert query

Node sequelize provide create() method to create new record or row in table also return row id and row details.

Node sequelize insert query example

const jane = await User.create({ firstName: "Jane", lastName: "Doe" });
console.log("Jane's auto-generated ID:", jane.id);

Update query

Node sequelize provide update() method to update details of row or record.

Node sequelize update query example

// Change everyone without a last name to "Doe"
await User.update({ lastName: "Doe" }, {
  where: {
    lastName: null
  }
});

Select query

Node sequelize provide findAll() method to select or retrive records from table.

Node sequelize select query example

const users = User.findAll({
  attributes: ['first_name', 'last_name'],
  where: {
    id: 2
  }
});

Delete query

Node sequelize provide destroy() method to delete records from table.

Node sequelize delete or destroy query example

// Delete everyone named "Jane"
await User.destroy({
  where: {
    first_name: "Jane"
  }
});

Join or Eager query

When you want use join or eager query in node sequelize then first you have to declare relation or association between tables.

Sequelize relation or association

Sequelize provides four types of associations that should be combined to create them:

  • The HasOne association
  • The BelongsTo association
  • The HasMany association
  • The BelongsToMany association

relation or association in node sequelize example.

const A = sequelize.define('A', /* ... */);
const B = sequelize.define('B', /* ... */);

A.hasOne(B); // A HasOne B
A.belongsTo(B); // A BelongsTo B
A.hasMany(B); // A HasMany B
A.belongsToMany(B, { through: 'C' }); // A BelongsToMany B through the junction table C

Inner query example

Node sequelize provide include or required key to do inner join.

Node sequelize inner query example

await User.findAll({
  include: [{
    model: Task,
    required: true,
  }]
});

Left query example

Node sequelize provide include key to do left join.

Node sequelize left query example

await User.findAll({
  include: [{
    model: Task // will create a left join
  }]
});

Right query example

Node sequelize provide include and right key to do right join.

Node sequelize right query example

await User.findAll({
  include: [{
    model: Task,
    right: true // will create a right join
  }]
});

Outer query example

Node sequelize provide include and required key to do outer join. default query is outer join but if mantion required then it’s change to inner join.

Node sequelize outer query example

await User.findAll({
  include: {
    model: Task,
    required: false
  }
});

Thanks for reading…