Package Exports
- @any.io/mysql.io
This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@any.io/mysql.io) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.
Readme
MySQL.IO
MySQL.IO is a simple module to use MySQL Databases
Install
npm i @any.io/mysql.ioUsage
var MySQL = require('@any.io/mysql.io');
var Database = new MySQL({
"host" : "dbHost", // String
"user" : "dbUser", // String
"password" : "dbPass", // String
"database" : "dbName", // String
});INSERT
Database.INSERT( table = String ) => Object
Example
var INTO = 'table';
var SET = {"column": 'value'};
var res = Database.INSERT(INTO).SET(SET).EXECUT();
var { error, success, data } = res;
if(!error){
console.log('Success:', success);
console.info('Data:', data, 'lastInsertId:', data.insertId);
}else{
console.error('Error:', error);
}SELECT
Database.SELECT( columns = Array ) => Object
Example
var FROM = 'table';
var COLOUMNS = ['*'];
var res = Database.SELECT(COLUMNS).FROM(FROM).EXECUT();
var { error, success, data } = res;
if(!error){
console.log('Success:', success);
console.info('Data:', data);
}else{
console.error('Error:', error);
}UPDATE
Database.UPDATE( table = String ) => Object
Example
var TABLE = 'table';
var SET = {"column": 'value'};
var res = Database.UPDATE(TABLE).SET(SET).EXECUT();
var { error, success, data } = res;
if(!error){
console.log('Success:', success);
console.info('Data:', data, 'changedRows:', data.changedRows);
}else{
console.error('Error:', error);
}DELETE
Database.UPDATE( table = String ) => Object
return {WHERE(condtions = Object),EXECUT()}
{
WHERE: (condtions = Object) => ({ EXECUT }),
EXECUT: () => ({ error, success, data })
}Example
var TABLE = 'table';
var WHERE = {"column": 'value'};
var res = Database.DELETE(TABLE).WHERE(SET).EXECUT();
var { error, success, data } = res;
if(!error){
console.log('Success:', success);
console.info('Data:', data, 'changedRows:', data.changedRows);
}else{
console.error('Error:', error);
}