Commits · d38e8612abf0f3d49981acaed1f5e35d6896dbbd · simcaq / simcaq-node

Oct 24, 2016

Migrate API to v2 database schema · d38e8612

João Victor Tozatti Risso authored 8 years ago

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.

d38e8612

Oct 14, 2016
- Add sanitize function in enrollment · a4b024d2
  Vytor Calixto authored 8 years ago
  
  Sanitize the location in the result
  a4b024d2
- Query middleware throws error on empty result · 55b92b7b
  Vytor Calixto authored 8 years ago
  
  55b92b7b
- Add result when Monet returns empty array · 080d4598
  Vytor Calixto authored 8 years ago
  
  080d4598
Oct 07, 2016
- Use res.attachment to change csv name · bdd3941b
  Vytor Calixto authored 8 years ago
  
  Closes simcaq/SCRUM#42
  bdd3941b
Oct 04, 2016
- Set test coverage threshold at 80% · 7250b792
  Vytor Calixto authored 8 years ago
  
  7250b792
- Add more test cases · e6c24d65
  Vytor Calixto authored 8 years ago
  
  e6c24d65
- Fix query build with schools · d27e2c3d
  Vytor Calixto authored 8 years ago
  
  d27e2c3d
Oct 03, 2016
- Change debug log level · ca57500a
  Vytor Calixto authored 8 years ago
  
  ca57500a
- Add monog_uri and mongo service do CI · 9d7f83e2
  Vytor Calixto authored 8 years ago
  
  9d7f83e2
Sep 29, 2016
- Fixed gulp test rule: chdir to build to test · a061894e
  Vytor Calixto authored 8 years ago
  
  Related: simcaq/SCRUM#68
  a061894e
- Revert "resolve conflicts" · 674d9959
  Lucas Gabriel Lima authored 8 years ago
  
  This reverts commit bfe64623, reversing changes made to 9c8cfa58.
  674d9959
Sep 28, 2016
- small fix · c8b441a7
  Lucas Gabriel Lima authored 8 years ago
  
  c8b441a7
- refactor user route · c0e9561c
  Lucas Gabriel Lima authored 8 years ago
  
  c0e9561c
- Add `next()` to middleware that injects squel · 091d3910
  Vytor Calixto authored 8 years ago
  
  Related: simcaq/SCRUM#18
  091d3910
Sep 27, 2016
- Generic filters and dimensions in enrollments · c6629a57
  Vytor Calixto authored 8 years ago
  
  Related: simcaq/SCRUM#18
  c6629a57
- add email syntax auth before saving user · 1a5d1440
  Lucas Gabriel Lima authored 8 years ago
  
  1a5d1440
- add user authentication route and JSON Web Token response · 3b6364f4
  Lucas Gabriel Lima authored 8 years ago
  
  3b6364f4
- remove debug log · 38be8455
  Lucas Gabriel Lima authored 8 years ago
  
  38be8455
- fix identation · 5f5f85fe
  Lucas Gabriel Lima authored 8 years ago
  
  5f5f85fe
- .toParam is now called by query middleware · eb8c333c
  Vytor Calixto authored 8 years ago
  
  Also the req.sql attribute is being created ("injected") before all routes Related: simcaq/SCRUM#18
  eb8c333c
Sep 26, 2016
- rename signup route to user · b247c029
  Lucas Gabriel Lima authored 8 years ago
  
  b247c029
- fix identation · 72365ac9
  Lucas Gabriel Lima authored 8 years ago
  
  72365ac9
Sep 23, 2016
- Add size attribute to object generated in parseParams · 366917bf
  Vytor Calixto authored 8 years ago
  
  Related: simcaq/SCRUM#18
  366917bf
- small fix · 6cfde611
  Lucas Gabriel Lima authored 8 years ago
  
  6cfde611
- import user model to signup route · 8218ef16
  Lucas Gabriel Lima authored 8 years ago
  
  8218ef16
- fix error in user model · 9b106f33
  Lucas Gabriel Lima authored 8 years ago
  
  9b106f33
Sep 22, 2016
- Changed express apps for routers · 59d56cb2
  Rudolf Copi Eckelberg authored 8 years ago
  
  Changing apps to follow suggested practices from documentation and centralizing prefix /api/v1 in the app module.
  59d56cb2
- fixed test routes · 51fb52a0
  Rudolf Copi Eckelberg authored 8 years ago
  
  51fb52a0
Sep 21, 2016
- fix mongoose promise error · 656deba9
  Lucas Gabriel Lima authored 8 years ago
  
  656deba9
- Fix bug with debug mode in log.js · 1b8d0646
  Vytor Calixto authored 8 years ago
  
  1b8d0646
- Add libs const to app.js · 52dded92
  Vytor Calixto authored 8 years ago
  
  52dded92
- Change dimensions middleware to parseParams mw · 1d54fe24
  Vytor Calixto authored 8 years ago
  
  Related: simcaq/SCRUM#18
  1d54fe24
- export signup app · 4d904309
  Lucas Gabriel Lima authored 8 years ago
  
  4d904309
Sep 20, 2016
- update user model · 49ae11bc
  Lucas Gabriel Lima authored 8 years ago
  
  49ae11bc
- Change jsdoc to Docco · cd64fcb6
  Vytor Calixto authored 8 years ago
  
  cd64fcb6
- update to new notation · 2edc680e
  Lucas Gabriel Lima authored 8 years ago
  
  2edc680e
- small fix on signup route · f4aba176
  Lucas Gabriel Lima authored 8 years ago
  
  f4aba176
- add signup route to api · e74b5e6a
  Lucas Gabriel Lima authored 8 years ago
  
  e74b5e6a
- add function to retrieve jwt from requests · 9adc7e56
  Lucas Gabriel Lima authored 8 years ago
  
  9adc7e56