express-crud-router-sequelize-v6-connector

Sequelize v6 connector to express-crud-router.

1import crud from "express-crud-router";
2import sequelizeV6Crud from "express-crud-router-sequelize-v6-connector";
3
4app.use(crud("/admin/users", sequelizeV6Crud(User)));

Install

npm install express-crud-router-sequelize-v6-router

Search

express-crud-router-sequelize-v6-router exposes a default search helper function sequelizeSearchFields.

Here is an example:

1import crud from "express-crud-router";
2import sequelizeCrud, {
3  sequelizeSearchFields,
4} from "express-crud-router-sequelize-v6-connector";
5
6crud("/admin/users", {
7  ...sequelizeCrud(User),
8  search: sequelizeSearchFields(User, ["address", "zipCode", "city"]),
9});

When searching some stuff, the following records will be returned in this order:

1. records with a searchable field that contains some stuff
2. records that have searchable fields that contain both some and stuff
3. records that have searchable fields that contain one of some or stuff

The search is case insensitive by default (except for search fields of type DataTypes.UUID where exact matches are returned). You can customize the search to make it case sensitive or use a scope:

1import { Op } from "sequelize";
2
3const search = sequelizeSearchFields(
4  User,
5  ["address", "zipCode", "city"],
6  Op.like
7);

Contribute

See https://github.com/lalalilo/express-crud-router#contribute