Function getSqlPool

getSqlPool<T>(
    config: ConnectionAttributes,
    sql: Sql,
    options?: ExecuteOptions,
): Promise<T[]>
Uses a connection from a connection pool to run SQL to get values
Type Parameters
- T
Parameters
- config: ConnectionAttributes
  The DBConfig object to get the connection from
- sql: Sql
  The SQL to execute - the result of the sql template tag - Should be a SELECT type for this
- Optionaloptions: ExecuteOptions
  The oracle options for the SQL execution
Returns Promise<T[]>
The response data as an array
- Defined in sqlHelpers.ts:289
getSqlPool<T>(
    config: ConnectionAttributes,
    sql: Sql,
    options: ExecuteOptions,
    cb: (record: T) => void,
): Promise<void>
Uses a connection from a connection pool to run SQL to get values
Type Parameters
- T
Parameters
- config: ConnectionAttributes
  The DBConfig object to get the connection from
- sql: Sql
  The SQL to execute - the result of the sql template tag - Should be a SELECT type for this
- options: ExecuteOptions
  The oracle options for the SQL execution
- cb: (record: T) => void
  A callback method to allow you to take the return from the sql and transform the object. This is in lieu of returning an array of data.
Returns Promise<void>
Nothing if there is a callback
- Defined in sqlHelpers.ts:304
getSqlPool<T>(
    config: ConnectionAttributes,
    sql: string,
    params?: BindParameters,
    options?: ExecuteOptions,
): Promise<T[]>
Uses a connection from a connection pool to run SQL to get values
Type Parameters
- T
Parameters
- config: ConnectionAttributes
  The DBConfig object to get the connection from
- sql: string
  The SQL to execute - Should be a SELECT type for this
- Optionalparams: BindParameters
  The Parameters to pass into the SQL execution
- Optionaloptions: ExecuteOptions
  The oracle options for the SQL execution
Returns Promise<T[]>
The response data as an array
- Defined in sqlHelpers.ts:320
getSqlPool<T>(
    config: ConnectionAttributes,
    sql: string,
    params: BindParameters,
    options: ExecuteOptions,
    cb: (record: T) => void,
): Promise<void>
Uses a connection from a connection pool to run SQL to get values
Type Parameters
- T
Parameters
- config: ConnectionAttributes
  The DBConfig object to get the connection from
- sql: string
  The SQL to execute - Should be a SELECT type for this
- params: BindParameters
  The Parameters to pass into the SQL execution
- options: ExecuteOptions
  The oracle options for the SQL execution
- cb: (record: T) => void
  A callback method to allow you to take the return from the sql and transform the object. This is in lieu of returning an array of data.
Returns Promise<void>
Nothing if there is a callback instead
- Defined in sqlHelpers.ts:337

Function getSqlPool

Type Parameters

Parameters

Returns Promise<T[]>

Type Parameters

Parameters

Returns Promise<void>

Type Parameters

Parameters

Returns Promise<T[]>

Type Parameters

Parameters

Returns Promise<void>

Settings