Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

- Add /location/educational/school_level route to query enrollments per school level;
- Add basic test case for the route. For now, it only checks if the format of the response is the expected one.

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Merge branch '71-simcaq-implementar-backend-uc201-selecionar-localidade' of gitlab.c3sl.ufpr.br:simcaq/simcaq-node into 71-simcaq-implementar-backend-uc201-selecionar-localidade

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

- Change database hostname to simcaqdb3 in config.json.example

# Conflicts:
#   config.json.example

* Segregate test files for each route
* Fix test cases to account for the new database schema

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

* Move concurrent query execution into dbExecAll function
* Add custom response formatting through route labels. For each query in the set, there is an associated label, which will then be used to identify the corresponding result in the response JSON object. For example:
	- labels = [ "a", "b" ]
	- querySet = [ squel.select().from('y'), squel.select().from('x') ]
	- response = { "result" : { "a" : { // result for query a }, "b" : { //result for query b } }

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

Signed-off-by: João Victor Risso <joaovictor.risso@gmail.com>

- Change id_localizacao to tipo_localizacao when querying escola (school) table
- Add missing condition for querying escola table, which is tuples that have id_tipo_turma = 0, according to the use case.

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Signed-off-by: João Victor Tozatti Risso <jvtr12@inf.ufpr.br>

Change SQL queries in the following routes:

* city
* state
* region
* school
* enrollment

Also, change tests to reflect the new schema where appropriate. Specially in the case of cities, the primary key now becomes pk_cod_ibge (city IBGE code) and, therefore, any query that relies on the city id should use this value instead of the old primary key.

Aliases of fields that have different names were added to ensure compatibility with the UI of LDE.

Please refer to the database repository in order to understand how the current schema works. The corresponding ER diagram can be located there.

Sanitize the location in the result

Use res.attachment to change csv name

Closes simcaq/SCRUM#42

See merge request !24

Closes simcaq/SCRUM#42