alexandrainst / node-red-contrib-postgresql

Node-RED node for PostgreSQL, supporting parameters, split, back-pressure
https://flows.nodered.org/node/node-red-contrib-postgresql
Apache License 2.0
32 stars 13 forks source link

Add support for named parameters #16

Closed Alkarex closed 2 years ago

Alkarex commented 2 years ago

Compatibility with https://flows.nodered.org/node/node-red-contrib-re-postgres https://github.com/elmagopy/node-red-contrib-re2-postgres

Using a rewritten little subset of https://github.com/bwestergard/node-postgres-named (see https://github.com/brianc/node-postgres/issues/268 )

Named parameterized query

As an alternative to numeric parameters, named parameters for parameterized queries can be passed as a parameter array msg.queryParameters:

// In a function, provide parameters for the named parameterized query
msg.queryParameters.id = msg.id;
-- In this node, use a named parameterized query
SELECT * FROM table WHERE id = $id;

Note: named parameters are not natively supported by PostgreSQL, and this library just emulates them, so this is less robust than numeric parameters.