Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.npmjs.com/package/mssql-session-store below:

mssql-session-store - npm

Implementation of an express-session store using SQL Server. Uses mssql to connect to the database.

$ npm install mssql-session-store

The store is expecting this table to exist in your database.

create table Session
(
  sessionId nvarchar(450) not null primary key,
  sessionData nvarchar(max) null,
  lastTouchedUtc datetime not null  
)

var session = require('express-session')
var MssqlStore = require('mssql-session-store')(session);

app.use(session({
  secret: 'keyboard cat',
  resave: false,
  saveUninitialized: false,
  store: new MssqlStore(options) // see options below
}));

var options = {
    connection: existingConnection,
    ttl: 3600,
    reapInterval: 3600,
    reapCallback: function() { console.log('expired sessions were removed); }
};

Default value: undefined

Optional instance of a Connection from mssql. If undefined then the global connection will be used.

Default value: 3600

Optional time to live in seconds. Sessions that have not been "touched" in this amount of time will be destroyed. If reapInterval is set to -1 then this setting has no effect.

Default value: 3600

Optional interval to destroy expired sessions in seconds or -1 to never remove expired sessions. Fires once on construction of the MssqlStore object (unless reapInterval is set to -1).

Default value: undefined

Optional callback that is fired after each reaping.

http://jwathen.mit-license.org

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4