Author: justi9 Date: 2008-06-02 17:54:24 -0400 (Mon, 02 Jun 2008) New Revision: 2108 Modified: mgmt/cumin/python/cumin/exchange.strings mgmt/cumin/python/cumin/queue.strings Log: Update queries for schema changes Modified: mgmt/cumin/python/cumin/exchange.strings =================================================================== --- mgmt/cumin/python/cumin/exchange.strings 2008-06-02 21:29:35 UTC (rev 2107) +++ mgmt/cumin/python/cumin/exchange.strings 2008-06-02 21:54:24 UTC (rev 2108) @@ -8,8 +8,8 @@ select e.id, e.name, - c.producers, - c.bindings, + c.producer_count as producers, + c.binding_count as bindings, (c.msg_receives - p.msg_receives) / (extract(epoch from (c.rec_time - p.rec_time)) + 0.0001) as mreceived, case when p.msg_receives is null then true else false end as mreceived_is_null, Modified: mgmt/cumin/python/cumin/queue.strings =================================================================== --- mgmt/cumin/python/cumin/queue.strings 2008-06-02 21:29:35 UTC (rev 2107) +++ mgmt/cumin/python/cumin/queue.strings 2008-06-02 21:54:24 UTC (rev 2108) @@ -2,8 +2,8 @@ select q.id, q.name, - c.consumers, - c.bindings, + c.consumer_count as consumers, + c.binding_count as bindings, (c.msg_total_enqueues - p.msg_total_enqueues) / (extract(epoch from (c.rec_time - p.rec_time)) + 0.0001) as menqueued, case when p.msg_total_enqueues is null then true else false end as menqueued_is_null, @@ -17,7 +17,7 @@ / (extract(epoch from (c.rec_time - p.rec_time)) + 0.0001) as bdequeued, case when p.byte_total_dequeues is null then true else false end as bdequeued_is_null, c.msg_depth as mdepth, - c.byte_depth as bdepth, + 999 as bdepth, 1 as mdepthaccel, 1 as bdepthaccel, c.rec_time