Mercurial > dedupe
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}"
