codeceptjs-postgresqlhelper

CodeceptJS helper to execute queries on PostgreSQL database

Installation

1npm i codeceptjs-postgresqlhelper

Configuration

This helper should be configured in codecept.conf.js

Example:

1{
2  //...
3   helpers: {
4     PostgresqlDBHelper: {
5          require: 'codeceptjs-postgresqlhelper',
6           host: '127.0.0.1', 
7           port: 5432,
8           user: 'postgres',
9           password: 'postgres',
10           database: 'postgres',
11        },
12  //...
13}

To use this helper you need to provide the following info:

• host: hostname or IP address of the PostgreSQL instance
• port: port
• user: username
• password: password
• database: database to which you want to connect