Class Sql

A SQL instance can be nested within each other to build SQL strings.

Extension: https://marketplace.visualstudio.com/items?itemName=thebearingedge.vscode-sql-lit

Extension: https://marketplace.visualstudio.com/items?itemName=frigus02.vscode-sql-tagged-template-literals-syntax-only

Adapted for Oracle from https://github.com/blakeembrey/sql-template-tag

Hierarchy

Sql

Index

Constructors

Properties

#valueMap #values strings

Accessors

Methods

Constructors

constructor

new Sql(rawStrings, rawValues): Sql
Parameters
- rawStrings: readonly string[]
- rawValues: readonly RawValue[]
Returns Sql
- Defined in lib/sql.ts:43

Properties

`Private` #valueMap

#valueMap: Map<ValueArray, number> = ...

`Private` #values

#values: ValueArray[]

strings

strings: string[]

Accessors

sql

get sql(): string
Returns string
- Defined in lib/sql.ts:134

values

get values(): Record<string, Value> | Record<string, Value>[]
Returns Record<string, Value> | Record<string, Value>[]
- Defined in lib/sql.ts:150

Methods

join

join(values): Sql
Join together multiple values into a single Sql instance
Parameters
- values: RawValue[]
  
  The values to join together
Returns Sql
an Sql instance with the values joined by the separator (the this Sql instance)
- Defined in lib/sql.ts:121

`Private` updateMap

updateMap(): void
Returns void
- Defined in lib/sql.ts:106

Generated using TypeDoc