0.13.6 • Published 8 years ago
mysqlw v0.13.6
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
});