Transaction adapter interface.
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.