Constructor
new exports(priv, connConf, track, errorLoggeropt, loggeropt, debugopt)
Constructor
Parameters:
| Name | Type | Attributes | Description |
|---|---|---|---|
priv |
SQLERPrivateOptions
|
The private configuration options |
|
connConf |
PGConnectionOptions
|
The individual SQL connection configuration for the given dialect that was passed into the originating |
|
track |
SQLERTrack
|
Container for sharing data between |
|
errorLogger |
function
|
<optional> |
A function that takes one or more arguments and logs the results as an error (similar to |
logger |
function
|
<optional> |
A function that takes one or more arguments and logs the results (similar to |
debug |
Boolean
|
<optional> |
A flag that indicates the dialect should be run in debug mode (if supported) |
Members
Methods
(async) beginTransaction(txId) → {SQLERTransaction}
Begins a transaction by opening a connection from the pool
Parameters:
| Name | Type | Description |
|---|---|---|
txId |
String
|
The transaction ID that will be started |
Returns:
- Type:
-
SQLERTransaction
The transaction
(async) close() → {Integer}
Closes the PostgreSQL connection pool
Returns:
- Type:
-
Integer
The number of connections closed
(async) exec(sql, opts, frags, meta, errorOptsopt) → {Dialect~ExecResults}
Executes a SQL statement
Parameters:
| Name | Type | Attributes | Description |
|---|---|---|---|
sql |
String
|
the SQL to execute |
|
opts |
PGExecOptions
|
The execution options |
|
frags |
Array.<String>
|
The frament keys within the SQL that will be retained |
|
meta |
SQLERExecMeta
|
The SQL execution metadata |
|
errorOpts |
SQLERExecErrorOptions
|
Boolean
|
<optional> |
The error options to use |
Returns:
- Type:
-
Dialect~ExecResults
The execution results