summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJoop Kiefte <ikojba@gmail.com>2023-08-09 03:17:38 +0100
committerJoop Kiefte <ikojba@gmail.com>2023-08-09 03:17:38 +0100
commitb47b66288fd08c6d75506a0cfd5b641430a42040 (patch)
tree7184ab5dfe576851c0c4c8e7b803066019a818e2
parentaa38edcab665f7604e5f09b65d33156dbc78a3c2 (diff)
Add tool to package gtfs file from database
-rw-r--r--package.bash5
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