import { postgres } from "https://deno.land/x/miranda@0.0.6/src/deps.ts";
const { Transaction } = postgres;
This method allows executed queries to be retrieved as array entries. It supports a generic interface in order to type the entries retrieved by the query
import { Client } from "../client.ts";
const client = new Client();
const transaction = client.createTransaction("transaction");
const {rows} = await transaction.queryArray(
"SELECT ID, NAME FROM CLIENTS"
); // Array<unknown[]>
You can pass type arguments to the query in order to hint TypeScript what the return value will be
import { Client } from "../client.ts";
const client = new Client();
const transaction = client.createTransaction("transaction");
const { rows } = await transaction.queryArray<[number, string]>(
"SELECT ID, NAME FROM CLIENTS"
); // Array<[number, string]>
It also allows you to execute prepared stamements with template strings
import { Client } from "../client.ts";
const client = new Client();
const transaction = client.createTransaction("transaction");
const id = 12;
// Array<[number, string]>
const { rows } = await transaction.queryArray<[number, string]>`SELECT ID, NAME FROM CLIENTS WHERE ID = ${id}`;