Skip to content
Snippets Groups Projects

Refactor enrollments route to include query building

2 files
+ 23
100
Compare changes
  • Side-by-side
  • Inline

Files

var express = require('express')
var xml = require('js2xmlparser')
var router = express.Router()
var squel = require('squel')
var libs = process.cwd() + '/libs/'
var log = require(libs + 'log')(module)
var config = require(libs + 'config')
var conn = require(libs + 'db/monet')
var query = require(libs + 'middlewares/query')
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({city: req.result.data})))
}
else {
res.json({
result: req.result.data
})
}
}
router.get('/', function(req, res, next) {
req.query = squel.select().from('municipios').limit(2).toParam()
next()
}, query, response)
router.get('/:id', function(req, res, next) {
req.query = squel.select().from('municipios').where('pk_municipio_id=?', parseInt(req.params.id, 10)).toParam()
next()
}, query, response)
router.get('/state/:id', function(req, res, next) {
req.query = squel.select().from('municipios').where('fk_estado_id=?', parseInt(req.params.id, 10)).toParam()
next()
}, query, response)
module.exports = router
Loading