I am making a series of DB calls based on the response from the first DB call. In the end, I am looping through the combined result and making the response. when I am running this code, I found for each callback function is not waiting for the response to complete. it is looping through the result from the first DB call. here is my code
this.router.get("/:version/:dept/:id", (req: any, res: any) => {
try {
logger.trace("getDetails call initialized");
const dept= req.params.dept;
const id= req.params.id;
const deptDao = new deptDAO();
let finalDetails = [];
let simpleDetail = {};
deptDao
.getdetails(dept, id)
.then((rows) => {
rows.forEach(async (row: any) => {
if (row.dept_name== "Science") {
console.log('Logging error');
try {
let idDao = new IDDao();
await idDao .getIdDetails(dept, row.valueId).then((result) => {
if (result[0].std_details!= undefined && result[0].std_details.datas != undefined) {
row.datas = result[0].std_details.datas;
}
})
} catch (error) {
logger.error('failed', error);
}
} else {
CommonUtil.formatDetails(dept, rows);
}
});
rows.forEach((dets) => {
if (row.dept_name== "Science") {
simpleDetails = dets;
} else {
finalDetails.push(dets)
}
})
res.status(200);
})
.catch((err) => {
res.status(500);
res.send({ status: "failed with an error", message: err });
})
.finally (() => { res.send({ status: "success", depts: finalDetails, dept: simpleDetails }) });
} catch (ex) {
res.status(500);
res.send({ status: "failed", message: ex });
}
});
when this rows.forEach((dets) callback is running, I am not able to get the datas value from the getIdDetails result as it was executed after my response got printed. Could anyone help me with this? I think the promise might help out. but I am not sure of that either.
