express-crud-router-sequelize-v6-connector

Sequelize v6 connector to express-crud-router.

import crud from 'express-crud-router'
import sequelizeV6Crud from 'express-crud-router-sequelize-v6-connector'

app.use(crud('/admin/users', sequelizeV6Crud(User)))

Install

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

Search

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

Here is an example:

import crud from 'express-crud-router'
import sequelizeCrud, {
  simpleSequelizeSearch,
} from 'express-crud-router-sequelize-v6-connector'

crud('/admin/users', sequelizeCrud(User), {
  filters: {
    q: simpleSequelizeSearch(User, ['address', 'zipCode', 'city']),
  },
})

When searching some stuff, records with a searchable field that contains some stuff will be returned.

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:

import { Op } from 'sequelize'

const search = simpleSequelizeSearch(
  User,
  ['address', 'zipCode', 'city'],
  Op.like
)

Contribute

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