/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 vote230 views1 answer
Signalwire instaall in node
Javascript Node.js
18 votes150 views2 answers
Node gitignore
Javascript Node.js
1 vote143 views1 answer
Create csv file nodejs
Javascript Node.js
6 votes166 views1 answer
Node server start using pm2
Javascript Node.js
20 votes166 views4 answers
Node open file
Javascript Node.js
0 vote157 views1 answer
Node js create or check directory
Javascript Node.js
0 vote165 views1 answer
How to get file tree of specific folder in node js
Javascript Node.js
33 votes171 views6 answers
Ubuntu nodejs update
Javascript Node.js
102 votes275 views4 answers
Node json stringify
Javascript Node.js
6 votes151 views1 answer
Node js event emitter
Javascript Node.js