/Javascript/Node.js/Transaction commit rollback nodejs

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)
    }
}

Source: stackoverflow.com

Similar codes

0 vote231 views1 answer
Node red reverse proxy for ui to root
Javascript Node.js
25 votes240 views3 answers
Nodejs file exists
Javascript Node.js
10 votes240 views5 answers
What is dotenv in nodejs
Javascript Node.js
1 vote239 views1 answer
Download a file nodejs
Javascript Node.js
-2 votes231 views1 answer
Scraping google nodejs
Javascript Node.js
0 vote234 views1 answer
Nodejs how to send html
Javascript Node.js
0 vote240 views2 answers
Ubuntu 18.04 nodejs insatll
Javascript Node.js
0 vote241 views1 answer
Upload file on node js azure function
Javascript Node.js
1 vote274 views2 answers
Nodejs request post
Javascript Node.js
23 votes228 views5 answers
Node js server
Javascript Node.js