Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT DISTINCT rc.rtag_id,
2 
       pkg.pkg_name,
3 
       pv.pkg_version,
4 
       pv.is_autobuildable,
5 
       pv.pv_id,
125 ghuddy 6 
       pv.created_stamp,
7 
       pv.modified_stamp,
119 ghuddy 8 
       pm.code_lines,
9 
       pm.branches,
10 
       (CASE
125 ghuddy 11 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
119 ghuddy 12 
        END) AS unit_tested,
13 
       autotest_qry.autotested
14 
  FROM package_metrics pm,
15 
       package_versions pv,
16 
       packages pkg,
17 
       release_content rc,
18 
       unit_tests ut,
19 
       (SELECT ut.pv_id, 'Y' AS autotested
20 
          FROM unit_tests ut
21 
         WHERE ut.test_types_fk = 7
22 
       ) autotest_qry
23 
 WHERE pv.pkg_id = pkg.pkg_id
24 
   AND pv.pv_id = rc.pv_id
25 
   AND pm.pv_id (+) = pv.pv_id
26 
   AND ut.pv_id (+) = pv.pv_id
27 
   AND rc.rtag_id = :RTAG_ID
28 
   AND autotest_qry.pv_id (+) = pv.pv_id
29 
 ORDER BY UPPER(pkg.pkg_name)