transaction commit rollback nodejs
const mysql = require('mysql2/promise')
/** See documentation from original answer */
async function transaction(queries, queryValues) {
if (queries.length !== queryValues.length) {
return Promise.reject(
'Number of provided queries did not match the number of provided query values arrays'
)
}
const connection = await mysql.createConnection(databaseConfigs)
try {
await connection.beginTransaction()
const queryPromises = []
queries.forEach((query, index) => {
queryPromises.push(connection.query(query, queryValues[index]))
})
const results = await Promise.all(queryPromises)
await connection.commit()
await connection.end()
return results
} catch (err) {
await connection.rollback()
await connection.end()
return Promise.reject(err)
}
}
Also in JavaScript:
- do i have to include jquery files at head of bootstrap
- switch element array angular
- uncheck checkbox when another is checked javascript
- detect if two line segments intersect each other javascript
- how to create react app using yarn
- mongoose save with data from req.body
- javascript number format
- javascript get middle of array
- javascript backslash
- node js find directory change directory
- javascript detect browser type
- disable editing ace code edior
- jquery fadein
- Javascript get sum of array values
- setinterval vs settimeout in javascript\
- next.js google script
- number pyramid in javascript
- javascript random number
- function click anywhere javascript
- dangerouslySetInnerHTML did not match error in React
- filter array objects javascript
- javascript get current url
- : Timeout - Async callback was not invoked within the 5000 ms timeout specified by jest.setTimeout.Timeout - Async callback was not invoked within the 5000 ms timeout specified by jest.setTimeout.Error:
- What does ~~ (“double tilde”) do in Javascript?