Skip to content
Snippets Groups Projects
  1. Oct 19, 2018
  2. Oct 02, 2018
  3. Oct 01, 2018
  4. Sep 14, 2018
  5. Jul 26, 2018
  6. Jul 03, 2018
  7. Jun 21, 2018
  8. Jun 20, 2018
  9. Mar 26, 2018
  10. Jan 31, 2018
  11. Jan 26, 2018
  12. Jan 18, 2018
  13. Oct 26, 2017
  14. Oct 09, 2017
  15. Sep 28, 2017
  16. Sep 27, 2017
  17. Sep 25, 2017
  18. Aug 29, 2017
  19. Aug 11, 2017
  20. Aug 10, 2017
  21. Jul 25, 2017
  22. Jul 11, 2017
  23. Jul 03, 2017
  24. Apr 26, 2017
  25. Apr 25, 2017
  26. Apr 19, 2017
  27. Apr 18, 2017
  28. Mar 30, 2017
  29. Mar 29, 2017
  30. Mar 24, 2017
  31. Mar 07, 2017
  32. Feb 20, 2017
  33. Feb 01, 2017
  34. Jan 10, 2017
  35. Dec 09, 2016
  36. 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
Loading