dump_db

#!/bin/bash

dir=$(dirname "$0")
# shellcheck disable=SC1091
. "$dir/func_defs"

check_vars


dump_file="data/twittelection_dump.sql"

echo Dumping database
echo ".tables" | sqlite3 "$TE_DB_FILE" | while read table; do echo "DROP TABLE IF EXISTS $table;"; done > "$dump_file"
echo ".dump" | sqlite3 "$TE_DB_FILE" >> "$dump_file"