--- /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