import_db

#!/bin/bash
set -euo pipefail
cd "$(dirname "${BASH_SOURCE[0]}")" || exit

echo "This will DELETE your local database!"
echo -n "Continue? [yN] "
read -r ans
if ! [[ $ans = y || $ans = Y ]]; then
	exit 1
fi

rm -f db.sqlite3
./manage.py migrate

echo
echo "Dumping and downloading production database..."

fixture=$(mktemp --suffix .json)

ssh ubuntu@fredagscafeen.dk 'docker exec web_app_1 ./manage.py dumpdata --natural-foreign --exclude auth.permission --exclude contenttypes --exclude admin.logentry | tail -n1' > "$fixture"

echo "Importing production database..."
echo
./manage.py loaddata "$fixture"

rm -f "$fixture"