/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

1 vote165 views1 answer
Node js server timeout express issue
Javascript Node.js
0 vote164 views1 answer
Nodejs validate bnb wallet address
Javascript Node.js
0 vote174 views1 answer
Xpath nodejs
Javascript Node.js
25 votes173 views2 answers
Updating node js ubuntu
Javascript Node.js
18 votes198 views4 answers
Nodejs create folder if not exist
Javascript Node.js
31 votes181 views5 answers
Update node js version ubuntu
Javascript Node.js
4 votes185 views2 answers
Nodejs await inside map
Javascript Node.js
2 votes186 views2 answers
Nodejs date add days
Javascript Node.js
0 vote178 views2 answers
Test command in node js
Javascript Node.js
0 vote205 views1 answer
Node ja sap concur
Javascript Node.js