# HG changeset patch # User Tom Fredrik Blenning Klaussen # Date 1392467566 -3600 # Node ID 6b997f4f7e19a7b9a4e446217513378ea3ef38a5 # Parent 5906661c04214f6daf3e8c70294c30b2ca2a915f Support for directly selecting subfolder. diff -r 5906661c0421 -r 6b997f4f7e19 scripts/duplicates.sh --- 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;"