From 579993610c0af810051f7ea514dadfa6b616c212 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Mon, 25 Jul 2011 17:20:43 +0200
Subject: Add script to identify differences between db and files

---
 checkdb | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)
 create mode 100755 checkdb

diff --git a/checkdb b/checkdb
new file mode 100755
index 0000000..1736776
--- /dev/null
+++ b/checkdb
@@ -0,0 +1,32 @@
+#!/bin/bash
+
+home="$(dirname "${0}")"
+target="${home}/repo"
+lock='/tmp/mirrorsync.lck'
+tmp="$(mktemp -d)"
+
+[ -f "${lock}" ] && exit 1
+touch "${lock}"
+
+trap "rm -rf '${lock}' '${tmp}'" EXIT INT TERM
+
+find "${target}" -xtype f -name '*.db' | sort > "${tmp}/dbs"
+find "${target}" -xtype f -name '*.files' | sed 's/.files/.db/g' | sort > "${tmp}/files"
+
+if ! diff -q "${tmp}/dbs" "${tmp}/files" >/dev/null; then
+	echo "there are db or files missing"
+	diff -u "${tmp}/dbs" "${tmp}/files"
+	exit 1
+fi
+
+for db in $(cat "${tmp}/dbs"); do
+	mkdir "${tmp}/dbdir" "${tmp}/filesdir"
+	bsdtar xf "${db}" -C "${tmp}/dbdir"
+	bsdtar xf "${db/.db/.files}" --exclude '*/files' -C "${tmp}/filesdir"
+	if ! diff -Nrq "${tmp}/dbdir" "${tmp}/filesdir" >/dev/null; then
+		dbname="${db/${target}\//}"
+		diff -Nura --label "${dbname}" "${tmp}/dbdir" --label "${dbname/.db/.files}" "${tmp}/filesdir"
+		echo -e "\n\n"
+	fi
+	rm -rf "${tmp}/dbdir" "${tmp}/filesdir"
+done
-- 
cgit v1.2.3-24-g4f1b