
# simple way to call PostgreSQL on hsdb
# example: HSDB "SELECT * FROM unixuser WHERE ..."
function HSDB()
{
	hsdbConfig=`cat /usr/local/etc/hsdb.ini`
	dbname=`echo "$hsdbConfig" | grep '^dbname.*=' | cut -d'=' -f2`
	host=`echo "$hsdbConfig" | grep '^host.*=' | cut -d'=' -f2`
	port=`echo "$hsdbConfig" | grep '^port.*=' | cut -d'=' -f2`
	username=`echo "$hsdbConfig" | grep '^username.*=' | cut -d'=' -f2`
	password=`echo "$hsdbConfig" | grep '^password.*=' | cut -d'=' -f2`

	if [ "$1" != '-v' ]; then
		opts="--tuples --quiet"
	else
		opts=
		shift 1
	fi
	sql="$1"

	psql --host $host --port $port --user $username $opts --command "$sql" $dbname | sed '/^$/d'
}
