node mysql事务,Node.js MySQL事务

Can anyone provide an example of how I could achieve MySQL transactions in Node.js. I am trying to get my head around using the node-mysql driver and node-mysql-queue.

As far are I can tell, using node-mysql-queue greatly reduces the asynchronous nature of Node.js as new queries have to wait until existing ones have completed. To get around this, has anyone attempted to combine node-mysql-queue with node-mysql's connection-pooling capabilities. i.e starting a new mysql connection for each new http request, and starting transaction queues on individual connections?

解决方案

The following transaction example was added to the documentation a month ago:

connection.beginTransaction(function(err) {

if (err) { throw err; }

connection.query('INSERT INTO posts SET title=?', title, function(err, result) {

if (err) {

connection.rollback(function() {

throw err;

});

}

var log = 'Post ' + result.insertId + ' added';

connection.query('INSERT INTO log SET data=?', log, function(err, result) {

if (err) {

connection.rollback(function() {

throw err;

});

}

connection.commit(function(err) {

if (err) {

connection.rollback(function() {

throw err;

});

}

console.log('success!');

});

});

});

});