| 119 |
ghuddy |
1 |
SELECT pv.pv_id AS dpv_id,
|
|
|
2 |
sorted.build_order,
|
|
|
3 |
sorted.pkg_name,
|
|
|
4 |
sorted.pkg_id
|
|
|
5 |
FROM
|
|
|
6 |
package_versions pv, release_content rel,
|
|
|
7 |
(
|
|
|
8 |
/* Remove duplicates by finding the MAX build order per package */
|
|
|
9 |
SELECT DISTINCT bord.pkg_id,
|
|
|
10 |
MAX(bord.build_order) OVER (PARTITION BY bord.pkg_id) AS build_order,
|
|
|
11 |
pkg.pkg_name
|
|
|
12 |
FROM packages pkg,
|
|
|
13 |
(
|
|
|
14 |
/* Get dependency tree limited to current release */
|
|
|
15 |
SELECT dpkg_id AS pkg_id, LEVEL AS build_order
|
|
|
16 |
FROM package_dependencies dep
|
|
|
17 |
CONNECT BY PRIOR dpkg_id = pkg_id AND pv_id IN ( $RELPVLIST$ )
|
|
|
18 |
START WITH pkg_id = $PKG_ID$ AND pv_id IN ( $RELPVLIST$ )
|
|
|
19 |
) bord
|
|
|
20 |
WHERE pkg.pkg_id = bord.pkg_id
|
|
|
21 |
AND bord.pkg_id <> 0
|
|
|
22 |
) sorted
|
|
|
23 |
WHERE pv.pkg_id = sorted.pkg_id
|
|
|
24 |
AND pv.pv_id = rel.pv_id
|
|
|
25 |
AND rel.rtag_id = $RTAG_ID$
|
|
|
26 |
/* AND pv.pv_id IN ( $RELPVLIST$ ) */
|
|
|
27 |
ORDER BY sorted.build_order ASC
|