mysqlw

0.13.6 • Public • Published

mysqlw

A lightweight wrapper for node-mysql to simplify queries.

Installation

npm install mysqlw --save

Configuration

let config = {
    "pooling": true,
    "connection": {
        "host": "HOSTNAME",
        "user": "USERNAME",
        "password": "PASSWORD",
        "database": "DATABASE"
    }
};

For more connection options see: connection-options

Example Usage

let co = require("co");
 
let Database = require("mysqlw");
let db = new Database(config);
 
co (function *() {
 
    yield db.beginTransaction();
    yield db.query("INSERT INTO users SET ?", {"userName": "bob"});
    yield db.query("INSERT INTO users SET ?", {"userName": "tom"});
    yield db.endTransaction();
        
    let result = yield db.query("SELECT * FROM users");
    console.log(result);
        
}).catch ((error) => {
    // error;
});

Promises

Parameters marked with (*) are optional:

  • query(sql, *values)
  • beginTransaction()
  • endTransaction()
  • rollback(*error);

Example

db.query("UPDATE users SET ? WHERE id=?", [{"userName":"Bobby"}, 1]).then((result) => {
    // result
}, (error) => {
    // error
});

Package Sidebar

Install

npm i mysqlw

Weekly Downloads

0

Version

0.13.6

License

MIT

Last publish

Collaborators

  • svengerhardt