in edu-analytics-be/web/app/entity/educatorEntity.js [104:117]
static async createEducator(body) {
const sql = `INSERT INTO educators (email,firstName,lastName) VALUES ('${body.email}','${body.firstName}','${body.lastName}');`;
console.log(sql);
try {
const data = await query(sql);
return data;
} catch (err) {
if (err.code === 'ER_DUP_ENTRY') {
return await query(`SELECT * FROM educators where email='${body.email}';`);
}
return err;
}
}