Advertisement
Guest User

Untitled

a guest
Oct 12th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var pool  = mysql.createPool({
  2.     connectionLimit : 10,
  3.     database: '',
  4.     host: '127.0.0.1',
  5.     user: '',
  6.     password: ''
  7. });
  8.  
  9. function query(sql, callback) {
  10.     console.log(sql);
  11.     if (typeof callback === 'undefined') {
  12.         callback = function() {};
  13.     }
  14.     pool.getConnection(function(err, connection) {
  15.         if(err){
  16.             // return callback(err);
  17.             query(sql, callback);
  18.             return;
  19.         }
  20.         connection.query(sql, function(err, rows) {
  21.             if(err){
  22.                 // return callback(err);
  23.                 query(sql, callback);
  24.                 return;
  25.             }
  26.             connection.release();
  27.             return callback(null, rows);
  28.         });
  29.     });
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement