mysql-transactions

0.0.3 • Public • Published

node-mysql-transactions

dependencies

npm install mysql

install

npm install mysql-transactions

quick start

var transactions = require('mysql-transactions')({
    user: 'hamburglar',
    password: 'omnomnomnomnomnom',
    database: 'playhouse'
});
 
 
 
transactions.begin();
 
 
transactions.query('INSERT INTO users SET ?', { name: 'Lord Voldemort' }, function(err, result) {
 
    if (err) {
        transactions.rollback();
        return console.log('Rolled back.');
    }
 
 
    transactions.commit(function(err, result) {
        console.log('Committed.');
    });
 
});

Note: After calling .begin(), .commit() or .rollback() must be called so that the connection is closed.

api

Each [fn] is a callback for a mysql.query.

  • begin([fn]): start the transaction process.
  • query(String [, Object/Array] [, fn]): traditional query.
  • rollback([fn]): rollback the transaction.
  • commit([fn]): commit the transaction.

Readme

Keywords

none

Package Sidebar

Install

npm i mysql-transactions

Weekly Downloads

0

Version

0.0.3

License

MIT

Last publish

Collaborators

  • emiliote