@azhou/mysql-wrapper

Usage

1. Initialize database

   var db = require("@azhou/mysql-wrapper");
   db.init("server", "database", "username", "password");
   

2. Run queries

   Promise is returned as query gets executed

   • General query

     db.query(sql).then(function (result) {
         // process results
     }.catch(function (error) {
         // process error
     });
     

   • Return single row

     db.queryFirstRow("SELECT * FROM record WHERE id=?", id).then(...);
     

   • Return single value:

     db.queryFirstField("SELECT COUNT(*) FROM record").then(...);