1.1.4 • Published 7 years ago
mysql-helper-simple v1.1.4
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