Mercurial > dedupe
diff scripts/duplicates.sh @ 103:6b997f4f7e19
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 |
line wrap: on
line diff
--- a/scripts/duplicates.sh Thu Feb 13 15:20:37 2014 +0100 +++ b/scripts/duplicates.sh Sat Feb 15 13:32:46 2014 +0100 @@ -7,4 +7,4 @@ PREFIX="WHERE path LIKE '${PREFIX}%'" fi -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;" +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;"