./update PATHS
./report >PATHS.new
-if cmp -s PATHS.new PATHS; then rm PATHS.new
+if diff -u PATHS PATHS.new; then rm PATHS.new
else mv PATHS.new PATHS; fi
my $paths = $set_path{$name};
my @unk;
set_box $box{$paths->[0]};
- while (@iso && $iso[0] lt $paths->[0]) { push @unk, shift @iso; }
- if (@unk) {
- print "[#UNK: *]\n";
- for my $path (@unk) { print "\t", $path, "\n"; }
- }
printf "[#%d: %d] %s\n", $set_id{$name}, scalar @$paths, $name;
my $i = 0;
for my $path (@$paths) {
--- /dev/null
+#! /bin/sh -e
+
+set -- $(psql -At -F" " -hroadstar -c '
+ SELECT * FROM
+ (SELECT COUNT(*) FROM dvd_disc) AS ndisc,
+ (SELECT COUNT(*) FROM dvd_disc WHERE box IS NOT NULL) AS nboxed,
+ (SELECT COUNT(*) FROM
+ (SELECT DISTINCT box FROM dvd_disc
+ WHERE box IS NOT NULL) AS q)
+ AS nbox;
+'); ndisc=$1 nboxed=$2 nbox=$3
+
+echo "DONE $nboxed/$ndisc = $(( (100*$nboxed + $ndisc/2)/$ndisc ))%"
+echo "BOXES $nbox + $(( (($ndisc - $nboxed)*$nbox + $nboxed - 1)/$nboxed ))"
\ No newline at end of file