How to use express-mysql-session in Typescript projects?

user_6532551 0
Viewed 2292

I'm trying to use express-session and express-mysql-session within a Typescript project. Here's the relevant part of my code:

import * as express from "express";
import * as expressSession from "express-session";
import * as expressMySqlSession from "express-mysql-session";

this.express = express();
const sessionStore = new expressMySqlSession(sessionStoreConfig, this.dbConnection);
const sessionHandler = expressSession({
                ...,
                store: sessionStore
            });
this.express.use(sessionHandler);

It does not compile because the store option is of type expressSession.Store | expressSession.MemoryStore | undefined while sessionStore is of type MySQLStore. What am I doing wrong?

Regards

express-session typescript express mysql
3 Answers

With both express-session, express-mysql-session, and @types/express-mysql-session listed as dependencies:

Current version of the types (from about two years ago) tracks an older version of express-mysql-session, where the default export is the class. Fortunately, there's some backwards-compatibility in the library for this older version, so you can instantiate it directly:

import MySQLSessionStore from "express-mysql-session";

const store = new MySQLSessionStore({...});

And the library will handle importing the express-session dependency for you.

Code never lies!

user_4511160 
import * as express from 'express';
import * as session from 'express-session';
const MySQLStore = require('express-mysql-session')(session);

import pool from './database';
const sessionStore = new MySQLStore({
  schema: {
    tableName: 'mire_sessions',
    columnNames: {
      session_id: 'session_id',
      expires: 'expires',
      data: 'data'
    }
  }
}, pool);

const app = express();
app.use(session({
  secret: 'z',
  resave: false,
  saveUninitialized: true,
  store: sessionStore
}))

This code worked for me. But I don't know why

user_92790030
Related