]> apps.delaporte.us Git - matrix-cadbury.git/commitdiff
Check backups
authorEdward Delaporte <edward@delaporte.us>
Wed, 8 Apr 2026 01:51:51 +0000 (20:51 -0500)
committerEdward Delaporte <edward@delaporte.us>
Wed, 8 Apr 2026 01:51:51 +0000 (20:51 -0500)
service/backup.sh
service/check_db.sh [new file with mode: 0755]

index 7dd175343eb59119909a89c81a49da55d8a647d6..48d01c3d4667378785de409fec1af53113585b08 100755 (executable)
@@ -6,3 +6,9 @@ mkdir -p $INSTALL_DIR/backups
 cp $INSTALL_DIR/*.db $INSTALL_DIR/backups
 # Resume Cadbury
 systemctl start cadbury
+
+# Verify Backups
+$INSTALL_DIR/service/check_db.sh $INSTALL_DIR/backups/chore.db
+$INSTALL_DIR/service/check_db.sh $INSTALL_DIR/backups/goals.db
+$INSTALL_DIR/service/check_db.sh $INSTALL_DIR/backups/school.db
+$INSTALL_DIR/service/check_db.sh $INSTALL_DIR/backups/shop.db
diff --git a/service/check_db.sh b/service/check_db.sh
new file mode 100755 (executable)
index 0000000..9085ec4
--- /dev/null
@@ -0,0 +1,3 @@
+echo "Checking DB file $1"
+echo "PRAGMA quick_check;" | sqlite3 $1
+ls -h $1