qiao.plugin.mysql

nodejs mysql plugin

Usage no npm install needed!

<script type="module">
  import qiaoPluginMysql from 'https://cdn.skypack.dev/qiao.plugin.mysql';
</script>

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

http://uikoo9.com/donate

started

install

npm install qiao.plugin.mysql

dependencies

  1. mysql

documentation

  1. mysql, https://www.npmjs.com/package/mysql

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

  1. ncu

0.0.7.20191206

  1. update packages
  2. add funding

0.0.6.20190107

  1. nodejs mysql plugin

0.0.5.20181213

  1. add lib

0.0.4.20181127

  1. add .js

0.0.3.20181108

  1. update query and connection

0.0.2.20181015

  1. add _connection.js
  2. add _query.js
  3. add getColumns()
  4. add getTypes()

0.0.1.20180803

  1. init project
  2. modify md