From ea279fddcc662e19f7328c1a134ce0be3db92a9e Mon Sep 17 00:00:00 2001 From: Mark Wooding 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