Description
User receiving error while using mindsdb js sdk
Slack Thread:https://mindsdbcommunity.slack.com/archives/C01S2T35H18/p1683968010509909
Query executed:
app.get("/status", async function (req, res) {
// Connect to MindsDB Cloud service
const userEmail = process.env.MINDSDB_USER_EMAIL;
const userPassword = process.env.MINDSDB_USER_PASSWORD;
try {
await MindsDB.default.connect({
user: userEmail,
password: userPassword,
});
const {
gender,
ssc_percentage,
hsc_percentage,
degree_percentage,
emp_test_percentage,
ssc_board,
hsc_board,
hsc_subject,
undergrad_degree,
work_experience,
specialisation,
} = req.query;
const query = SELECT status FROM mindsdb.job_placement_status_predictor WHERE gender=${gender} AND ssc_percentage=${ssc_percentage} AND hsc_percentage=${hsc_percentage} AND degree_percentage=${degree_percentage} AND emp_test_percentage=${emp_test_percentage} AND ssc_board=${ssc_board} AND hsc_board=${hsc_board} AND hsc_subject=${hsc_subject} AND undergrad_degree=${undergrad_degree} AND work_experience=${work_experience} AND specialisation=${specialisation}
;
const repsonse = await MindsDB.SQL.runQuery(query);
if (queryResult.rows.length > 0) {
console.log(repsonse);
res.send(repsonse);
}
} catch (error) {
console.log(error);
res.json({ Error: error });
}
});