Refactor enrollments route to include query building

Changes:

• Add error handling in the database query function. When a database error occurs, it is logged in the server and a plain text response is returned to the user.
• Implement building of SQL queries inside the API, which removes the need to have stored functions/procedures on the database, since the former approach is not flexible or efficient to maintain/extend.
• Use route chaining to determine which function will build the query that needs to be executed. The last function is the one that actually sends the query to the database and send the response.

Future Work:

• Instead of returning a plain text response, return a HTTP 501 status, which is currently not possible. When one attempts to send such status the framework throws an error that the headers were already sent for the current request.
• Chaining based on the route might not be the best solution here.

src/libs/routes/state.js

 const express = require('express');
-
-const xml = require('js2xmlparser');
-
 const stateApp = express();
-
 const libs = `${process.cwd()}/libs`;
-
 const log = require(`${libs}/log`)(module);
-
-const dbQuery = require(`${libs}/db/query_exec`);
-
-function response(req, res) {
-    if (req.query.format === 'csv') {
-        res.csv(req.result.data);
-    } else if (req.query.format === 'xml') {
-        res.send(xml('result', JSON.stringify({ state: req.result.data })));
-    } else {
-        res.json({ result: req.result.data });
-    }
-}
+const squel = require('squel');
+const query = require(`${libs}/middlewares/query`);
+const response = require(`${libs}/middlewares/response`);
 
 stateApp.get('/', (req, res, next) => {
-    const stateSql = 'SELECT * FROM estados';
-    dbQuery(stateSql).then((result) => {
-        req.result = result;
-        return response(req, res);
-    }, (error) => {
-        log.error(`[${req.originalUrl}] SQL query error: ${error}`);
-        next('Internal error, request could not be satisfied at this moment. Please, try again later');
-    });
-});
+    req.query = squel.select().from('estados').toParam();
+    next();
+}, query, response);
 
 stateApp.get('/:id', (req, res, next) => {
-    const stateSql = 'SELECT * FROM estados WHERE pk_estado_id = ?';
-    const stateId = parseInt(req.params.id, 10);
-    dbQuery(stateSql, [stateId]).then((result) => {
-        req.result = result;
-        return response(req, res);
-    }, (error) => {
-        log.error(`[${req.originalUrl}] SQL query error: ${error}`);
-        next('Internal error, request could not be satisfied at this moment. Please, try again later');
-    });
-});
+    req.query = squel.select().from('estados').where('pk_estado_id = ?',
+        parseInt(req.params.id, 10)).toParam();
+    next();
+}, query, response);
 
 stateApp.get('/region/:id', (req, res, next) => {
-    const stateSql = 'SELECT * FROM estados WHERE fk_regiao_id = ?';
-    const regionId = parseInt(req.params.id, 10);
-    dbQuery(stateSql, [regionId]).then((result) => {
-        req.result = result;
-        return response(req, res);
-    }, (error) => {
-        log.error(`[${req.originalUrl}] SQL query error: ${error}`);
-        next('Internal error, request could not be satisfied at this moment. Please, try again later');
-    });
-});
+    req.query = squel.select().from('estados').where('fk_regiao_id = ?',
+        parseInt(req.params.id, 10)).toParam();
+    next();
+}, query, response);
 
 module.exports = stateApp;