Class PreparedStatement

A prepared SQL statement with parameter binding.

Index

Constructors

Methods

bind bindBlob bindBoolean bindDate bindDouble bindFloat bindInt32 bindInt64 bindNull bindString bindTimestamp close execute parameterCount run

Constructors

constructor

new PreparedStatement(
    stmtPtr: number,
    _connPtr: number,
    sql: string,
): PreparedStatement
Internal
Parameters
- stmtPtr: number
- _connPtr: number
- sql: string
Returns PreparedStatement
- Defined in packages/ducklings-workers/src/index.ts:703

Methods

bind

bind(index: number, value: unknown): this
Parameters
- index: number
- value: unknown
Returns this
- Defined in packages/ducklings-workers/src/index.ts:857

bindBlob

bindBlob(index: number, value: Uint8Array): this
Parameters
- index: number
- value: Uint8Array
Returns this
- Defined in packages/ducklings-workers/src/index.ts:795

bindBoolean

bindBoolean(index: number, value: boolean): this
Parameters
- index: number
- value: boolean
Returns this
- Defined in packages/ducklings-workers/src/index.ts:714

bindDate

bindDate(index: number, value: Date): this
Parameters
- index: number
- value: Date
Returns this
- Defined in packages/ducklings-workers/src/index.ts:843

bindDouble

bindDouble(index: number, value: number): this
Parameters
- index: number
- value: number
Returns this
- Defined in packages/ducklings-workers/src/index.ts:769

bindFloat

bindFloat(index: number, value: number): this
Parameters
- index: number
- value: number
Returns this
- Defined in packages/ducklings-workers/src/index.ts:756

bindInt32

bindInt32(index: number, value: number): this
Parameters
- index: number
- value: number
Returns this
- Defined in packages/ducklings-workers/src/index.ts:727

bindInt64

bindInt64(index: number, value: number | bigint): this
Parameters
- index: number
- value: number | bigint
Returns this
- Defined in packages/ducklings-workers/src/index.ts:740

bindNull

bindNull(index: number): this
Parameters
- index: number
Returns this
- Defined in packages/ducklings-workers/src/index.ts:814

bindString

bindString(index: number, value: string): this
Parameters
- index: number
- value: string
Returns this
- Defined in packages/ducklings-workers/src/index.ts:782

bindTimestamp

bindTimestamp(index: number, value: Date): this
Parameters
- index: number
- value: Date
Returns this
- Defined in packages/ducklings-workers/src/index.ts:827

close

close(): void
Returns void
- Defined in packages/ducklings-workers/src/index.ts:1052

execute

execute(): Promise<number>
Executes the prepared statement without returning results.

Returns Promise<number>
Promise resolving to number of rows affected
- Defined in packages/ducklings-workers/src/index.ts:1011

parameterCount

parameterCount(): number
Returns number
- Defined in packages/ducklings-workers/src/index.ts:708

run

run<T = Record<string, unknown>>(): Promise<T[]>
Executes the prepared statement and returns results as an array of objects.
Type Parameters
- T = Record<string, unknown>
Returns Promise<T[]>
Promise resolving to array of result rows
- Defined in packages/ducklings-workers/src/index.ts:877