Connect Session Store using Sequelize
connect-session-sequelize is a SQL session store using Sequelize.js.
Installation
Please note that the most recent version requires express 4. If you use express 3 you should install version 0.0.5 and follow the instructions in the previous README.
$ npm install connect-session-sequelize
Options
db
a successfully connected Sequelize instancetable
(optional) a table/model which has already been imported to your Sequelize instance, this can be used if you want to use a specific table in your dbmodelKey
(optional) a string for the key in sequelize's models-object but it is also the name of the class to which it references (conventionally written in Camelcase) that's why it is "Session" by default if table
is not defined.tableName
(optional) a string for naming the generated table if table
is not defined.
Default is the value of modelKey
.extendDefaultFields
(optional) a way add custom data to table columns. Useful if using a custom model definitiondisableTouch
(optional) When true, the store will not update the db when receiving a touch() call. This can be useful in limiting db writes and introducing more manual control of session updates.
Usage
With connect
const connect = require("connect");
const SequelizeStore = require("connect-session-sequelize")(
connect.session.Store
);
connect().use(
connect.session({
store: new SequelizeStore(options),
secret: "CHANGEME",
})
);
With express 4:
var express = require("express");
var Sequelize = require("sequelize");
var session = require("express-session");
var SequelizeStore = require("connect-session-sequelize")(session.Store);
var sequelize = new Sequelize("database", "username", "password", {
dialect: "sqlite",
storage: "./session.sqlite",
});
var app = express();
app.use(
session({
secret: "keyboard cat",
store: new SequelizeStore({
db: sequelize,
}),
resave: false,
proxy: true,
})
);
If you want SequelizeStore to create/sync the database table for you, you can call sync()
against an instance of SequelizeStore
along with options if needed. This will run a sequelize sync()
operation on the model for an initialized SequelizeStore object :
var myStore = new SequelizeStore({
db: sequelize,
});
app.use(
session({
secret: "keyboard cat",
store: myStore,
resave: false,
proxy: true,
})
);
myStore.sync();
Session expiry
Session records are automatically expired and removed from the database on an interval. The cookie.expires
property is used to set session expiry time. If that property doesn't exist, a default expiry of 24 hours is used. Expired session are removed from the database every 15 minutes by default. That interval as well as the default expiry time can be set as store options:
new SequelizeStore({
...
checkExpirationInterval: 15 * 60 * 1000,
expiration: 24 * 60 * 60 * 1000
});
Expiration interval cleanup: stopExpiringSessions
As expirations are checked on an interval timer, connect-session-sequelize
can keep your process from exiting. This can be problematic e.g. in testing when it is known that the application code will no longer be used, but the test script never terminates. If you know that the process will no longer be used, you can manually clean up the interval by calling the stopExpiringSessions
method:
var myStore = new SequelizeStore({
db: sequelize,
});
after("clean up resources", () => {
myStore.stopExpiringSessions();
});
Add custom field(s) as a column
The extendDefaultFields
can be used to add custom fields to the session table. These fields will be read-only as they will be inserted only when the session is first created as defaults
. Make sure to return an object which contains unmodified data
and expires
properties, or else the module functionality will be broken:
sequelize.define("Session", {
sid: {
type: Sequelize.STRING,
primaryKey: true,
},
userId: Sequelize.STRING,
expires: Sequelize.DATE,
data: Sequelize.TEXT,
});
function extendDefaultFields(defaults, session) {
return {
data: defaults.data,
expires: defaults.expires,
userId: session.userId,
};
}
var store = new SequelizeStore({
db: sequelize,
table: "Session",
extendDefaultFields: extendDefaultFields,
});
Contributing/Reporting Bugs
Try to replicate your issue using mweibel/connect-session-sequelize-example and add that as a link to your issue.
This way it's much simpler to reproduce and help you.
License
MIT