Subversion Repositories DevTools

Rev

Rev 6592 | Rev 6617 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6592 Rev 6613
Line 4... Line 4...
4 
       pv.pv_id,
 4 
       pv.pv_id,
5 
       pm.code_lines,
 5 
       pm.code_lines,
6 
       pm.branches,
 6 
       pm.branches,
7 
       (CASE WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N' END) AS unit_tested,
7 
       (CASE WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N' END) AS unit_tested,
8 
       autotest_qry.autotested,
 8 
       autotest_qry.autotested,
9 
       (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count
 9 
       (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
- 
 
 10 
       TO_CHAR( modified_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS modified_stamp,
- 
 
 11 
       (CASE WHEN pv.is_autobuildable != 'Y' THEN 'Manual' ELSE  (CASE bi.reason WHEN 'R' THEN 'Ripple' WHEN 'N' THEN 'New Version' ELSE 'Unknown' END ) END) as reason
10 
  FROM package_metrics pm,
 12 
  FROM package_metrics pm,
11 
       package_versions pv,
 13 
       package_versions pv,
12 
       packages pkg,
 14 
       packages pkg,
13 
       unit_tests ut,
 15 
       unit_tests ut,
14 
       (SELECT ut.pv_id, 'Y' AS autotested FROM unit_tests ut WHERE ut.test_types_fk = 7 ) autotest_qry,
 16 
       (SELECT ut.pv_id, 'Y' AS autotested FROM unit_tests ut WHERE ut.test_types_fk = 7 ) autotest_qry,
Line 17... Line 19...
17 
          and bi.reason not in ('T')
 19 
          and bi.reason not in ('T')
18 
          group by pv_id
 20 
          group by pv_id
19 
        ) cbi,
 21 
        ) cbi,
20 
       BUILD_INSTANCES bi
 22 
       BUILD_INSTANCES bi
21 
 WHERE pv.pkg_id = pkg.pkg_id
 23 
 WHERE pv.pkg_id = pkg.pkg_id
22 
   AND pv.pv_id = :PV_ID
 24 
   AND pv.pv_id IN (SELECT pv_id FROM package_versions pv1 CONNECT BY NOCYCLE PRIOR pv1.last_pv_id = pv1.pv_id START WITH pv1.pv_id = :PV_ID )
23 
   AND pm.pv_id (+) = pv.pv_id
 25 
   AND pm.pv_id (+) = pv.pv_id
24 
   AND ut.pv_id (+) = pv.pv_id
 26 
   AND ut.pv_id (+) = pv.pv_id
25 
   AND autotest_qry.pv_id (+) = pv.pv_id
 27 
   AND autotest_qry.pv_id (+) = pv.pv_id
26 
   and cbi.pv_id(+) = pv.pv_id
 28 
   and cbi.pv_id(+) = pv.pv_id
27 
   and cbi.build_id = bi.build_id(+)
 29 
   and cbi.build_id = bi.build_id(+)
28 
 
 - 
 
- 
 
 30 
 ORDER BY pv_id DESC
29 
 
 31