view scripts/statistics.sh @ 114:d4e337567960

Add some debug statements and fix a bug in SQL execution.
author Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
date Tue, 03 May 2016 02:26:39 +0200
parents 3951f6d27219
children
line wrap: on
line source

#!/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}"