var pools = require('./pool.js');


var pool = pools({
			host: 'localhost',
			username: 'root',
			password: 'q',
			database: 'test',
			poolSize: 5
		});

function onquery(err, res) {
	if (res) {
		res.fetchAll(function (err, res) {
			console.log(err, res);
		});
	}
}

var i = 20;

pool.query('delete from tbl;', console.log);

while (i--) {
	if (i % 2) {
		pool.query('insert into tbl (str) values ("' + i + '");', console.log);
	} else {
		pool.query('select * from tbl;', onquery);
	}
}