README
urls
homepage
https://code.insistime.com/qiao.plugin.mysql
github
https://github.com/insistime/qiao.plugin.mysql
npm
https://www.npmjs.com/package/qiao.plugin.mysql
donate
started
install
npm install qiao.plugin.mysql
dependencies
- mysql
documentation
api
connection
'use strict';
var qiaoPluginMysql = require('qiao.plugin.mysql');
var connection = qiaoPluginMysql.connection(require('./_config.json'));
console.log(connection);
query
'use strict';
var qiaoPluginMysql = require('qiao.plugin.mysql');
var test = async function(){
try{
var rows = await qiaoPluginMysql.query(require('./_config.json'), 'select * from t_share_type where id=?', [1]);
console.log(rows);
}catch(e){
console.log(e);
}
};
test();
getColumns
'use strict';
var qiaoPluginMysql = require('qiao.plugin.mysql');
var test = async function(){
try{
var res = await qiaoPluginMysql.getColumns(require('./_config.json'), 't_share_type');
console.log(res);
}catch(e){
console.log(e);
}
};
test();
getTypes
'use strict';
var qiaoPluginMysql = require('qiao.plugin.mysql');
var type = qiaoPluginMysql.getTypes('varchar(10)');
console.log(type);
poolConnection
'use strict';
var qiaoPluginMysql = require('qiao.plugin.mysql');
var test = async function(){
try{
qiaoPluginMysql.poolInit(require('./_config.json'));
var connection = await qiaoPluginMysql.poolConnection();
console.log(connection);
}catch(e){
console.log(e);
}
};
test();
poolQuery
'use strict';
var qiaoPluginMysql = require('qiao.plugin.mysql');
var test = async function(){
try{
qiaoPluginMysql.poolInit(require('./_config.json'));
var rows = await qiaoPluginMysql.poolQuery('select * from t_share_type where id=?', [1]);
console.log(rows);
}catch(e){
console.log(e);
}
};
test();
version
0.0.8.20200803
- ncu
0.0.7.20191206
- update packages
- add funding
0.0.6.20190107
- nodejs mysql plugin
0.0.5.20181213
- add lib
0.0.4.20181127
- add .js
0.0.3.20181108
- update query and connection
0.0.2.20181015
- add _connection.js
- add _query.js
- add getColumns()
- add getTypes()
0.0.1.20180803
- init project
- modify md