#!/bin/bash

DATABASE=${1:-${DEFAULT_URL}}
SECS=3

read -p "This is the SQLite3 database path ([Ctrl-C] to abort): ${DATABASE}" yes_no


FILES=$(ls -1 sql/*.sql)
if [ "$?" -ne "0" ]; then
	echo "No SQL Files to process. Exiting."
	exit 0
fi

if ! test -d sql/processed; then
  mkdir -p sql/processed
fi

for FILE in $FILES
do
	echo "sqlite3 ${DATABASE} < ${FILE}"
	nice -n 19 ionice -c3 /usr/bin/time --format='%C took %e seconds' sqlite3 ${DATABASE} < ${FILE}
	mv ${FILE} sql/processed || exit 255
	sleep ${SECS}
done

echo "Processing database ${DATABASE} ended!"
