rummy

#!/usr/bin/env bash
#
#  Synopsis:
#	Find all blobs with known unknowns, defaulting to all schemas
#  Usage:
#	$ rummy | cut -f2 | xargs bio-file
#
#	$ rummy
#	libxml2\tsha:01871af3ae0a6af9096c3155c5741453b8eb83b8
#	jsonorg\tsha:fef573f2fd3c76002e71f048c120abc0e0a3965f
#
#	$ rummy | cut -f2 | sort -u
#

PROG=$(basename $0)
trap '' PIPE

die()
{
	echo "$PROG: ERROR: $@" >&2
	exit 1
}

test -n "$SETSPACE_ROOT" || die "env variable not defined: SETSPACE_ROOT"
cd $SETSPACE_ROOT || die "cd $SETSPACE_ROOT failed"

psql_rummy()
{
	local SCH;
	SCH=$1

	psql -c "SELECT blob FROM $SCH.rummy;"				\
		--tuples-only						\
		--no-psqlrc						\
		--quiet							|
	  sed '/^ *$/d'							|
	  sed 's/ //g'							|
	  sed "s/.*/$SCH	&/"
	STATUS=${PIPESTATUS[*]}

	test "$STATUS" = '0 0 0 0'					||
		die "psql rummy $SQL | sed failed: exit status=$STATUS"
}

if [ $# = 0 ];  then
	find-schema | while read SCH;  do
		psql_rummy $SCH || exit
	done
	exit 0
fi

while [ "$1" ];  do
	psql_rummy "$1" || exit
	shift
done