import type {SQLQuery} from '@databases/sql'; import {isSqlQuery} from '@databases/sql/web'; import type Driver from './Driver'; import {ConnectionFactory, Disposable, TransactionFactory} from './Factory'; export function assertSql(query: SQLQuery | SQLQuery[]) { if (Array.isArray(query)) { for (const q of query) { if (!isSqlQuery(q)) { throw new Error( 'Invalid query, you must use @databases/sql to create your queries.', ); } } } else { if (!isSqlQuery(query)) { throw new Error( 'Invalid query, you must use @databases/sql to create your queries.', ); } } } export async function executeAndReturnAll( driver: Driver, queries: SQLQuery[], ): Promise { return driver.executeAndReturnAll(queries); } export async function executeAndReturnLast( driver: Driver, queries: SQLQuery[], ): Promise { return driver.executeAndReturnLast(queries); } export async function queryInternal( driver: Driver, queries: SQLQuery[], fn: ( driver: Driver, queries: SQLQuery[], ) => Promise, ): Promise { const hasTransaction = queries.length > 1; try { if (hasTransaction) { await driver.beginTransaction(undefined); } const results = await fn(driver, queries); if (hasTransaction) { await driver.commitTransaction(); } return results; } catch (ex: any) { if (hasTransaction) { await driver.rollbackTransaction(ex); } throw ex; } } export async function taskInternal< TConnection extends Disposable, TTransactionOptions, TDriver extends Driver, TResult, >( driver: TDriver, factories: ConnectionFactory, fn: (connection: TConnection) => Promise, ): Promise { const connection = factories.createConnection(driver); try { return await fn(connection); } finally { await connection.dispose(); } } export async function txInternal< TTransaction extends Disposable, TTransactionOptions, TDriver extends Driver, TResult, >( driver: TDriver, factories: TransactionFactory, fn: (connection: TTransaction) => Promise, options: TTransactionOptions | undefined, addPostCommitStep: (fn: () => Promise) => void, ): Promise { let failureCount = 0; while (true) { await driver.beginTransaction(options); const tx = factories.createTransaction(driver, {addPostCommitStep}); let result; try { result = await fn(tx); await tx.dispose(); await driver.commitTransaction(); } catch (ex: any) { await tx.dispose(); await driver.rollbackTransaction(ex); if ( await driver.shouldRetryTransactionFailure(options, ex, ++failureCount) ) { continue; } throw ex; } return result; } }