- Add simulation and user modules;
- Change config.json.example to use simcaqdb3 instead of simcaqdb1;
- Add routes for simulatio and user module functions.

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

Simobject 20160927

Created  a simulation object and a handful of tests. More tests will be needed, and sanitizing will  strongly depend on the input data format, which is not yet completely defined. A test config.json file was added to allow test database integration, and config.js was adapted to choose config file from context.

Files added:
src/libs/models/simulation.js - mongo schema for simulation;
src/libs/routes/simulation.js - express controller for simulation api.

See merge request !23

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>

- 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.