#! /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 ))"