Advertisement
Guest User

Untitled

a guest
Oct 1st, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. var mysql = require('mysql');
  2. var client = mysql.createConnection({
  3. user: 'root',
  4. password: '',
  5. database: 'kong_centar'
  6. //debug: true
  7. });
  8.  
  9. var ignore = [mysql.ERROR_DB_CREATE_EXISTS,
  10. mysql.ERROR_TABLE_EXISTS_ERROR];
  11.  
  12. client.on('error', function (err) {
  13. if (ignore.indexOf(err.number) + 1) { return; }
  14. throw err;
  15. });
  16. for(i=0; i<10; i++){
  17. var pre_query = new Date().getTime();
  18. client.query('select * from korisnik', function(err, result, fields){
  19. var post_query = new Date().getTime();
  20. var duration = (post_query - pre_query) / 1000;
  21.  
  22. console.log(duration);
  23.  
  24. if (err)
  25. {
  26. throw err;
  27. }
  28. else
  29. {
  30.  
  31. //console.log(result);
  32. for (var i in result)
  33. {
  34. //var people = result[i];
  35. //console.log(people.firstname + ' ' + people.lastname);
  36. }
  37. }
  38. });
  39. }
  40. client.end();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement