#!/bin/sh

# This a script for restoring the local env-logger database from a backup snapshot.

set -e

if [ $# -ne 2 ]; then
    cat <<EOF
This a script for restoring the local env-logger database from a backup snapshot.

Usage: $0 <DB name> <DB snapshot name>
Example: $0 env_logger db_snapshot.sql
EOF
    exit 1
fi

db_name=$1
snapshot_name=$2

file_out=$(file -ib ${snapshot_name})
if [ $(echo "${file_out}"|grep -c xz) -eq 1 ]; then
    echo "Uncompressed snapshot, decompressing before restore"
    unxz ${snapshot_name}
    snapshot_name=$(echo ${snapshot_name}|sed 's/.xz//')
fi

echo "Truncating tables"
psql "${db_name}" <<EOF
TRUNCATE TABLE users CASCADE;
TRUNCATE TABLE observations CASCADE;
TRUNCATE TABLE yardcam_image;
EOF

echo "Adding new values"
# Pressure data has not been collected from the beginning and thus contains
# NULL values causing restore to fail
psql "${db_name}" -c 'ALTER TABLE weather_data ALTER pressure DROP NOT NULL;'
psql "${db_name}" < "${snapshot_name}"

#!/bin/sh

# This a script for restoring the local env-logger database from a backup snapshot.

set -e

if [ $# -ne 2 ]; then
    cat <<EOF
This a script for restoring the local env-logger database from a backup snapshot.

Usage: $0 <DB name> <DB snapshot name>
Example: $0 env_logger db_snapshot.sql
EOF
    exit 1
fi

db_name=$1
snapshot_name=$2

echo "Truncating tables"
psql "${db_name}" <<EOF
TRUNCATE TABLE users CASCADE;
TRUNCATE TABLE observations CASCADE;
TRUNCATE TABLE yardcam_image;
EOF

echo "Adding new values"
# Pressure data has not been collected from the beginning and thus contains
# NULL values causing restore to fail
psql "${db_name}" -c 'ALTER TABLE weather_data ALTER pressure DROP NOT NULL;'
psql "${db_name}" < "${snapshot_name}"

--- 
+++ 
@@ -17,13 +17,6 @@
 db_name=$1
 snapshot_name=$2
 
-file_out=$(file -ib ${snapshot_name})
-if [ $(echo "${file_out}"|grep -c xz) -eq 1 ]; then
-    echo "Uncompressed snapshot, decompressing before restore"
-    unxz ${snapshot_name}
-    snapshot_name=$(echo ${snapshot_name}|sed 's/.xz//')
-fi
-
 echo "Truncating tables"
 psql "${db_name}" <<EOF
 TRUNCATE TABLE users CASCADE;
Add support for restoring uncompressed DB snapshots
