Module

x/nessie/deps.ts>SQLiteClient#queryEntries

A modular Deno library for PostgreSQL, MySQL, MariaDB and SQLite migrations
Go to Latest
method SQLiteClient.prototype.queryEntries
import { SQLiteClient } from "https://dotland.deno.dev/x/nessie@2.0.9/deps.ts";

Like query except each row is returned as an object containing key-value pairs.

Examples

const rows = db.queryEntries<{ name: string, age: number }>("SELECT name, age FROM people");
// rows = [{ name: "Peter Parker", age: 21 }, ...]
const rows = db.queryEntries<{ name: string, age: number }>(
  "SELECT name, age FROM people WHERE age >= :minAge",
  { minAge },
 );
// rows = [{ name: "Peter Parker", age: 21 }, ...]

Type Parameters

optional
O extends RowObject = RowObject

Parameters

sql: string
optional
params: QueryParameterSet

Returns

Array<O>