Script to generate a PostgreSQL schema from GTFS #3
Conversation
The script acts on a directory with the extracted contents of a GTFS file. It checks which files are present and prepares one table for each of them. Then it checks which columns are present and in which order and generates a column defintiion for each of them. Finally, the contents of the CSV files are imported into the database using PostgreSQL's \COPY mode.
|
This seems fantastic @hfs! Is there a bash version requirement? I am running the following command on where I receive the following errors: |
|
Yes, the script requires bash version >= 4. Do you have the option of installing bash 4 as additional package via e.g. Homebrew or Macports? I could add a version check with an explanation at the top of the script if you want? Alternatively I could try to rewrite it using only bash 3, but then the script would become quite ugly. |
|
Got it! I was able to confirm functionality using bash 5.0 in the image from Dockerhub. Very cool! 🙌 I don't think we need a version check in the script. Want to just throw the version requirement into the README and this will be good to go? |
|
Sure, I added a note to the README |
This implements the idea already mentioned in the README.md: Write a script to generate a schema based on the contents of an actual GTFS file.
The bash script acts on a directory with the extracted contents of a GTFS file. It checks which files are present and prepares one table for each of them. Then it checks which columns are present and in which order and generates a column defintiion for each of them. Finally, the contents of the CSV files are imported into the database using PostgreSQL's \COPY mode.
Closes #1