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
- Insert query
- Update query
- Select query
- Delete query
- 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
1const jane = await User.create({ firstName: "Jane", lastName: "Doe" });2console.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
1// Change everyone without a last name to "Doe"2await User.update({ lastName: "Doe" }, {3 where: {4 lastName: null5 }6});
Select query
Node sequelize provide findAll()
method to select or retrive records from table.
Node sequelize select query example
1const users = User.findAll({2 attributes: ['first_name', 'last_name'],3 where: {4 id: 25 }6});
Delete query
Node sequelize provide destroy()
method to delete records from table.
Node sequelize delete or destroy query example
1// Delete everyone named "Jane"2await User.destroy({3 where: {4 first_name: "Jane"5 }6});
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.
1const A = sequelize.define('A', /* ... */);2const B = sequelize.define('B', /* ... */);34A.hasOne(B); // A HasOne B5A.belongsTo(B); // A BelongsTo B6A.hasMany(B); // A HasMany B7A.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
1await User.findAll({2 include: [{3 model: Task,4 required: true,5 }]6});
Left query example
Node sequelize provide include
key to do left join.
Node sequelize left query example
1await User.findAll({2 include: [{3 model: Task // will create a left join4 }]5});
Right query example
Node sequelize provide include
and right
key to do right join.
Node sequelize right query example
1await User.findAll({2 include: [{3 model: Task,4 right: true // will create a right join5 }]6});
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
1await User.findAll({2 include: {3 model: Task,4 required: false5 }6});
Thanks for reading…
Follow me on Twitter
Join our email list and get notified about new content
No worries, I respect your privacy and I will never abuse your email.
Every week, on Tuesday, you will receive a list of free tutorials I made during the week (I write one every day) and news on other training products I create.