Advertisement
Guest User

Untitled

a guest
Aug 25th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. var latestFromDB = function(tableName) {
  2. var returnResults;
  3. var mysql = require('mysql');
  4. var pool = mysql.createPool({
  5. host: '****',
  6. user: '****',
  7. password: '****',
  8. database: '****'
  9. });
  10.  
  11. pool.getConnection(function(err, connection) {
  12.  
  13. var sql = 'SELECT id FROM ' + tableName + ' ORDER BY id DESC LIMIT 1;'
  14. connection.query(sql, function(err, results) {
  15. if (err) {
  16. console.log(err);
  17. }
  18. return results[0].id;
  19. });
  20. connection.release();
  21. });
  22. }
  23.  
  24. var promise = new Promise(function(resolve, reject) {
  25. var mysql = require('mysql');
  26. var pool = mysql.createPool({
  27. host: '*****',
  28. user: '****',
  29. password: ****',
  30. database: '*****'
  31. });
  32.  
  33. pool.getConnection(function(err, connection) {
  34.  
  35. var sql = 'SELECT id FROM ' + tableName + ' ORDER BY id DESC LIMIT 1;'
  36. connection.query(sql, function(err, results) {
  37. if (err) {
  38. console.log(err);
  39. }
  40.  
  41. });
  42. connection.release();
  43. });
  44.  
  45. if (results != null) {
  46. resolve("Stuff worked!");
  47. return results[0].id;
  48. } else {
  49. reject(Error("It broke"));
  50. }
  51. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement