I'm facing an issue where I need to wait for a function to return a value from my MySQL table before using it as a return for my const ProjektNameIntentHandler. Here is the relevant code snippet:
const ProjektNameIntentHandler = {
canHandle(handlerInput) {
return handlerInput.requestEnvelope.request.type === 'IntentRequest'
&& handlerInput.requestEnvelope.request.intent.name === 'ProjektNameIntent';
},
handle(handlerInput) {
let getProjektName = queryDb()
getProjektName.then(function(result) {
var projektName = result[0];
console.log(projektName.Test);
})
return handlerInput.responseBuilder
.speak(projektName.Test)
.withSimpleCard('Venture', projektName.Test)
.getResponse();
}
};
The challenge lies in getting the result of ProjektNameIntentHandler before projektName receives the result. Initially, I attempted to include the second return statement within the scope of the function. However, this approach confines the result to the function and doesn't allow it to be returned for my ProjektNameIntentHandler.
My goal is to ensure that the second return statement for the handlerInput waits for the completion of my getProjektName.then. How can I achieve this?