example-mjs.mjs

import express from "express";
import session from "express-session";
import { ConnectSessionKnexStore } from "../dist/index.js";
// import { ConnectSessionKnexStore } from "connect-session-knex";
import knexConstructor from "knex";

const app = express(); // Express 4
const store = new ConnectSessionKnexStore({
  knex: knexConstructor({
    client: "sqlite",
    // connection: ":memory:",
    connection: {
      filename: "connect-session-knex.sqlite",
    },
  }),
  cleanupInterval: 0, // disable session cleanup
});

app.use(
  session({
    secret: "keyboard cat",
    cookie: {
      maxAge: 30000, // 30 seconds for testing
    },
    store,
    resave: false,
    saveUninitialized: false,
  }),
);

app.use("/", (req, res) => {
  const n = req.session.views || 0;
  req.session.views = n + 1;
  res.end(`${n} views`);
});

app.listen(3000);

setInterval(() => {
  store.length().then((length) => {
    console.log(`There are ${JSON.stringify(length)} sessions`);
  });
}, 2000);

setInterval(() => {
  store.clear().then((length) => {
    console.log(`Cleared ${JSON.stringify(length)} sessions`);
  });
}, 30000);