Refactoring Task : Move the Database Logic code to DAO file ( user.dao.js )

     const pool = require('../config/database')

    class UserDAO {

        async findAll(){
            const result = await pool.query("select * from users");    
            return result[0];
        }

        async save(user){
            let params = [ user.name, user.email, user.password, user.role];
            const result = await pool.query("insert into users (name,email,password,role) values ( ?,?,?,?)", params);    
            return result[0].insertId; 
        }
    }

    exports.UserDAO = UserDAO;

router.js

    const {UserDAO} = require("./user.dao");
    const userDAO = new UserDAO();

    router.get('/users', userDAO.findAll);
    router.post('/users', userDAO.save);