Purpose of Query
The query provided in this page gives the cyclomatic complexity computed for every type of object present in the application for a specific snapshot.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
Query for CSS
Following query needs to be run on the central database CB
SELECT dmr.snapshot_id , dot.object_type_id , dot.object_type_name, COUNT(*) AS TotalObj, SUM(dmr.metric_num_value)AS TotalCC FROM dss_metric_results dmr JOIN dss_objects dos ON dos.object_id = dmr.object_id JOIN dss_object_types dot ON dot.object_type_id = dos.object_type_id AND dot.object_group =0 WHERE metric_id IN (65504,65502,65505,65503) AND dmr.snapshot_id =snapshot_id --please replace with the Id of the snapshot for which you want to get the cyclomatic complexity AND metric_value_index =1 GROUP BY dmr.snapshot_id , dot.object_type_id, dot.object_type_name ORDER BY dot.object_type_id , dot.object_type_name, dmr.snapshot_id
Query result example
Here is an example of returned rows (for snapshot_id=12)
12;101;"Java Constructor";2182;3060
Query result interpretation
In snapshot 12, the total cyclomatic complexity associated to Java Constructor type (type 101) is 3060 for 2182 objects
Query for Oracle
Same as for CSS
Query result example
Same as for CSS
Query result interpretation
Same as for CSS
Query for SQL server
Same as for CSS
Query result example
Same as for CSS
Query result interpretation
Same as for CSS
Notes/comments
Related Pages