function rowsByIds
rowsByIds<Row>(
ids: number[],
buildSql: (placeholders: string) => string,
): Promise<Row[]>

Run an id-keyed SELECT, short-circuiting to [] (no query) when ids is empty. buildSql receives the bound ?-placeholder list for ids, so ids are the only query args. The base skeleton for the id-map helpers below and for any read that loads rows for a caller-supplied id list.

Type Parameters

Row

Parameters

ids: number[]
buildSql: (placeholders: string) => string

Return Type

Promise<Row[]>

Usage

import { rowsByIds } from "docs/database.ts";