Skip to content
Snippets Groups Projects

add mesoregion and microregion filters

Merged Pietro Cavassin requested to merge meso_micro_filters into dev
3 files
+ 31
24
Compare changes
  • Side-by-side
  • Inline
Files
3
+ 0
22
@@ -115,27 +115,5 @@ cityApp.get('/', rqf.parse(), rqf.build(), (req, res, next) => {
next();
}, query, response('city'));
cityApp.get('/microregion', rqf.parse(), rqf.build(), (req, res, next) => {
req.sql.from('municipio')
.field('municipio.estado_id', 'state_id')
.field('municipio.microrregiao_id', 'microregion_id')
.field('municipio.nome_microrregiao', 'microregion_name')
.group('municipio.estado_id')
.group('municipio.microrregiao_id')
.group('municipio.nome_microrregiao')
next();
}, query, response('city/microregion'));
cityApp.get('/mesoregion', rqf.parse(), rqf.build(), (req, res, next) => {
req.sql.from('municipio')
.field('municipio.estado_id', 'state_id')
.field('municipio.mesorregiao_id', 'mesoregion_id')
.field('municipio.nome_mesorregiao', 'mesoregion_name')
.group('municipio.nome_mesorregiao')
.group('municipio.mesorregiao_id')
.group('municipio.estado_id')
next();
}, query, response('city/mesoregion'));
module.exports = cityApp;
Loading