diff options
author | Joop Kiefte <ikojba@gmail.com> | 2023-08-09 03:17:38 +0100 |
---|---|---|
committer | Joop Kiefte <ikojba@gmail.com> | 2023-08-09 03:17:38 +0100 |
commit | b47b66288fd08c6d75506a0cfd5b641430a42040 (patch) | |
tree | 7184ab5dfe576851c0c4c8e7b803066019a818e2 | |
parent | aa38edcab665f7604e5f09b65d33156dbc78a3c2 (diff) |
Add tool to package gtfs file from database
-rw-r--r-- | package.bash | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/package.bash b/package.bash new file mode 100644 index 0000000..3b3a2ff --- /dev/null +++ b/package.bash @@ -0,0 +1,5 @@ +#!/bin/bash + +dolt sql -q "show tables;" | grep "| [a-z]" | sed -e 's/[| ]//g' > /tmp/tables_gtfs.txt +for table in `cat /tmp/tables_gtfs.txt`; do dolt table export $table $table.csv; mv $table.csv $table.txt ; done +zip -9 $1 *.txt |