Dynamically handling queries with sequelize can be a pain. This package provides you with a function to query your database as you wish
| Method | Type | Return |
|---|---|---|
handleQuery |
function |
object |
In your request body, make a GET request like this:
{
"_query": {
"attributes": [
"id",
"email",
"username",
"birthdate",
"created_at"
],
"order": [
[
"created_at",
"desc"
]
],
"include": ["Post"],
},
"page": 2,
"pageSize": 10
}
-
Use
pageandpageSizetogether topaginate. -
Use
includekeyword to includeassociated models. -
Use
wherekeyword to makewhere clausequery. -
Use
orderkeyword to order items
for more, refer to Sequelize Model Querying - Basics
// imports
const models = require("./models");
const { handleQuery } = require("sequelize-query-handler");
const getAll = async (req, res) => {
try {
await models.User.findAll(handleQuery(req)).then((users) =>
res.send(users)
);
} catch (err) {
console.log(err);
}
};// imports
const models = require("./models");
const { handleQuery } = require("sequelize-query-handler");
const getOne = async (req, res) => {
try {
await models.User.findOne(handleQuery(req)).then((user) => res.send(user));
} catch (err) {
console.log(err);
}
};// imports
const models = require("./models");
const { handleQuery } = require("sequelize-query-handler");
const getById = async (req, res) => {
try {
await models.User.findByPk(1, handleQuery(req)).then((user) =>
res.send(user)
);
} catch (err) {
console.log(err);
}
};// imports
const models = require("./models");
const { handleQuery } = require("sequelize-query-handler");
const { Op } = require("sequelize");
const getById = async (req, res) => {
try {
const filters = handleQuery(req);
// adding where clause to fetch user with age >= 18
filters.where = {
...filters.where,
age: {
[Op.gte]: 18,
},
};
await models.User.findAll(filters).then((user) => res.send(user));
} catch (err) {
console.log(err);
}
};
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent