JSPM – telegraf-session-mssql@1.0.0

Package Exports

telegraf-session-mssql

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (telegraf-session-mssql) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

telegraf-session-mssql mssql session middleware for telegraf framework

Install with npm/yarn

npm install telegraf-session-mssql
yarn add telegraf-session-mssql

Create table in your database

CREATE TABLE [dbo].[user_sessions](
    [id] nvarchar(50) NOT NULL,
    [session] nvarchar(max) NULL
)

Example:

const sql = require('mssql');
const session = require('telegraf-session-mssql');

const dotenv = require('dotenv');
dotenv.config();

const { Telegraf } = require('telegraf');
const bot = new Telegraf(process.env.BOT_TOKEN);

const dbConfig = {
  server: process.env.DATABASE_URL,
  database: process.env.DATABASE_NAME,
  user: process.env.DATABASE_USER,
  password: process.env.DATABASE_PASS,
  options: {
    enableArithAbort: true,
  },
};

try {
  sql.connect(dbConfig);
} catch (err) {
  console.error(err.message);
}

const sessionOptions = {
  db: sql,                    // your mssql instance
  table_name: 'user_session', // database table name
}

bot.use(session(sessionOptions));
...

Options object description

key	description	default
db	mssql instance	none
table_name	database table name where session will be stored	'telegraf_session'