Class SqliteStatement

Pre-compiled SQL statement.

Hierarchy

SqliteStatement

Index

Constructors

Methods

bindBlob bindFloat bindInteger bindNull bindText reset step

Constructors

constructor

new SqliteStatement(): SqliteStatement
Returns SqliteStatement

Methods

bindBlob

bindBlob(index: number, bytes: string | number[] | ArrayBuffer): void
Binds the blob bytes to index.
Parameters
- index: number
  
  1-based index.
- bytes: string | number[] | ArrayBuffer
  
  Blob value to bind.
Returns void
- Defined in index.ts:2470

bindFloat

bindFloat(index: number, value: number): void
Binds the floating point value to index.
Parameters
- index: number
  
  1-based index.
- value: number
  
  Floating point value to bind.
Returns void
- Defined in index.ts:2455

bindInteger

bindInteger(index: number, value: number): void
Binds the integer value to index.
Parameters
- index: number
  
  1-based index.
- value: number
  
  Integer value to bind.
Returns void
- Defined in index.ts:2447

bindNull

bindNull(index: number): void
Binds a null value to index.
Parameters
- index: number
  
  1-based index.
Returns void
- Defined in index.ts:2477

bindText

bindText(index: number, value: string): void
Binds the text value to index.
Parameters
- index: number
  
  1-based index.
- value: string
  
  Text value to bind.
Returns void
- Defined in index.ts:2462

reset

reset(): void
Resets internal state to allow subsequent queries.

Returns void
- Defined in index.ts:2492

step

step(): null | any[]
Either starts a new query and gets the first result, or moves to the next one.

Returns an array containing the values in the order specified by the query, or null when the last result is reached. You should call reset() at that point if you intend to use this object again.

Returns null | any[]
- Defined in index.ts:2487

Generated using TypeDoc