Skip to main content
StatementSync.prototype.all - node__sqlite.d.ts - Node documentation
method StatementSync.prototype.all

Usage in Deno

```typescript import { StatementSync } from "node:node__sqlite.d.ts"; ```
StatementSync.prototype.all(...anonymousParameters: SupportedValueType[]): unknown[]
This method executes a prepared statement and returns all results as an array of objects. If the prepared statement does not return any results, this method returns an empty array. The prepared statement [parameters are bound](https://www.sqlite.org/c3ref/bind_blob.html) using the values in `namedParameters` and `anonymousParameters`.

Parameters

...anonymousParameters: SupportedValueType[]

Return Type

unknown[]
An array of objects. Each object corresponds to a row returned by executing the prepared statement. The keys and values of each object correspond to the column names and values of the row.
StatementSync.prototype.all(
namedParameters: Record<string, SupportedValueType>,
...anonymousParameters: SupportedValueType[],
): unknown[]

Parameters

namedParameters: Record<string, SupportedValueType>
...anonymousParameters: SupportedValueType[]

Return Type

unknown[]