# express-request-logging

> Express middleware for logging api request in database.

Latest version **1.0.1** (published 2019-12-17) · MIT license · 0 weekly downloads

## Install

```sh
npm install express-request-logging
pnpm add express-request-logging
yarn add express-request-logging
bun add express-request-logging
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.1 |
| Published | 2019-12-17 |
| First published | 2019-12-17 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 0 |
| Unpacked size | 5.2 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 1 |
| Author | Anish Lushte |
| Maintainers | anishlushte |
| Keywords | access-log, request-log, logging, api, express |

## Links

- npm: https://www.npmjs.com/package/express-request-logging
- Repository: https://github.com/AnishLushte07/request-logger
- Homepage: https://github.com/AnishLushte07/request-logger#readme
- Issues: https://github.com/AnishLushte07/request-logger/issues
- npm.io page: https://npm.io/package/express-request-logging

## Alternatives

- [cli-color](https://npm.io/package/cli-color.md) — 3.4M weekly downloads
- [log](https://npm.io/package/log.md) — 1.3M weekly downloads
- [logstash-client](https://npm.io/package/logstash-client.md) — 4.5K weekly downloads
- [@nocobase/plugin-logger](https://npm.io/package/@nocobase/plugin-logger.md) — 2.0K weekly downloads
- [child-process-debug](https://npm.io/package/child-process-debug.md) — 695 weekly downloads

## Recent versions

- 1.0.1 (latest) — 2019-12-17
- 1.0.0 — 2019-12-17

## README

# NodeJS Request Logger
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`

## Prerequisites
Thins middleware need time taken by request to complete.
- [Response Time](https://www.npmjs.com/package/response-time) npm install --save response-time

MYSQL Table Schema (table name is configurable)

```sql
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;
```

## Installation

This is a [Node.js](https://nodejs.org/en/) module available through the
[npm registry](https://www.npmjs.com/). Installation is done using the
[`npm install` command](https://docs.npmjs.com/getting-started/installing-npm-packages-locally):

```sh
$ npm install express-request-logging
```

## API
```js
const requestLogger = require('express-request-logging')
```

### requestLogger(db, config, callback)

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

### db
Its sequelize database instance in which `access_logs` table is present.

### config
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

Callback will be called in case of any error

## Example

### Default

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

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

### Custom

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

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

```

## License

[MIT](LICENSE)

---
_Source: https://npm.io/package/express-request-logging · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._