const QCPool = require("../index");
const co = require('co');
const qcPool = new QCPool({min: 5,max:10,queryTimeout:10000},'your_server','id','password');
co(function*(){
 
    try {
 
        let connection = yield qcPool.acquire();
        let sql = "select * from table limit 5";
        let result = yield qcPool.query(connection,sql);
        console.log("result Array:",result);
 
        connection = yield qcPool.acquire();
        sql = "select * from table limit 5";
        result = yield qcPool.query(connection,sql,{rowResultType:"Dictionary"});
        console.log("result Dictionary:",result);
 
    } catch(e) {
        console.log("error occurred :",e);
    }
 
    console.log("PoolSize : ",qcPool.getPoolSize());
    console.log("MaxPoolsize : ",qcPool.getMaxPoolSize());
 
});