Skip to content
Snippets Groups Projects
  1. Jan 30, 2024
  2. Jan 29, 2024
  3. Jan 17, 2024
  4. Jan 15, 2024
  5. Jan 12, 2024
  6. Jan 11, 2024
  7. Dec 13, 2023
  8. Nov 27, 2023
  9. Jul 07, 2023
  10. Mar 03, 2023
  11. Sep 29, 2022
  12. Sep 23, 2022
  13. Aug 12, 2022
  14. Aug 11, 2022
  15. May 20, 2020
  16. Apr 09, 2020
  17. Jun 25, 2019
  18. Oct 09, 2017
  19. Aug 11, 2017
  20. Aug 10, 2017
  21. Mar 07, 2017
  22. Feb 20, 2017
  23. Feb 02, 2017
  24. Jan 18, 2017
  25. Jan 10, 2017
  26. Dec 09, 2016
  27. 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