mysql - 如何运行动态查询数组的事务

Question

我有一个动态查询数组，示例:-

arrQueries=["update table1 set field1='val1',field2='val2' where 
id=5;","update table1 set field3='val3',field4='val4' where id=10;" ];

如何通过循环数组来运行事务？

Answer 1

我使用了node-mysql-transaction

    var transaction = require('node-mysql-transaction');
var trCon = transaction({connection: [mysql.createConnection, {
            // mysql connection config
            user: ...,
            password: ...,
            database:...,
            host:..
        }], dynamicConnection: 32, timeout: 600});
arrQueries=["update table1 set field1='val1',field2='val2' where 
id=5;","update table1 set field3='val3',field4='val4' where id=10;" ];

 var chain = trCon.chain();
                chain.
                on('commit', function () {
                    console.log('commit');                           
                    return res.send("commit");

                }).
                on('rollback', function (err) {
                    console.log('rollback');
                    return res.send("rollback");
                });

                for (var i = 0; i < arrQueries.length; i += 1) {
                    chain.query(arrQueries[i]);
                }