track-boxing-progress: Script I used to track the boxing job. master
authorMark Wooding <mdw@distorted.org.uk>
Fri, 7 Jun 2024 22:22:15 +0000 (23:22 +0100)
committerMark Wooding <mdw@distorted.org.uk>
Fri, 7 Jun 2024 22:22:15 +0000 (23:22 +0100)
track-boxing-progress [new file with mode: 0755]

diff --git a/track-boxing-progress b/track-boxing-progress
new file mode 100755 (executable)
index 0000000..2ffcbb6
--- /dev/null
@@ -0,0 +1,14 @@
+#! /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