--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/dircompare.sh	Tue May 03 02:20:07 2016 +0200
@@ -0,0 +1,34 @@
+#!/bin/bash
+
+PREFIX=$1
+
+
+if [ -n "$PREFIX" ]
+then
+  SEDPREFIX=$(echo $PREFIX | sed -e 's/\//\\\//g')
+  SQLPREFIX=$(echo $PREFIX | sed -e "s/'/''/g")
+
+  PREFIX="WHERE path LIKE '${SQLPREFIX}%'"
+fi
+
+. $(dirname $0)/STATEMENTS
+
+error=0
+
+RES=$(sqlite3 ~/.DeDupe.sqlite "SELECT path FROM files WHERE path LIKE '$2%' AND ( checksum NOT IN (SELECT checksum FROM files WHERE path LIKE '$1%' AND checksum IS NOT NULL) OR checksum IS NULL) ;")
+if [ -n "${RES}" ]
+then
+    echo "Not in $1" 
+    error=1
+    echo ${RES}
+fi
+RES=$(sqlite3 ~/.DeDupe.sqlite "SELECT path FROM files WHERE path LIKE '$1%' AND ( checksum NOT IN (SELECT checksum FROM files WHERE path LIKE '$2%' AND checksum IS NOT NULL) OR checksum IS NULL) ;")
+if [ -n "${RES}" ]
+then
+    echo "Not in $2" 
+    error=1
+    echo "${RES}"
+fi
+
+
+exit $error