Subversion Repositories DevTools

Rev

Rev 5506 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 6591
Line 5... Line 5...
5 
       pv.pv_id,
 5 
       pv.pv_id,
6 
       pv.created_stamp,
 6 
       pv.created_stamp,
7 
       TO_CHAR( pv.modified_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS modified_stamp,
 7 
       TO_CHAR( pv.modified_stamp,'DD-Mon-YYYY HH24:MI:SS' ) AS modified_stamp,
8 
       pm.code_lines,
 8 
       pm.code_lines,
9 
       pm.branches,
 9 
       pm.branches,
10 
       (CASE
 - 
 
11 
         WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N'
 10 
       (CASE WHEN ut.test_types_fk IS NOT NULL AND ut.test_types_fk != 1 THEN 'Y' ELSE 'N' END) AS unit_tested,
12 
        END) AS unit_tested,
 11 
       autotest_qry.autotested,
13 
       autotest_qry.autotested
 12 
       (select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count
14 
  FROM package_metrics pm,
 13 
  FROM package_metrics pm,
15 
       package_versions pv,
 14 
       package_versions pv,
16 
       packages pkg,
 15 
       packages pkg,
17 
       release_content rc,
 16 
       release_content rc,
18 
       unit_tests ut,
 17 
       unit_tests ut,
19 
       (SELECT ut.pv_id, 'Y' AS autotested
 18 
       (SELECT ut.pv_id, 'Y' AS autotested
20 
          FROM unit_tests ut
 19 
          FROM unit_tests ut
21 
         WHERE ut.test_types_fk = 7
 20 
         WHERE ut.test_types_fk = 7
22 
       ) autotest_qry
 21 
       ) autotest_qry,
- 
 
 22 
       ( select pv_id, max(build_id) as build_id  from BUILD_INSTANCES bi
- 
 
 23 
        where bi.state in ('C')
- 
 
 24 
        and bi.reason not in ('T')
- 
 
 25 
        group by pv_id
- 
 
 26 
        ) cbi,
- 
 
 27 
       BUILD_INSTANCES bi
23 
 WHERE pv.pkg_id = pkg.pkg_id
 28 
 WHERE pv.pkg_id = pkg.pkg_id
24 
   AND pv.pv_id = rc.pv_id
 29 
   AND pv.pv_id = rc.pv_id
25 
   AND pm.pv_id (+) = pv.pv_id
 30 
   AND pm.pv_id (+) = pv.pv_id
26 
   AND ut.pv_id (+) = pv.pv_id
 31 
   AND ut.pv_id (+) = pv.pv_id
27 
   AND rc.rtag_id = :RTAG_ID
 32 
   AND rc.rtag_id = :RTAG_ID
28 
   AND autotest_qry.pv_id (+) = pv.pv_id
 33 
   AND autotest_qry.pv_id (+) = pv.pv_id
- 
 
 34 
   and cbi.pv_id(+) = pv.pv_id
- 
 
 35 
  and cbi.build_id = bi.build_id(+)
29 
 ORDER BY UPPER(pkg.pkg_name)
 36 
 ORDER BY UPPER(pkg.pkg_name)
- 
 
 37