sails-datatable v0.10.5

sails-datatable

This module is a Waterline/Sails adapter to use with jQuery datatable (tested on 1.10.4). I implement only basic things.

Installation

To install this adapter, run:

$ npm install sails-datatable

Usage

This adapter exposes the following methods:

datatable(params)

• params variable is datatable params

Example of use

After you install follow these steps:

1.Open config/adapters.js and put there:

'sails-datatable': require('sails-datatable');

2.Open config/connections.js and add:

    datatable: {
        adapter: 'sails-datatable'
    },

3.Open model file and add connection:

connection: 'datatable',

4.In controller add datatable action (example below):

datatable: {
	action: function (req, res, next) {
		Model.datatable(req.body, function (err, data) {
			if (err) {
				return next(new error.InvalidContentError(err));
			} else {
				res.send(data);
				next();
			}
		});
	}
}

5.Populate in datatable:

datatable: {
	action: function (req, res, next) {
		req.params.populate = ['item1', 'item2', 'item3'];

		Model.datatable(req.body, function (err, data) {
			if (err) {
				return next(new error.InvalidContentError(err));
			} else {
				res.send(data);
				next();
			}
		});
	}
}

6.Filter in datatable:

datatable: {
	action: function (req, res, next) {
	    // Like where conditions in waterline
		req.params.filter = {
		    param1: 'value1'
		};

		Model.datatable(req.body, function (err, data) {
			if (err) {
				return next(new error.InvalidContentError(err));
			} else {
				res.send(data);
				next();
			}
		});
	}
}

License

MIT © 2014 lukaszpaczos

Sails is free and open-source under the MIT License.