Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var latestFromDB = function(tableName) {
- var returnResults;
- var mysql = require('mysql');
- var pool = mysql.createPool({
- host: '****',
- user: '****',
- password: '****',
- database: '****'
- });
- pool.getConnection(function(err, connection) {
- var sql = 'SELECT id FROM ' + tableName + ' ORDER BY id DESC LIMIT 1;'
- connection.query(sql, function(err, results) {
- if (err) {
- console.log(err);
- }
- return results[0].id;
- });
- connection.release();
- });
- }
- var promise = new Promise(function(resolve, reject) {
- var mysql = require('mysql');
- var pool = mysql.createPool({
- host: '*****',
- user: '****',
- password: ****',
- database: '*****'
- });
- pool.getConnection(function(err, connection) {
- var sql = 'SELECT id FROM ' + tableName + ' ORDER BY id DESC LIMIT 1;'
- connection.query(sql, function(err, results) {
- if (err) {
- console.log(err);
- }
- });
- connection.release();
- });
- if (results != null) {
- resolve("Stuff worked!");
- return results[0].id;
- } else {
- reject(Error("It broke"));
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement