This module creates a middleware for request logging. This logs request url, status and response time to mysql database using sequelize on response finish event without affecting api performance. Additional properties user_id: req.user.id

This middleware need time taken by request to complete.

• Response Time npm install --save response-time

MYSQL Table Schema (table name is configurable)

CREATE TABLE IF NOT EXISTS `access_logs` (
  `id` int(11) NOT NULL,
  `response_time` decimal(15,4) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `request` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `user_id` int(14) DEFAULT NULL,
  `app_id` tinyint(3) unsigned DEFAULT NULL,
  `created_on` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `access_logs`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `access_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

This is a Node.js module available through the npm registry. Installation is done using the npm install command:

$ npm install express-request-logging

const requestLogger = require('express-request-logging')

Create a middleware that logs request url, status and response time on response finish event.

Its sequelize database instance in which access_logs table is present.

You can override default table name and pass application id.

 {
    appId: number, // this is used if multiple application storing request logs in same database (default: null)
    tableName: string, // mysql table name (default: 'access_logs')
 }

Callback will be called in case of any error

const responseTime = require('response-time')
const requestLogger = require('express-request-logging')

app.use(responseTime())
app.use(requestLogger(sequelizeInstance)

const responseTime = require('response-time')
const requestLogger = require('express-request-logging')

app.use(responseTime())
app.use(requestLogger(sequelizeInstance, { appId: 1 }, (err) => console.log(err))

MIT