[Erp5-report] r29347 - /erp5/trunk/products/CMFActivity/bin/watch_activities

[nobody at svn.erp5.org]

Author: luke
Date: Thu Oct  1 14:37:27 2009
New Revision: 29347

URL: http://svn.erp5.org?rev=29347&view=rev
Log:
 - implement proof of concept grouping by tag

Modified:
    erp5/trunk/products/CMFActivity/bin/watch_activities

Modified: erp5/trunk/products/CMFActivity/bin/watch_activities
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/bin/watch_activities?rev=29347&r1=29346&r2=29347&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/bin/watch_activities [utf8] (original)
+++ erp5/trunk/products/CMFActivity/bin/watch_activities [utf8] Thu Oct  1 14:37:27 2009
@@ -4,6 +4,7 @@
 # ideas:
 #  - more control on what would be displayed
 #  - allow to group by tag instead of method_id
+#    - somehow done, use shell variable text_group
 #  - use python with curses to have runtime control
 
 function show_help ( )
@@ -37,7 +38,7 @@
 SELECT=""
 for t in message message_queue ; do
   SELECT=$SELECT"""
-  SELECT count(*) AS $t, method_id, processing, processing_node AS node, min(priority) AS min_pri, max(priority) AS max_pri FROM $t GROUP BY method_id, processing, processing_node ORDER BY node;
+  SELECT count(*) AS $t, ${text_group:-method_id}, processing, processing_node AS node, min(priority) AS min_pri, max(priority) AS max_pri FROM $t GROUP BY ${text_group:-method_id}, processing, processing_node ORDER BY node;
   SELECT count(*) AS $t, processing, processing_node, min(priority) AS min_pri, max(priority) AS max_pri FROM $t GROUP BY processing, processing_node;
   SELECT priority as pri, MIN(timediff(NOW(), date)) AS min, AVG(timediff(NOW() , date)) AS avg, MAX(timediff(NOW() , date)) AS max FROM $t GROUP BY priority;
   SELECT count(*) AS ${t}_count FROM $t;