Skip to content
Snippets Groups Projects
  1. Jan 27, 2017
  2. Jan 18, 2017
  3. Jan 17, 2017
  4. Jan 10, 2017
  5. Dec 09, 2016
  6. Dec 05, 2016
  7. Dec 02, 2016
  8. Nov 30, 2016
  9. Nov 22, 2016
  10. Nov 09, 2016
  11. Nov 08, 2016
  12. Nov 07, 2016
  13. Nov 04, 2016
  14. Nov 01, 2016
  15. Oct 25, 2016
  16. Oct 24, 2016
    • João Victor Tozatti Risso's avatar
      Migrate API to v2 database schema · d38e8612
      João Victor Tozatti Risso authored
      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
    • Lucas Gabriel Lima's avatar
      add some tests for user (wip) · 4753e07e
      Lucas Gabriel Lima authored
      4753e07e
  17. Oct 18, 2016
  18. Oct 14, 2016
  19. Oct 10, 2016
  20. Oct 07, 2016
  21. Oct 05, 2016
  22. Oct 04, 2016
  23. Oct 03, 2016
  24. Sep 29, 2016
  25. Sep 22, 2016
  26. Sep 05, 2016
  27. Sep 02, 2016
  28. Aug 17, 2016
    • João Victor Risso's avatar
      Change API to use ECMAScript6 · 00a87dec
      João Victor Risso authored
      
      Major modifications:
      - Source code is now in the src directory
      - All source files were adapted to ECMAScript6
      - Add Gulpfile and Babel to transcompile the project from ES6 to ES5 (until Node.js fully supports ES6)
      	- By running gulp one generates the build directory with the files transcompiled, from which the API can be run
      - Add ESLint to check for syntax errors and enforce code standards
      	- Javascript coding standard currently adopted is AirBnB with 4 spaces
      - Replace monetdb package with monetdb-pool, which allows for concurrent queries over a pool of connections while maintaining the same interface
      
      TODO (in order of priority, from high to low):
      - Add Gulp tasks to handle automatic building, tests and running the server in order to deprecate using npm
      - Implement decorator to execute the SQL queries and reduce code duplication.
      - Implement SQL query builder (e.g. squel.js) to erradicate the need for embedding SQL directly into the code (which is error-prone).
      - Change enrollments route not to use route chaining in order to decide which SQL query is appropriate to respond the user's request.
      - Implement decorator for API responses and also reduce code duplication.
      - Split up tests into and add more test cases.
      
      Signed-off-by: João Victor Risso's avatarJoão Victor Risso <jvtr12@c3sl.ufpr.br>
      00a87dec
Loading