Mercurial > dedupe

changeset 97:34f11b2a1178

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Script to extract duplicates directly to the commandline.
author Tom Fredrik Blenning Klaussen <bfg@bfgconsult.no>
date Thu, 13 Feb 2014 14:51:06 +0100
parents c7da835ea912
children a591accb07b5
files scripts/duplicates.sh
diffstat 1 files changed, 10 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/duplicates.sh	Thu Feb 13 14:51:06 2014 +0100
@@ -0,0 +1,10 @@
+#!/bin/bash
+
+PREFIX=$1
+
+if [ -n "$PREFIX" ]
+then
+  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;"