static async createStudent()

in edu-analytics-be/web/app/entity/studentEntity.js [24:37]

• 13 lines of code
• 3 McCabe index (conditional complexity)

    static async createStudent(body) {
        const sql = `INSERT INTO students (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 students where email='${body.email}';`);
            }
            return err;
        }

    }