node-postgres-named-function-arguments v1.0.0

node-postgres-named-function-arguments

Named function arguments for node-postgres

Install with npm or Yarn:

# via npm
$ npm install node-postgres-named-function-arguments

# via yarn (automatically saves the package to your `dependencies` in package.json)
$ yarn add node-postgres-named-function-arguments

Usage

import nfa from 'node-postgres-named-function-arguments';
client.query(...nfa('get_user', { _username: 'snorkypie' }));

and

var nfa = require('node-postgres-named-function-arguments');
var sql = nfa('get_user', { _username: 'snorkypie' });
client.query(sql[0], sql[1]);

would be the same as...

client.query('select * from get_user(_username := $1)', [ 'snorkypie' ]);

Rationale

This package solves two major problems with a lot of the solutions out there.

1. Target a specific overloaded function
2. Target specific arguments where default values are used