- 13 May, 2021 2 commits
-
-
Álex Cortiñas authored
-
Álex Cortiñas authored
Also adding direct links to download it
-
- 12 May, 2021 1 commit
-
-
Álex Cortiñas authored
-
- 17 Jul, 2020 2 commits
-
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
- 16 Jul, 2020 1 commit
-
-
- 17 Jun, 2020 1 commit
-
-
Álex Cortiñas authored
-
- 16 Jun, 2020 3 commits
-
-
Álex Cortiñas authored
* Mostly fixing text escapes on sql queries * Also gettting the date from the new folder format * Also resorting the sql execution order, so cells from outside of galicia are added also.
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
- 21 May, 2020 1 commit
-
-
Álex Cortiñas authored
-
- 20 May, 2020 5 commits
-
-
Miguel R. Luaces authored
-
Álex Cortiñas authored
Resolve "SQL execution does not wait for file creation" Closes #1 See merge request covid/data-importer!1
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
- 19 May, 2020 1 commit
-
-
Miguel R. Luaces authored
-
- 18 May, 2020 9 commits
-
-
Álex Cortiñas authored
First time it executes, it updates the names of the cells
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
* The new parser handles all xls old data except 3 FlujosDestino100+_M1_NOV - Galicia, which requires an specific parser
-
Álex Cortiñas authored
-
Álex Cortiñas authored
The writer is the same than FlujosDestino, just adding on conflict nothing to avoid adding two files with the same data (conflict on pkey)
-
- 15 May, 2020 14 commits
-
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
Otherwise, the files are not created. This could be done in a much better way, using the promises of the parsers, but it is enough for now
-
Álex Cortiñas authored
-
Álex Cortiñas authored
* Getting date from file path * Trim headers and cells of CSVs
-
Álex Cortiñas authored
* It seems that CSVParser can be used with any of the CSV to parse. All the logic is in the writer class. * Method parse now returns a promise since csv-parser is asyncronous. * Now checking partial filename and extension in order to choose parser and writer. * Now using a prefix and the original filePath instead of setting the full sql file name. * Handling encoding of the csv files (ISO-8859-1) in a generic way.
-
Álex Cortiñas authored
-
Álex Cortiñas authored
-
Álex Cortiñas authored
* Apparently the order of the rows is not fixed, running the code in a different computer caused problems
-
Álex Cortiñas authored
* Automatically run the sql files generated * There is a very basic promise queue so sqls are run synced
-
Álex Cortiñas authored
* Using trim to recover texts from excels * Avoiding files with ~$ in name * Updating schema
-
Álex Cortiñas authored
-
Álex Cortiñas authored
* Created sql schema and updated the previous with foreign keys * Adding inserts into celda, they were missing in the previous version * Adding parser and writer for file cod_postal_celdas_movilidad.xlsx
-