Sequelize Datatable

Server-side datatables with Sequelize (works with Sequelize 3 and 4). This package was originally forked from sequelize-datatables.

Support

• Node.js v4 & later
• Sequelize v3 & later

Instalation

npm install sequelize-datatable

API

datatable(
  model: SequelizeModel required,
  config: Object required,
  params: Object,
  options: Object
) -> Promise<Object>

This function takes three arguments to produce output for datatables.

• model - required - is the sequelize model.
• config - required - is config sent by jQuery datatables to our server.
• params - options for sequelize query.
• options - library specific options. See below

Options

• caseInsensitive: Boolean - A flag for postgresql dialec. If this is set to true, ILIKE will be used instead of LIKE Default to false.

Example Usage

const datatable = require(`sequelize-datatable`);
const model = require(`./path/to/sequelize-model`); // Sequelize model

// assuming you are using express

route.get(`/datasource`, (req, res) => {
  datatable(model, req.query, {})
    .then((result) => {
      // result is response for datatables
      res.json(result);
    });
});

Todo

• [X] Test with postgresql database
• [X] Test with mysql database
• [X] Support global search
• [X] Support nested relation search & ordering
• [ ] Test with another database server (mssql, sqlite)
• [ ] Support individual column search
• [ ] More tests!

Testing

You must have docker installed on your system if you want to test this module on your machine.

git clone https://github.com/husnulhamidiah/sequelize-datatable.git
cd sequelize-datatable-node
npm install

# It's recommended to test this library using dockerized database engine
DIALECT=mysql npm run test:setup

# or

DIALECT=postgres npm run test:setup

# on another terminal, enter command
DIALECT=postgres npm test

# or

DIALECT=mysql npm test