#!/bin/bash
#
# $Id: dbase_stat,v 1.1 2002/02/07 18:31:15 syatskevich Exp $
#
#    
#

#  
if [ "x$PSQL" = "x" ]; then
	echo "   (PSQL).  $0 "
	exit 1
fi

#    
if [ "x$FILTER" != "x" ]; then
	WHERE_FILTER="WHERE ($FILTER)"
	AND_FILTER="AND ($FILTER)"
fi

QUERY="
	SELECT ' ' AS x,
		count (*) AS proxy_log,
		0         AS mail_log,
		0         AS account_log,
		0         AS names
	FROM proxy_log

	UNION
	
	SELECT ' ' AS x,
		0         AS proxy_log,
		count (*) AS mail_log,
		0         AS account_log,
		0         AS names
	FROM mail_log

	UNION

	SELECT ' ' AS x,
		0         AS proxy_log,
		0         AS mail_log,
		count (*) AS account_log,
		0         AS names
	FROM account_log

	UNION

	SELECT ' ' AS x,
		0         AS proxy_log,
		0         AS mail_log,
		0         AS account_log,
		count (*) AS names
	FROM names

	UNION

	SELECT '  ' AS x,
		count (*) AS proxy_log,
		0         AS mail_log,
		0         AS account_log,
		0         AS names
	FROM proxy_log $WHERE_FILTER

	UNION
	
	SELECT '  ' AS x,
		0         AS proxy_log,
		count (*) AS mail_log,
		0         AS account_log,
		0         AS names
	FROM mail_log $WHERE_FILTER

	UNION

	SELECT '  ' AS x,
		0         AS proxy_log,
		0         AS mail_log,
		count (*) AS account_log,
		0         AS names
	FROM account_log $WHERE_FILTER"

QUERY="
	SELECT x,
		SUM (proxy_log)   AS proxy_log,
		SUM (mail_log)    AS mail_log,
		SUM (account_log) AS account_log,
		SUM (names)       AS names
	FROM ($QUERY) subselect
	GROUP BY x ORDER BY x"

echo "**************************************************************"
echo "*    "
echo "**************************************************************"
$PSQL -c "$QUERY"
