[Erp5-report] r18111 - /erp5/trunk/products/CMFActivity/bin/

[nobody at svn.erp5.org]

Author: vincent
Date: Fri Dec  7 10:26:35 2007
New Revision: 18111

URL: http://svn.erp5.org?rev=18111&view=rev
Log:
Add activity validation/execution monitoring scripts.

Added:
    erp5/trunk/products/CMFActivity/bin/
    erp5/trunk/products/CMFActivity/bin/watch_activities   (with props)
    erp5/trunk/products/CMFActivity/bin/watch_distribution   (with props)

Added: erp5/trunk/products/CMFActivity/bin/watch_activities
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/bin/watch_activities?rev=18111&view=auto
==============================================================================
--- erp5/trunk/products/CMFActivity/bin/watch_activities (added)
+++ erp5/trunk/products/CMFActivity/bin/watch_activities Fri Dec  7 10:26:35 2007
@@ -1,0 +1,9 @@
+#!/bin/sh
+
+if [ $# -ne 1 ]; then
+  echo "Usage:\n  $0 <db_name>"
+  exit 1
+fi
+
+watch -n 5 "mysql -h localhost -u root -t '$1' --disable-pager -t -e 'SELECT count(path) as MESSAGE, method_id, processing as run, processing_node as node FROM message WHERE processing_node > -1 GROUP BY  method_id, processing, processing_node; SELECT count(path) as MESSAGE_QUEUE, method_id, processing as run, processing_node as node FROM message_queue WHERE processing_node > -1 GROUP BY method_id, processing, processing_node' "
+

Propchange: erp5/trunk/products/CMFActivity/bin/watch_activities
------------------------------------------------------------------------------
    svn:executable = *

Added: erp5/trunk/products/CMFActivity/bin/watch_distribution
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/bin/watch_distribution?rev=18111&view=auto
==============================================================================
--- erp5/trunk/products/CMFActivity/bin/watch_distribution (added)
+++ erp5/trunk/products/CMFActivity/bin/watch_distribution Fri Dec  7 10:26:35 2007
@@ -1,0 +1,9 @@
+#!/bin/sh
+
+if [ $# -ne 2 ]; then
+	echo -e "Usage:\n  $0 db_name table_name"
+  exit 1
+fi
+
+watch -n 1 "mysql -u root -t '$1' --disable-pager -t -e '  SELECT count(*) as NEW FROM \`$2\` WHERE processing_node = -1; SELECT count(*) as VALID FROM \`$2\` WHERE processing_node = 0; SELECT count(*) as ASSIGNED FROM \`$2\` WHERE processing_node > 0; SELECT count(*) as PROCESSING FROM \`$2\` WHERE processing = 1; SELECT count(*) as ASSIGNED, processing_node as node FROM \`$2\` WHERE processing_node > 0 GROUP BY processing_node; SELECT count(*) as PROCESSING, processing_node as node FROM \`$2\` WHERE processing_node > 0 AND processing = 1 GROUP BY processing_node; SELECT count(*) as FAILURE FROM \`$2\` WHERE processing_node = -2; SELECT count(*) as ERROR FROM \`$2\` WHERE processing_node = -3;'"
+

Propchange: erp5/trunk/products/CMFActivity/bin/watch_distribution
------------------------------------------------------------------------------
    svn:executable = *