From e3dd6bdf4e171b825ff11ac62b980d7d04ebbdd2 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 11 Jan 2018 18:52:31 +0000 Subject: [PATCH] share/db/update.sh --- share/db/update.sh | 15 ++------------- 1 file changed, 2 insertions(+), 13 deletions(-) diff --git a/share/db/update.sh b/share/db/update.sh index 7fe23157..62035681 100755 --- a/share/db/update.sh +++ b/share/db/update.sh @@ -12,19 +12,8 @@ cd "$DIR" main() { ( -cat << EOF -.separator \t - -`update_csv timezone` -`update_csv country` - -`echo Run sql 1>&2 && cat *.sql` - -`./port > "$TMP/port.csv" && csv2table port "$TMP/port.csv"` -`./shell_function` - -VACUUM; -EOF +$(dbq f=txt a=db.sql db-type=sqlite db=pub 'table-name=!~^(zipcode|geo)') +$(echo "VACUUM;") ) | sqlite3 "nb.db" -- 2.47.3