0.13.6 • Published 8 years ago

mysqlw v0.13.6

Weekly downloads
16
License
MIT
Repository
github
Last release
8 years ago

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
});
0.13.6

8 years ago

0.13.5

8 years ago

0.13.4

9 years ago

0.13.3

9 years ago

0.13.2

9 years ago

0.13.1

9 years ago

0.12.2

9 years ago

0.12.1

9 years ago