#!/bin/sh

function show_help ( )
{
  script_name=`basename $0`
  echo """
  Usage:
    $script_name <mysql_opt> [interval seconds]
  Interval is default 5.
  mysql_opt are default mysql command line options.
  Put them in quotes if more than one option is passed.

  Typical usage:
    $script_name erp5
    $script_name \"-h remotehost -u user erp5remote\" 3
  """
}

MYSQL_OPT=$1
INTERVAL=$2

if [ "$MYSQL_OPT" == "" ] ; then
  show_help
  exit 1
fi

if [ "$INTERVAL" == "" ] ; then
  INTERVAL=5
fi

SELECT="""
SELECT count(path) AS message, method_id, processing, processing_node FROM message GROUP BY method_id, processing, processing_node;
SELECT count(path) AS message_queue, method_id, processing, processing_node FROM message_queue GROUP BY method_id, processing, processing_node;
SELECT count(path) AS message, processing, processing_node FROM message GROUP BY processing, processing_node;
SELECT count(path) AS message_queue, processing, processing_node FROM message_queue GROUP BY processing, processing_node;
SELECT count(path) AS message_count FROM message;
SELECT count(path) AS message_queue_count FROM message_queue;
"""

watch -n $INTERVAL "mysql $MYSQL_OPT --disable-pager -t -e '$SELECT' "