diff scripts/statistics.sh @ 112:3951f6d27219

Add various useful scripts. Refactor out SQL-statements.
author Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
date Tue, 03 May 2016 02:20:07 +0200
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/statistics.sh	Tue May 03 02:20:07 2016 +0200
@@ -0,0 +1,16 @@
+#!/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
+
+sqlite3 ~/.DeDupe.sqlite "${STATISTICS_STATEMENT}"