GPT

Database Utility Functions

// src/db.utils.js import { sql } from './db.js'; export async function withTransaction(callback) { try { await sqlBEGIN; const result = await callback(sql); await sqlCOMMIT; return result; } catch (error) { awai

Prompt text

Original English text. Replace placeholders with your own details.

// src/db.utils.js
import { sql } from './db.js';

export async function withTransaction(callback) {
 try {
 await sql`BEGIN`;
 const result = await callback(sql);
 await sql`COMMIT`;
 return result;
 } catch (error) {
 await sql`ROLLBACK`;
 throw error;
 }
}

export async function createPaginatedQuery(
 baseQuery,
 page,
 pageSize,
 params = []
) {
 const offset = (page - 1) * pageSize;
 const countQuery = `SELECT COUNT(*) as total FROM (${baseQuery}) as subquery`;
 
 const [{ total }] = await sql.raw(countQuery, params);
 const data = await sql.raw(
 `${baseQuery} LIMIT ${pageSize} OFFSET ${offset}`,
 params
 );

 return {
 data,
 total: parseInt(total),
 pages: Math.ceil(total / pageSize)
 };
}

export async function executeInBatch(items, batchSize, callback) {
 for (let i = 0; i < items.length; i += batchSize) {
 const batch = items.slice(i, i + batchSize);
 await callback(batch);
 }
}

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →