I am using sequelize as below:
function runquery() {
try {
return
`MY_JOIN_QUERY`;
} catch (err) {
console.log("Error: " + err.statusCode + " : " + err);
}
}
let options = {
type: sequelize.QueryTypes.SELECT,
hasJoin: true
};
async function myfunc(request, response) {
try {
const rows = await sequelize.query(runquery(), options);
} catch (err) {
console.log("Error: " + err.statusCode + " : " + err);
}
}
Gettig below error
TypeError: Cannot read property 'trim' of undefined
at node_modules\sequelize\lib\sequelize.js:601:17
at tryCatcher (node_modules\bluebird\js\release\util.js:16:23)
at Function.Promise.attempt.Promise.try (node_modules\bluebird\js\release\method.js:39:29)
at Sequelize.query (node_modules\sequelize\lib\sequelize.js:580:23)
at preHandlerCallback (node_modules\fastify\lib\handleRequest.js:111:30)
at preValidationCallback (node_modules\fastify\lib\route.js:364:7)
at Router.lookup (node_modules\find-my-way\index.js:354:14)
at Server.emit (events.js:400:28)
at parserOnIncoming (_http_server.js:900:12)
at HTTPParser.parserOnHeadersComplete (_http_common.js:127:17)