Skip to content
Snippets Groups Projects

Issue/403

Merged Gabriel Ruschel requested to merge issue/403 into master
2 files
+ 4
2
Compare changes
  • Side-by-side
  • Inline
Files
2
+ 0
2
@@ -36,14 +36,12 @@ schoolApp.get('/year_range', cache('15 day'), (req, res, next) => {
@@ -36,14 +36,12 @@ schoolApp.get('/year_range', cache('15 day'), (req, res, next) => {
req.sql.from('escola')
req.sql.from('escola')
.field('MIN(escola.ano_censo)', 'start_year')
.field('MIN(escola.ano_censo)', 'start_year')
.field('MAX(escola.ano_censo)', 'end_year')
.field('MAX(escola.ano_censo)', 'end_year')
.where('escola.ano_censo > 2014');
next();
next();
}, query, response('range'));
}, query, response('range'));
schoolApp.get('/years', cache('15 day'), (req, res, next) => {
schoolApp.get('/years', cache('15 day'), (req, res, next) => {
req.sql.from('escola').
req.sql.from('escola').
field('DISTINCT escola.ano_censo', 'year')
field('DISTINCT escola.ano_censo', 'year')
.where('escola.ano_censo > 2014');
next();
next();
}, query, response('years'));
}, query, response('years'));
Loading