A connect module based on a fork of sequelize-restful. Creates a restful API with associations from your Sequelize models and allows you to include parameters like sort, offset, limit and order. Also allows to filter by date ranges.

It uses the Sequelize function findAndCountAll instead of findAll. Thanks to this, the basic GET request returns the total count of rows in the response. This number doesn’t take account of the query parameters offset and limit. This feature makes easier to do pagination using the generated API.

Usage

var express = require('express')
, Sequelize = require('sequelize')
, http = require('http')
, restful = require('sequelize-restful-extended')
, sequelize = new Sequelize('database', 'username', 'password')
, app = express()

// define all your models before the configure block

app.configure(function() {
app.use(restful(sequelize, { /* options */ }))
})

http.createServer(app).listen(app.get('port'), function(){
console.log("Express server listening on port " + app.get('port'))
})

Options

{
// Parameter: endpoint
// Description: Define the path to the restful API.
// Default: '/api'

endpoint: '/restful',

// Parameter: allowed
// Description: Define which models will be exposed through the restful API
// Default: 'new Array()' if it is an Empty array, all the models will be exposed by default

allowed: new Array('Model0', 'Model1', 'Model2'),

// Parameter: extendedMode
// Description: If it's true, all GET request uses the findAndCountAll function of Sequelize,
// returning the count on the response. If it's false uses the default findAll.
// Default: true

extendedMode: true
}

For more information I recommend you to visit my page on GitHub. You also can download this module from npm.

Good coding!