Security News
JavaScript Leaders Demand Oracle Release the JavaScript Trademark
In an open letter, JavaScript community leaders urge Oracle to give up the JavaScript trademark, arguing that it has been effectively abandoned through nonuse.
connect-typeorm
Advanced tools
A TypeORM-based session store.
Configure TypeORM with back end of your choice:
npm install connect-typeorm express-session typeorm sqlite3
npm install -D @types/express-session
Session
entity:// src/domain/Session/Session.ts
import { ISession } from "connect-typeorm";
import { Column, DeleteDateColumn, Entity, Index, PrimaryColumn } from "typeorm";
@Entity()
export class Session implements ISession {
@Index()
@Column("bigint")
public expiredAt = Date.now();
@PrimaryColumn("varchar", { length: 255 })
public id = "";
@Column("text")
public json = "";
@DeleteDateColumn()
public destroyedAt?: Date;
}
Pass repository to TypeormStore
:
// src/app/Api/Api.ts
import { TypeormStore } from "connect-typeorm";
import { getRepository } from "typeorm";
import * as Express from "express";
import * as ExpressSession from "express-session";
import { Session } from "../../domain/Session/Session";
export class Api {
public sessionRepository = getRepository(Session);
public express = Express().use(
ExpressSession({
resave: false,
saveUninitialized: false,
store: new TypeormStore({
cleanupLimit: 2,
limitSubquery: false, // If using MariaDB.
ttl: 86400
}).connect(this.sessionRepository),
secret: "keyboard cat"
})
);
}
TypeORM uses { "bigNumberStrings": true }
option by default for node-mysql,
you can use a Transformer to fix this issue:
import { Bigint } from "typeorm-static";
@Column("bigint", { transformer: Bigint })
Constructor receives an object. Following properties may be included:
cleanupLimit
For every new session, remove this many expired ones (does not distinguish between users, so User A logging in can delete User B expired sessions). Defaults to 0, in case you need to analyze sessions retrospectively.
limitSubquery
Select and delete expired sessions in one query. Defaults to true, you can set false to make two queries, in case you want cleanupLimit but your MariaDB version doesn't support limit in a subquery.
ttl
Session time to live (expiration) in seconds. Defaults to session.maxAge (if set), or one day. This may also be set to a function of the form (store, sess, sessionID) => number
.
onError
Error handler for database exception. It is a function of the form (store: TypeormStore, error: Error) => void
. If not set, any database error will cause the TypeormStore to be marked as "disconnected", and stop reading/writing to the database, therefore not loading sessions and causing all requests to be considered unauthenticated.
MIT
FAQs
A TypeORM-based session store
The npm package connect-typeorm receives a total of 4,551 weekly downloads. As such, connect-typeorm popularity was classified as popular.
We found that connect-typeorm demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 4 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
In an open letter, JavaScript community leaders urge Oracle to give up the JavaScript trademark, arguing that it has been effectively abandoned through nonuse.
Security News
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
Security News
Floating dependency ranges in npm can introduce instability and security risks into your project by allowing unverified or incompatible versions to be installed automatically, leading to unpredictable behavior and potential conflicts.