pg_tmp for Node

pg_tmp packaged for Node.js.

Installation

npm install --save pg-tmp

Usage

Example usage together with mocha:

const createDatabase = require('pg-tmp')
const { Client } = require('pg')

describe('My app', () => {
  before(() => createDatabase())

  it('should access the datbase', () => {
    const client = new Client()

    return client.query('SELECT 1 AS n').then((result) => {
      console.log(result.rows[0].n)
      //=> 1
    })
  })
})

API

createDatabase([setEnvironment], [opts]) => Promise

Start a temporary database that will be cleaned up automatically after being used. If setEnvironment is either not provided, or set to true, the standard postgresql environmental variables will be set so that you can connect directly without any additional config.

opts is an array of arguments that can be passed to pg_tmp.sh (usage: pg_tmp [-w timeout] [-t] [-o extra-options] [-d datadir]).

For example createDatabase(true, ['-t', '-w', '180']).

Returns a Promise of a object with the following properties:

• host - The host to connect to, will be the path to a UNIX socket
• user - The user to connect as, currently the name of the current user
• password - The password to connect with, currently always an empty string
• database - The database to connect to, currently always "test"