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