From d26d68941e97215b1d62524c55aa06a4dafb384e Mon Sep 17 00:00:00 2001
From: Edward Delaporte <edward@delaporte.us>
Date: Tue, 7 Apr 2026 20:51:51 -0500
Subject: [PATCH 1/1] Check backups

---
 service/backup.sh   | 6 ++++++
 service/check_db.sh | 3 +++
 2 files changed, 9 insertions(+)
 create mode 100755 service/check_db.sh

diff --git a/service/backup.sh b/service/backup.sh
index 7dd1753..48d01c3 100755
--- a/service/backup.sh
+++ b/service/backup.sh
@@ -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
index 0000000..9085ec4
--- /dev/null
+++ b/service/check_db.sh
@@ -0,0 +1,3 @@
+echo "Checking DB file $1"
+echo "PRAGMA quick_check;" | sqlite3 $1
+ls -h $1
-- 
2.47.3