| 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,
|
| 6592 |
dpurdie |
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,
|
| 6613 |
dpurdie |
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,
|
| 6617 |
dpurdie |
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,
|
|
|
12 |
(CASE WHEN pv.pv_id = :PV_ID THEN 1 ELSE 0 END )as inRelease,
|
|
|
13 |
TRUNC( ORA_SYSDATE - modified_stamp ) as ageDays
|
| 125 |
ghuddy |
14 |
FROM package_metrics pm,
|
|
|
15 |
package_versions pv,
|
|
|
16 |
packages pkg,
|
|
|
17 |
unit_tests ut,
|
| 6592 |
dpurdie |
18 |
(SELECT ut.pv_id, 'Y' AS autotested FROM unit_tests ut WHERE ut.test_types_fk = 7 ) autotest_qry,
|
|
|
19 |
( select pv_id, max(build_id) as build_id from BUILD_INSTANCES bi
|
|
|
20 |
where bi.state in ('C')
|
|
|
21 |
and bi.reason not in ('T')
|
|
|
22 |
group by pv_id
|
|
|
23 |
) cbi,
|
|
|
24 |
BUILD_INSTANCES bi
|
| 125 |
ghuddy |
25 |
WHERE pv.pkg_id = pkg.pkg_id
|
| 6613 |
dpurdie |
26 |
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 )
|
| 125 |
ghuddy |
27 |
AND pm.pv_id (+) = pv.pv_id
|
|
|
28 |
AND ut.pv_id (+) = pv.pv_id
|
|
|
29 |
AND autotest_qry.pv_id (+) = pv.pv_id
|
| 6592 |
dpurdie |
30 |
and cbi.pv_id(+) = pv.pv_id
|
|
|
31 |
and cbi.build_id = bi.build_id(+)
|
| 6613 |
dpurdie |
32 |
ORDER BY pv_id DESC
|
| 125 |
ghuddy |
33 |
|