New Case Study:See how Anthropic automated 95% of dependency reviews with Socket.Learn More
Socket
Sign inDemoInstall
Socket

@cdellacqua/knex-transact

Package Overview
Dependencies
Maintainers
1
Versions
18
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

@cdellacqua/knex-transact

transact function that provides a simple mechanism to translate SQL transactions into code

  • 5.0.0
  • latest
  • Source
  • npm
  • Socket score

Version published
Weekly downloads
12
decreased by-20%
Maintainers
1
Weekly downloads
 
Created
Source

knex-transact

transact function that provides a simple mechanism to translate SQL transactions into code

NPM Package

npm install @cdellacqua/knex-transact

How to configure

To use this function you must first assign config.knex to your knex instance. For example:

	import { config } from '@cdellacqua/knex-transact';

	import { knex } from 'knex';
	
	const myKnexInstance = knex({
		// your database configuration
	});

	config.knexInstance = myKnexInstance;

How to use

This package exposes a function called transact. It accepts two arguments: an array of functions (or a single function) that return a Promise, and an optional Transaction.

If a function needs to process data with and without having an already initialized transaction, one can easily end up writing some boilerplate code like this:

	
async function aFunctionThatReceivesAnOptionalTransaction(trx?: Transaction) {
	const db = trx || knex.transaction();
	try {
		const tempResult = await db('table').where('property', 'value').select();
		await someOtherFunction(tempResult, db);

		if (!trx) {
			db.commit();
		}
	} catch (err) {
		if (!trx) {
			db.rollback();
		}

		throw err;
	}
}

This library takes care of that boilerplate, thus reducing noise and allowing to write less and cleaner code:

function aFunctionThatReceivesAnOptionalTransaction(trx?: Transaction) {
	return transact([
		(db) => db('table').where('property', 'value').select(),
		(db, tempResult) => someOtherFunction(tempResult, db),
	], trx);
}

Keywords

FAQs

Package last updated on 11 May 2023

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc