Mercurial > dedupe

annotate scripts/statistics.sh @ 114:d4e337567960

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
112
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
1 #!/bin/bash
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
2
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
3 PREFIX=$1
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
4
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
5
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
6 if [ -n "$PREFIX" ]
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
7 then
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
8 SEDPREFIX=$(echo $PREFIX | sed -e 's/\//\\\//g')
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
9 SQLPREFIX=$(echo $PREFIX | sed -e "s/'/''/g")
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
10
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
11 PREFIX="WHERE path LIKE '${SQLPREFIX}%'"
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
12 fi
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
13
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
14 . $(dirname $0)/STATEMENTS
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
15
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
16 sqlite3 ~/.DeDupe.sqlite "${STATISTICS_STATEMENT}"