Bug 1008468

Summary: RFE: Expose test case runs stats via XMLRPC and optimize it
Product: [Other] TCMS Reporter: Alexander Todorov <atodorov>
Component: XMLRPCAssignee: Yang Ren <ryang>
Status: NEW --- QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: DevelCC: ryang
Target Milestone: ---   
Target Release: 3.9.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 3.9.0 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

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.