express-sequelize-session

Express Sequelize session store

Usage

Express 3.x

 
    # load and init express app 
    express = require 'express'
    app = express()
 
    # load and init Sequelize connection 
    Sequelize = require 'sequelize'
    sequelize = new Sequelize 'db.name', 'db.user', 'db.pass'
 
    # load and create session store 
    Store = require('express-sequelize-session') express.session.Store
    app.use express.session
      key: 'sid'
      secret: 'MyAwesomeAppSessionSecret'
      store: new Store sequelize

The Express 3.x sample application shows a complete setup to get started.

Express 4.x

 
    # load and init express app 
    express = require 'express'
    expressSession = require 'express-session'
    app = express()
 
    # load and init Sequelize connection 
    Sequelize = require 'sequelize'
    sequelize = new Sequelize 'db.name', 'db.user', 'db.pass'
 
    # load and create session store 
    Store = require('express-sequelize-session') expressSession.Store
    app.use expressSession
      name: 'sid'
      secret: 'MyAwesomeAppSessionSecret'
      store: new Store sequelize
      resave: false
      saveUninitialized: true

The Express 4.x sample application shows a complete setup to get started.

Custom Schema

use individual table name with optional string column

 
    store = new Store sequelize, 'http_session_table',
      optional:
        type: Sequelize.STRING
        allowNull: true

reference other entities

 
    # define user table 
    User = sequelize.define 'user',
      login:
        type: Sequelize.STRING
        allowNull: false
        unique: true
      password:
        type: Sequelize.STRING
        allowNull: false
 
    # associate session user 
    User.belongsTo store.Session, foreignKeyConstraint: true

Development

build and test it

 
    express-sequelize-session git:(master) ✗ cake
    Cakefile defines the following tasks:
 
    cake build                # build coffee 
    cake coverage             # run coverage 
    cake lint                 # run lint 
    cake spec                 # run specifications