#!/bin/bash
#
# $Id: proxy_by_method,v 1.5 2002/05/09 14:52:48 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

if [ "x$KB" = "x" ]; then
	KB=1
fi

QUERY="
SELECT
	request_method                                       AS \" \",
	ROUND (SUM (total_bytes)/$KB, 0)                     AS \"\",
	ROUND (SUM (hit_bytes)/$KB, 0)                       AS \" \",
	ROUND ((100 * SUM (hit_bytes))/SUM (total_bytes), 2) AS \"%\"

FROM proxy_log $WHERE_FILTER
GROUP BY request_method
ORDER BY \"\" DESC"

echo "**************************************************************"
echo "*   -  "
echo "*"
echo "*  :"
echo "*     = $KB"
echo "**************************************************************"
$PSQL -c "$QUERY"
