OracleDialect

OracleDialect

Oracle database Dialect implementation for sqler

Constructor

new OracleDialect(priv, connConf, track, errorLoggeropt, loggeropt, debugopt)

Constructor

Source:
Parameters:
Name Type Attributes Description
priv typedefs.SQLERPrivateOptions

The private configuration options

connConf OracleConnectionOptions

The individual SQL connection configuration for the given dialect that was passed into the originating Manager

track typedefs.SQLERTrack

Container for sharing data between Dialect instances.

errorLogger function <optional>

A function that takes one or more arguments and logs the results as an error (similar to console.error)

logger function <optional>

A function that takes one or more arguments and logs the results (similar to console.log)

debug Boolean <optional>

A flag that indicates the dialect should be run in debug mode (if supported)

Members

(protected) driver

Source:

state

Source:

Methods

(async) beginTransaction(txId, opts) → {typedefs.SQLERTransaction}

Begins a transaction by opening a connection from the pool

Source:
Parameters:
Name Type Description
txId String

The transaction ID that will be started

opts typedefs.SQLERTransactionOptions

The transaction options passed in via the public API

Returns:
Type:
typedefs.SQLERTransaction

The transaction that was started

(async) close() → {Number}

Closes the Oracle connection pool

Source:
Returns:
Type:
Number

The number of connections closed

(async) exec(sql, opts, frags, meta, errorOptsopt) → {typedefs.SQLERExecResults}

Executes a SQL statement

Source:
Parameters:
Name Type Attributes Description
sql String

the SQL to execute

opts OracleExecOptions

The execution options

frags Array.<String>

the frament keys within the SQL that will be retained

meta typedefs.SQLERExecMeta

The SQL execution metadata

errorOpts typedefs.SQLERExecErrorOptions | Boolean <optional>

The error options to use

Returns:
Type:
typedefs.SQLERExecResults

The execution results

(async, protected) getConnection(pool, optsopt) → {DBDriver.Connection}

Gets a new connection from the pool

Source:
Parameters:
Name Type Attributes Description
pool DBDriver.Pool

The connection pool

opts OracleExecOptions <optional>

The execution options

Returns:
Type:
DBDriver.Connection

The connection (when present)

(async) init(opts) → {Object}

Initializes OracleDialect by creating the connection pool

Source:
Parameters:
Name Type Description
opts typedefs.SQLERInitOptions

The options described by the sqler module

Returns:
Type:
Object

The Oracle connection pool


3.0.0 (2021-08-26)

Full Changelog

Features:

Fixes: