Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 6592
Line 2... Line 2...
2 
       pv.pkg_version,
 2 
       pv.pkg_version,
3 
       pv.is_autobuildable,
 3 
       pv.is_autobuildable,
4 
       pv.pv_id,
 4 
       pv.pv_id,
5 
       pm.code_lines,
 5 
       pm.code_lines,
6 
       pm.branches,
 6 
       pm.branches,
7 
       (CASE
 - 
 
8 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
 7 
       (CASE WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N' END) AS unit_tested,
9 
        END) AS unit_tested,
 8 
       autotest_qry.autotested,
10 
       autotest_qry.autotested
 9 
       (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count
11 
  FROM package_metrics pm,
 10 
  FROM package_metrics pm,
12 
       package_versions pv,
 11 
       package_versions pv,
13 
       packages pkg,
 12 
       packages pkg,
14 
       unit_tests ut,
 13 
       unit_tests ut,
15 
       (SELECT ut.pv_id, 'Y' AS autotested
 14 
       (SELECT ut.pv_id, 'Y' AS autotested FROM unit_tests ut WHERE ut.test_types_fk = 7 ) autotest_qry,
- 
 
 15 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
16 
          FROM unit_tests ut
 16 
          where bi.state in ('C')
17 
         WHERE ut.test_types_fk = 7
 17 
          and bi.reason not in ('T')
18 
       ) autotest_qry
 18 
          group by pv_id
- 
 
 19 
        ) cbi,
- 
 
 20 
       BUILD_INSTANCES bi
19 
 WHERE pv.pkg_id = pkg.pkg_id
 21 
 WHERE pv.pkg_id = pkg.pkg_id
20 
   AND pv.pv_id = :PV_ID
 22 
   AND pv.pv_id = :PV_ID
21 
   AND pm.pv_id (+) = pv.pv_id
 23 
   AND pm.pv_id (+) = pv.pv_id
22 
   AND ut.pv_id (+) = pv.pv_id
 24 
   AND ut.pv_id (+) = pv.pv_id
23 
   AND autotest_qry.pv_id (+) = pv.pv_id
 25 
   AND autotest_qry.pv_id (+) = pv.pv_id
- 
 
 26 
   and cbi.pv_id(+) = pv.pv_id
- 
 
 27 
   and cbi.build_id = bi.build_id(+)
- 
 
 28 
 
24 
 
 29