README
socket.io-sequelize
This package provides a simple way to integrate your Sequelize models into your socket.io or engine.io middleware stack, making your models available on the socket object itself.
Installation
Install the package as an application dependency.
npm install socket.io-sequelize --save
This package does not have a direct dependency on Sequelize itself, so you will need to ensure it's included in your package dependencies. The benefit is that you can specify what version of Sequelize to work with.
Usage
Inject the middleware into your stack prior to your route handling logic and any other middleware that depends on your models.
var io = require('socket.io')();
var sequelize = require('socket.io-sequelize');
io.use(sequelize('db', 'user', 'pass', { host: 'localhost' }, 'app/models'));
The the first 4 parameters behave the same as Sequelize's instantiation. It accepts the database name, optional username, optional password, and optional connection options.
The final parameter is specific to the middleware and takes one of two options:
A function that accepts a Sequelize instance and
DataTypes
reference as arguments, e.g.:io.use(sequelize('db', function (db, DataTypes) { db.define( ... ); }));
A string representing the path to a file to be imported via sequelize.import, e.g.:
io.use(sequelize('db', path.resolve(__dirname, 'app/models')));
Wherein your
app/models/index.js
file might look something like:var fs = require('fs'); var path = require('path'); module.exports = function (db, DataTypes) { var files = fs.readdirSync(__dirname).map(function (file) { return path.join(__dirname, file); }).filter(function (file) { return file !== __filename; }); var models = {}; files.forEach(function (file) { var model = db.import(file); models[model.name] = model; }); Object.keys(models).forEach(function (name) { if ('associate' in models[name]) { models[name].associate(db); } }); return models; };
And every other file in the
app/models
folder would take on the structure:module.exports = function (db, DataTypes) { return db.defined( ... ); };
License
socket.io-sequelize is released under the MIT License.