Function getSql

getSql<T>(configOrConnection, sql, options?): Promise<T[]>
Runs SQL to get values
Type Parameters
- T
Parameters
- configOrConnection: ConfigOrConnection
  
  Either a dbConfig object or the connection to execute with
- sql: Sql
  
  The SQL to execute - the result of the sql template tag - Should be a SELECT type for this
- Optional options: ExecuteOptions
  
  The oracle options for the SQL execution
Returns Promise<T[]>
The response data as an array
- Defined in lib/sqlHelpers.ts:143
getSql<T>(configOrConnection, sql, options, cb): Promise<void>
Runs SQL to get values
Type Parameters
- T
Parameters
- configOrConnection: ConfigOrConnection
  
  Either a dbConfig object or the connection to execute with
- 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) => 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.
  - - (record): void
    - Parameters
      
      record: T
      
      Returns void
Returns Promise<void>
Nothing if there is a callback
- Defined in lib/sqlHelpers.ts:158
getSql<T>(configOrConnection, sql, params?, options?): Promise<T[]>
Runs SQL to get values
Type Parameters
- T
Parameters
- configOrConnection: ConfigOrConnection
  
  Either a dbConfig object or the connection to execute with
- sql: string
  
  The SQL to execute - Should be a SELECT type for this
- Optional params: BindParameters
  
  The Parameters to pass into the SQL execution
- Optional options: ExecuteOptions
  
  The oracle options for the SQL execution
Returns Promise<T[]>
The response data as an array
- Defined in lib/sqlHelpers.ts:174
getSql<T>(configOrConnection, sql, params, options, cb): Promise<void>
Runs SQL to get values
Type Parameters
- T
Parameters
- configOrConnection: ConfigOrConnection
  
  Either a dbConfig object or the connection to execute with
- 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) => 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.
  - - (record): void
    - Parameters
      
      record: T
      
      Returns void
Returns Promise<void>
Nothing if there is a callback
- Defined in lib/sqlHelpers.ts:191

Function getSql

Type Parameters

T

Parameters

configOrConnection: ConfigOrConnection

sql: Sql

Optional options: ExecuteOptions

Returns Promise<T[]>

Type Parameters

T

Parameters

configOrConnection: ConfigOrConnection

sql: Sql

options: ExecuteOptions

cb: ((record) => void)

Parameters

record: T

Returns void

Returns Promise<void>

Type Parameters

T

Parameters

configOrConnection: ConfigOrConnection

sql: string

Optional params: BindParameters

Optional options: ExecuteOptions

Returns Promise<T[]>

Type Parameters

T

Parameters

configOrConnection: ConfigOrConnection

sql: string

params: BindParameters

options: ExecuteOptions

cb: ((record) => void)

Parameters

record: T

Returns void

Returns Promise<void>

Settings

Member Visibility

Theme

`Optional` options: ExecuteOptions

`Optional` params: BindParameters

`Optional` options: ExecuteOptions