From ea279fddcc662e19f7328c1a134ce0be3db92a9e Mon Sep 17 00:00:00 2001
From: Mark Wooding <mdw@distorted.org.uk>
Date: Fri, 7 Jun 2024 23:22:15 +0100
Subject: [PATCH] track-boxing-progress: Script I used to track the boxing job.

---
 track-boxing-progress | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100755 track-boxing-progress

diff --git a/track-boxing-progress b/track-boxing-progress
new file mode 100755
index 0000000..2ffcbb6
--- /dev/null
+++ b/track-boxing-progress
@@ -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
-- 
2.11.0