Mercurial > dedupe

annotate scripts/dircompare.sh @ 115:404795616b1e default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added a lot of common files to ignore
author Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
date Sat, 25 Mar 2017 17:43:57 +0100
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 error=0
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
17
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
18 RES=$(sqlite3 ~/.DeDupe.sqlite "SELECT path FROM files WHERE path LIKE '$2%' AND ( checksum NOT IN (SELECT checksum FROM files WHERE path LIKE '$1%' AND checksum IS NOT NULL) OR checksum IS NULL) ;")
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
19 if [ -n "${RES}" ]
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
20 then
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
21 echo "Not in $1"
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
22 error=1
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
23 echo ${RES}
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
24 fi
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
25 RES=$(sqlite3 ~/.DeDupe.sqlite "SELECT path FROM files WHERE path LIKE '$1%' AND ( checksum NOT IN (SELECT checksum FROM files WHERE path LIKE '$2%' AND checksum IS NOT NULL) OR checksum IS NULL) ;")
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
26 if [ -n "${RES}" ]
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
27 then
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
28 echo "Not in $2"
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
29 error=1
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
30 echo "${RES}"
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
31 fi
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
32
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
33
3951f6d27219 Add various useful scripts. Refactor out SQL-statements.
Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
parents:
diff changeset
34 exit $error