AliIybar: Created page with "Category:Node.js Category:ORM Category:Database == Model Querying - Finders == === findAll === It generates a standard SELECT query which will retrieve all entrie..."

2021-11-25T12:38:17Z

Created page with "Category:Node.js Category:ORM Category:Database == Model Querying - Finders == === findAll === It generates a standard SELECT query which will retrieve all entrie..."

New page

[[Category:Node.js]]
[[Category:ORM]]
[[Category:Database]]

== Model Querying - Finders ==
=== findAll ===
It generates a standard SELECT query which will retrieve all entries from the table (unless restricted by something like a where clause)
=== findByPk ===
const project = await Project.findByPk(123);
=== findOne ===
const project = await Project.findOne({ where: { title: 'My Title' } });
=== findOrCreate ===
it will return an instance (either the found instance or the created instance) and a boolean indicating whether that instance was created or already existed.
<pre>
const [user, created] = await User.findOrCreate({
where: { username: 'sdepold' },
defaults: {
job: 'Technical Lead JavaScript'
}
});
</pre>
=== findAndCountAll ===
The findAndCountAll method is a convenience method that combines findAll and count. This is useful when dealing with queries related to pagination where you want to retrieve data with a limit and offset but also need to know the total number of records that match the query.

The findAndCountAll method returns an object with two properties:

* count - an integer - the total number records matching the query
* rows - an array of objects - the obtained records
<pre>
const { count, rows } = await Project.findAndCountAll({
where: {
title: {
[Op.like]: 'foo%'
}
},
offset: 10,
limit: 2
});
console.log(count);
console.log(rows);
</pre>

Sequelize Model Querying - Revision history

AliIybar: Created page with "Category:Node.js Category:ORM Category:Database == Model Querying - Finders == === findAll === It generates a standard SELECT query which will retrieve all entrie..."