From b47b66288fd08c6d75506a0cfd5b641430a42040 Mon Sep 17 00:00:00 2001 From: Joop Kiefte Date: Wed, 9 Aug 2023 03:17:38 +0100 Subject: Add tool to package gtfs file from database --- package.bash | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 package.bash 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 -- cgit v1.2.3-70-g09d2