hpr-tools/feed_watcher/db_regen

15 lines
239 B
Bash
Executable File

#!/bin/bash
#
# Make a new empty database using the schema file
#
BASEDIR="$HOME/HPR/feed_watcher"
DB="$BASEDIR/feedWatcher.db"
SCHEMA="$BASEDIR/feedWatcher_schema.sql"
if [[ -e $DB ]]; then
rm -f "$DB"
fi
sqlite3 "$DB" < "$SCHEMA"