Bug 1008468 - RFE: Expose test case runs stats via XMLRPC and optimize it
Summary: RFE: Expose test case runs stats via XMLRPC and optimize it
Keywords:
Status: NEW
Alias: None
Product: TCMS
Classification: Other
Component: XMLRPC
Version: Devel
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 3.9.0
Assignee: Yang Ren
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-09-16 12:37 UTC by Alexander Todorov
Modified: 2015-12-01 05:45 UTC (History)
1 user (show)

Fixed In Version: 3.9.0
Clone Of:
Environment:
Last Closed:
Embargoed:


Attachments (Terms of Use)

Description Alexander Todorov 2013-09-16 12:37:32 UTC
Description of problem:

Currently there is no way for the client tools to access information about test case runs counts for a specific test run, e.g. 5 PASSED, 3 FAILED, etc, other than iterating over all CaseRun objects and count based on their status. 

This is taking too long for me, I have nearly 1000 case runs (and growing) and trying to extract some stats out of it. 


On the server side there is tcms.core.utils.counter.CaseRunStatusCounter class which also appears to be counting by iterating over all objects. This is not optimal. Please improve it and export the new improved method to the XMLRPC client.

Comment 1 Alexander Todorov 2013-09-27 11:35:42 UTC
Hi any update here? 

I've executed my stats script against RHEL 5.10 test plans and for about 10K test case runs it takes around 3hrs to complete.


Note You need to log in before you can comment on or make changes to this bug.