Mercurial > dedupe

comparison scripts/duplicates.sh @ 103:6b997f4f7e19

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Support for directly selecting subfolder.
author Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
date Sat, 15 Feb 2014 13:32:46 +0100
parents 34f11b2a1178
children bae09ef524cb
comparison
equal deleted inserted replaced
102:5906661c0421 103:6b997f4f7e19
5 if [ -n "$PREFIX" ] 5 if [ -n "$PREFIX" ]
6 then 6 then
7 PREFIX="WHERE path LIKE '${PREFIX}%'" 7 PREFIX="WHERE path LIKE '${PREFIX}%'"
8 fi 8 fi
9 9
10 sqlite3 ~/.DeDupe.sqlite "SELECT hex(checksum),path FROM (SELECT * FROM files WHERE checksum IN (SELECT checksum FROM (SELECT checksum, COUNT(*) as num FROM files ${PREFIX} GROUP BY checksum) WHERE num >= 2)) ${PREFIX} ORDER BY size;" 10 sqlite3 ~/.DeDupe.sqlite "SELECT hex(checksum),size,path FROM (SELECT * FROM files WHERE checksum IN (SELECT checksum FROM (SELECT checksum, COUNT(*) as num FROM files ${PREFIX} GROUP BY checksum) WHERE num >= 2)) ${PREFIX} ORDER BY size;"