Task 1: Create DAO Method ( user.dao.js)

    async login(email,password) {
         let params = [email,password];
         let result =  await pool.query("select id,name,email,role from users where email = ? and password = ?",params);    
        return result[0];
  }

Task 2: Create Controller method (user.controller.js)

    async login(req,res){
        let {email,password} = req.body;        
        const userDAO = new UserDAO();
        const users = await userDAO.login(email,password);
        if (users.length ==0){
            throw new Error("Invalid Login Credentials");
          }
        res.status(201).json(users[0]);
    }

Task 3: Create Schema for login request (user.schema.validator.js)

    async loginSchema(req,res,next){
        const schema = Joi.object({
            email: Joi.string().email().required(),
            password: Joi.string().required()
        });

        try{
            let result = await schema.validateAsync(req.body, options);
            console.log("Result:", result);
            next();
        }
        catch(error){    
           this.handleError(error, res);
        }
    } 

Task 4: Add Router entry ( user.router.js)

    router.post('/login', userSchemaValidator.loginSchema, userController.login);