author | František Kučera <franta-hg@frantovo.cz> |
Sat, 08 May 2021 21:33:15 +0200 | |
branch | v_0 |
changeset 322 | 060d2590e77c |
parent 294 | abbc9bcfbcc4 |
permissions | -rwxr-xr-x |
#!/bin/bash findFiles() { find /bin/ -print0; } fetchAttributes() { relpipe-in-filesystem \ --parallel 4 \ --file path \ --file type \ --file size \ --streamlet hash; } aggregate() { relpipe-tr-sql \ --relation "file_hashes" \ "SELECT path, type, size, sha256, count(*) OVER (PARTITION BY sha256) AS same_hash_count FROM filesystem ORDER BY same_hash_count, sha256, path, type"; } findFiles | fetchAttributes | aggregate | relpipe-out-tabular