/*
* GET home page.
*/
var queues = require('mysql-queues');
var async = require('async');
var db = require('./DBManager');
var appPool = require('./app-pooling');
exports.index = function(req, res){
var conn = db.db_conn();
conn.connect();
queues(conn);
var trans = conn.startTransaction();
async.series([
function(callback1){
console.log('111111111111111111111111111');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333')";
trans.query(sql,function(err,info){
console.log(err+'aaaaaaaaaaaaaaaaaaaa');
callback1(err,info);
});
},
function(callback2){
console.log('222222222222222222222222');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'bbbbbbbbbbbbbbbbbbbbbb');
callback2(err,info);
});
},
function(callback3){
console.log('33333333333333333333');
var sql = "INSERT INTO user(username,password) VALUES ('111111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'ccccccccccccccccc');
callback3(err,info);
});
}
],function(err,results){
if (err) {
console.log("rollback");
// 出错的场合 回滚
trans.rollback();
} else {
// 没有错误的场合 提交事务
console.log('55555555555555555555555');
// trans.commit();
trans.commit(function(err, info) {
console.log(info);
conn.end();
});
// conn.end();
// conn.destroy();
}
console.log('final');
// conn.release();
// conn.end();
});
// 执行这个事务
trans.execute();
console.log('4444444444444444');
res.send('完成');
};
exports.indexOld = function(req, res){
console.log('删掉的丰盛的');
appPool.pool.getConnection(function (err, conn) {
var trans = conn;
async.series([
function(callback1){
console.log('111111111111111111111111111');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333')";
trans.query(sql,function(err,info){
console.log(err+'aaaaaaaaaaaaaaaaaaaa');
callback1(err,info);
});
},
function(callback2){
console.log('222222222222222222222222');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'bbbbbbbbbbbbbbbbbbbbbb');
callback2(err,info);
});
},
function(callback3){
console.log('33333333333333333333');
var sql = "INSERT INTO user(username,password) VALUES ('111111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'ccccccccccccccccc');
callback3(err,info);
});
}
],function(err,results){
if (err) {
console.log("rollback");
// 出错的场合 回滚
trans.rollback();
} else {
// 没有错误的场合 提交事务
console.log('55555555555555555555555');
trans.commit();
}
console.log('final');
});
// 执行这个事务
console.log('4444444444444444');
res.send('完成');
});
* GET home page.
*/
var queues = require('mysql-queues');
var async = require('async');
var db = require('./DBManager');
var appPool = require('./app-pooling');
exports.index = function(req, res){
var conn = db.db_conn();
conn.connect();
queues(conn);
var trans = conn.startTransaction();
async.series([
function(callback1){
console.log('111111111111111111111111111');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333')";
trans.query(sql,function(err,info){
console.log(err+'aaaaaaaaaaaaaaaaaaaa');
callback1(err,info);
});
},
function(callback2){
console.log('222222222222222222222222');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'bbbbbbbbbbbbbbbbbbbbbb');
callback2(err,info);
});
},
function(callback3){
console.log('33333333333333333333');
var sql = "INSERT INTO user(username,password) VALUES ('111111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'ccccccccccccccccc');
callback3(err,info);
});
}
],function(err,results){
if (err) {
console.log("rollback");
// 出错的场合 回滚
trans.rollback();
} else {
// 没有错误的场合 提交事务
console.log('55555555555555555555555');
// trans.commit();
trans.commit(function(err, info) {
console.log(info);
conn.end();
});
// conn.end();
// conn.destroy();
}
console.log('final');
// conn.release();
// conn.end();
});
// 执行这个事务
trans.execute();
console.log('4444444444444444');
res.send('完成');
};
exports.indexOld = function(req, res){
console.log('删掉的丰盛的');
appPool.pool.getConnection(function (err, conn) {
var trans = conn;
async.series([
function(callback1){
console.log('111111111111111111111111111');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333')";
trans.query(sql,function(err,info){
console.log(err+'aaaaaaaaaaaaaaaaaaaa');
callback1(err,info);
});
},
function(callback2){
console.log('222222222222222222222222');
var sql = "INSERT INTO user(username,password) VALUES ('111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'bbbbbbbbbbbbbbbbbbbbbb');
callback2(err,info);
});
},
function(callback3){
console.log('33333333333333333333');
var sql = "INSERT INTO user(username,password) VALUES ('111111', '333111')";
trans.query(sql,function(err,info){
console.log(err+'ccccccccccccccccc');
callback3(err,info);
});
}
],function(err,results){
if (err) {
console.log("rollback");
// 出错的场合 回滚
trans.rollback();
} else {
// 没有错误的场合 提交事务
console.log('55555555555555555555555');
trans.commit();
}
console.log('final');
});
// 执行这个事务
console.log('4444444444444444');
res.send('完成');
});
}