mysql-helper-simple

this is a mysql helper simple plug-in

Github: https://github.com/lienren/mysql-helper

Installation

$ npm install mysql-helper-simple

Examples

Before running the examples ensure you have mysql-helper-simple installed and enabled at the top of your script:

const sqlhelper = require("mysql-helper-simple")({
  "host": "localhost",
  "user": "root",
  "password": "123456",
  "database": "mydb"});

other config

{
  host: host,
  port: port,
  user: user,
  password: password,
  database: database,
  charset: charset,
  dateStrings: dateStrings
}

Query

var sql = "select * from users";
sqlhelper.query({
  sql: sql
}).then(result => {
  console.log(result);
});

Create

var sql = "insert into users (uname) values ('lienren')";
sqlhelper.create({
  sql: sql
}).then(result => {
  console.log(result);
  // return LAST_INSERT_ID() as id
});

Update

var sql = "update users set name = 'hello lienren' where id = 1";
sqlhelper.update({
  sql: sql
}).then(result => {
  console.log(result);
  // return mysql_affected_rows()
});

Batch Execute

var sql0 = "select * from users";
var sql1 = "...";
sqlhelper.batch([
  sqlhelper.query({ sql: sql0 }),
  sqlhelper.query({ sql: sql1 }),
]).then(results => {
  console.log(results[0]);
  console.log(results[1]);
});

Support Squel

Before running the examples ensure you have squel installed and enabled at the top of your script:

var squel = require("squel");

Query

var sql = squel.select().from('users').toParam();
sqlhelper.query({
  sql: sql.text,
  values: sql.values
}).then(result => {
  console.log(result);
});

License

MIT - see LICENSE.md