README

newman-reporter-sql-postgresql

This package based on tomaszsluszniak/newman-reporter-sql;. It was customized to work with multiple SQL Engines such MySQL, MariaDB, PostgreSQL and Microsoft SQL Server i just added httprequestid for my personal usage.

SQL reporter for Newman that sends the test results information to SQL which can be used in Grafana/PowerBI to build dashboard.

Getting Started

Install newman
Install newman-reporter-sql-postgresql

Prerequisites

node and npm
newman - npm install -g newman
Install the desired SQL engine:

$ npm install --save pg pg-hstore  # PostgreSQL
$ npm install --save mysql2
$ npm install --save mariadb
$ npm install --save tedious  # Microsoft SQL Server

Installation

npm install -g newman-reporter-sql-postgresql

Installation should be done globally if newman is installed globally, otherwise install without -g option.

Usage

Specify -r sql option while running the collection

newman run <collection-url> -r sql-postgresql \
  --reporter-sql-dialect <mysql | mariadb | postgres | mssql> \
  --reporter-sql-server <server-name> \
  --reporter-sql-port <server-port> \
  --reporter-sql-name <database-name> \
  --reporter-sql-table <table-name> \
  --reporter-sql-username <username> \
  --reporter-sql-password <password>

MSSQL Example:

newman run https://www.getpostman.com/collections/631643-f695cab7-6878-eb55-7943-ad88e1ccfd65-JsLv -r sql-postgresql \
  --reporter-sql-dialect mssql \
  --reporter-sql-server localhost \
  --reporter-sql-port 1433 \
  --reporter-sql-name newman_reports \
  --reporter-sql-table api_results \
  --reporter-sql-username sa \
  --reporter-sql-password p@ssw0rd

PostgreSQL Example:

docker run --name postgres -e POSTGRES_PASSWORD=test1234 -p 5432:5432 -d postgres

newman run https://www.postman.com/collections/cb208e7e64056f5294e5 -r sql-postgresql \
  --reporter-sql-dialect postgres \
  --reporter-sql-server localhost \
  --reporter-sql-port 5432 \
  --reporter-sql-name postgres \
  --reporter-sql-table test1234 \
  --reporter-sql-username postgres \
  --reporter-sql-password test1234 \
  --reporter-sql-test-name "test name"

Options:

Option	Remarks
`--reporter-sql-dialect`	SQL Engine. One of: `mysql`, `mariadb`, `postgres`, `mssql`.
`--reporter-sql-server`	IP Address or Host of SQL Server.
`--reporter-sql-port`	Port number. Usually: `3306` for MySQL and MariaDB, `5432` for PostgreSQL, `1433` for Microsoft SQL Server.
`--reporter-sql-name`	Database name. Already existing database.
`--reporter-sql-table`	Table name. Table will be created automatically.
`--reporter-sql-username`	Username created for SQL database (e.g. `sa`).
`--reporter-sql-password`	Password of the user (e.g. `p@ssw0rd`).
`--reporter-sql-debug` (Optional)	Reporter debug mode (default: `false`).
`--reporter-sql-test-name` (Optional)	It can be useful for reporting collected data from a specific test. Example `5 iterations`.

Usage no npm install needed!