Subversion Repositories DevTools

Rev

Rev 125 | Details | Compare with Previous | Last modification | View Log | RSS feed

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