interface DBTransactionAdapter

Transaction adapter interface.

Methods

query<T extends Record<string, any> = Record<string, any>>(
sql: string,
params?: unknown[]
): Promise<T[]>

Execute a SELECT query and return rows.

execute(
sql: string,
params?: unknown[]
): Promise<number>

Execute INSERT/UPDATE/DELETE and return affected row count.

executeBatch(
sql: string,
paramsArray: unknown[][]
): Promise<number[]>

Execute multiple commands in a batch.

commit(): Promise<void>

Commit the transaction.

rollback(): Promise<void>

Rollback the transaction.

Usage

import { type DBTransactionAdapter } from ".";