async function bringData() {
return new Promise(resolve => {
setTimeout(() => {
resolve(con.query('SELECT company, industry FROM my_table', function (err, result) {
if (err) {
console.error(err);
throw 'Error getting data from google_businesses table';
} else {
return result;
}
}));
}, 1000);
});
}
(async () => {
// return data from brindData function
let getData = await bringData();
console.log(getData);
})();I am calling this function in main but I am always getting error. I am kind of new to node so if please anybody can guide me or is there any other way to do this such that when I have got my result I can return it.
Call resolve with the result from your query.The con.query looks like another asynchronous thing:
con.query('...', (err, result) => {
if (!err)
resolve(result);
});
You can try this.
async function bringData() {
return new Promise((resolve, reject) => {
con.query('SELECT company, industry FROM my_table', (err, result) => {
if (err) {
reject(err);
}
resolve(result);
})
});
}
(async () => {
// execute bringData function
try {
let getData = await bringData();
console.log(getData);
} catch (e) {
console.error(e);
}
})();Edited with timeout
async function bringData() {
return new Promise((resolve, reject) => {
con.query('SELECT company, industry FROM my_table', (err, result) => {
if (err) {
reject(err);
}
resolve(result);
})
});
}
function timeout(seconds = 10) {
return new Promise(resolve => {
setTimeout(resolve, 10 * 1000)
})
}
(async () => {
// execute bringData function
try {
await timeout();
let getData = await bringData();
console.log(getData);
} catch (e) {
console.error(e);
}
})();