| 6576 |
dpurdie |
1 |
-- Select test count for packaages in a specified release
|
|
|
2 |
-- CLEAN_BI - a cleaned up version of BUILD_INSTANCES
|
|
|
3 |
-- Select the 'latest' build instance of the package
|
|
|
4 |
--
|
|
|
5 |
with CLEAN_BI as (
|
|
|
6 |
select pv_id, max(build_id) as build_id from BUILD_INSTANCES bi
|
|
|
7 |
where bi.state in ('C')
|
|
|
8 |
and bi.reason not in ('T')
|
|
|
9 |
group by pv_id
|
|
|
10 |
)
|
|
|
11 |
select rc.pv_id,cbi.build_id, pv.pkg_id, p.PKG_NAME, pv.V_EXT, p.PKG_NAME || pv.V_EXT as pkg_alias, pv.PKG_VERSION,
|
|
|
12 |
(select count(*) from test_run tr where tr.build_id = cbi.build_id) as test_count,
|
| 6577 |
dpurdie |
13 |
TO_CHAR(bi.timestamp,'DD-Mon-YYYY HH24:MI:SS') AS lastBuild, pv.build_time
|
| 6576 |
dpurdie |
14 |
from RELEASE_CONTENT rc, PACKAGE_VERSIONS pv, packages p, CLEAN_BI cbi, BUILD_INSTANCES bi
|
|
|
15 |
where rc.RTAG_ID = :RTAG_ID
|
|
|
16 |
and rc.pv_id = pv.pv_id
|
|
|
17 |
and p.pkg_id = pv.pkg_id
|
|
|
18 |
and cbi.pv_id = pv.pv_id
|
|
|
19 |
and cbi.build_id = bi.build_id
|
|
|
20 |
order by upper(p.pkg_name)
|
|
|
21 |
|
|
|
22 |
|