DbClientPg

DbClientPg is a thin wrapper above the native PostgreSQL client designed for using in doix Jobs.

Instances are created by DbPoolPg objects, part of Application. Application developers should never instantiate those objects directly.

Properties

Name	Description
uuid	The unique ID of this client, mainly for logging purposes
raw	The pg.Client instance used by this wrapper
model	a DbModel representing the database structure

Events

Name	Payload	Description
start	{sql, params}	emitted before executing any database query.
error	the error caught	emitted when an error occurs while executing a query
finish		emitted right after the query execution is terminated (one way or another)

Static functions

DbClientPg.normalizeSQL (sql)

Returns the sql string with all comments stripped off and ?s replaced with $1, $2 and so on.

? occurring right after ::jsonb are not replaced (to let use JSONB operators).

Methods

do (sql, params = [])

This asynchronous method executes the given sql with the given params list. Basically it forwards the call to the native client.query returning the same result or throwing the same error.

getScalar (sql, params = [], options = {})

This asynchronous method executes the given sql with the given params list and returns the value of the first (and, normally, the unique) data field of the first record fetched as a corresponding javaScript value (Number, String, Date etc.) For json, jsonb and some other data types the result may be plain Object or Array, but, unlike for getObject and getArray it still means an atomic field value, not a record nor a record set.

For a an empty selection, options.notFound (undefined by default) is returned or thrown (if it is an Error instance).

All records but the first one are discarded. The cursor is closed immediately.

Options

Name	Type	Description
notFound	any	This value is returned or thrown if no record were selected at all.

getObject (sql, params = [], options = {})

This asynchronous method executes the given sql with the given params list and returns the first record fetched as a plain Object or an Array of values.

For a an empty selection, options.notFound ({} by default) is returned or thrown (if it is an Error instance).

All records but the first one are discarded. The cursor is closed immediately.

Options

Name	Type	Description
notFound	any	This value is returned or thrown if no record were selected at all.
rowMode		Same as for getArray, but only have sense for internal use

Name	Description
getObject	Select a single record as an Object
getArray	Select a limited sequence of records as an Array
getStream	Select an unlimited sequence of records as a Readable stream