用Typescript表达mysql会话存储

Question

我试图用Typescript在NestJS中创建mysql会话存储。我已经安装了express-session, express-mysql-session和@types/express-mysql-session包。下面的代码编译(main。Ts文件)，但是在控制台中出现错误:

import { AppModule } from "./app.module";
import { env } from "./common/env";
import session from "express-session";
import MySQLStore from "express-mysql-session";
async function bootstrap() {
const app = await NestFactory.create(AppModule, {
cors: { credentials: env.ENABLE_CORS, origin: env.CLIENT_HOST },
});
//session store
const options = {
host: "db",
port: 3306,
user: env.DB_USER,
password: env.DB_PASSWD,
database: env.DATABASE,
checkExpirationInterval: 1000 * 60 * 60 * 2,
expiration: 1000 * 60 * 60 * 24,
};
const store = MySQLStore(session);
const sessionStore = new store(options);
app.use(
session({
secret: env.COOKIE_SECRET,
store: sessionStore,
resave: false,
saveUninitialized: false,
cookie: {
httpOnly: true,
maxAge: 1000 * 60 * 60 * 24,
},
}),
);
await app.listen(env.PORT_BACKEND || 8080);
}
bootstrap();

误差为图

用require代替import甚至不会编译，我尝试过express-mysql-session包的方式:

var MySQLStore = require('express-mysql-session')(session);

我应该如何使它工作?或者有其他更好的方案?

Answer 1

好的，我让它工作了。最后还安装了mysql2包，你可以在这里阅读为什么。

代码是这样结束的:

import { NestFactory } from "@nestjs/core";
import { env } from "./common/env";
import { AppModule } from "./modules/app/app.module";
import * as session from "express-session";
import * as MySQLStoreCreator from "express-mysql-session";
import * as mysql2 from "mysql2/promise";
async function bootstrap() {
const app = await NestFactory.create(AppModule, {
cors: { credentials: env.ENABLE_CORS, origin: env.CLIENT_HOST },
});
//session store
const options = {
host: "db",
port: 3306,
user: env.DB_USER,
password: env.DB_PASSWD,
database: env.DATABASE,
checkExpirationInterval: 1000 * 60 * 60 * 2,
expiration: 1000 * 60 * 60 * 24,
};
const connection = mysql2.createPool(options);
const sessionStore = new (MySQLStoreCreator(session))({}, connection);
app.use(
session({
secret: env.COOKIE_SECRET,
store: sessionStore,
resave: false,
saveUninitialized: false,
cookie: {
httpOnly: true,
maxAge: 1000 * 60 * 60 * 24,
},
}),
);
await app.listen(env.PORT_BACKEND || 8080);
}
bootstrap();

也许有人会觉得有用C: