| 119 |
ghuddy |
1 |
/* all parents + package itself */
|
|
|
2 |
(
|
|
|
3 |
SELECT DISTINCT pkg_id AS pkg_id
|
|
|
4 |
FROM package_dependencies dep
|
|
|
5 |
CONNECT BY PRIOR pkg_id = dpkg_id AND pv_id IN ( $RELIST$ )
|
|
|
6 |
START WITH dpkg_id IN ( $PKG_ID$ ) AND pv_id IN ( $RELIST$ )
|
|
|
7 |
UNION
|
|
|
8 |
SELECT DISTINCT pkg.pkg_id
|
|
|
9 |
FROM packages pkg, package_versions pv, release_content rc
|
|
|
10 |
WHERE pkg.pkg_id = pv.pkg_id
|
|
|
11 |
AND pv.pv_id = rc.pv_id
|
|
|
12 |
AND pkg.pkg_id IN ( $PKG_ID$ )
|
|
|
13 |
/* AND rc.pv_id IN ( $RELIST$ ) */
|
|
|
14 |
)
|
|
|
15 |
INTERSECT
|
|
|
16 |
/* all kids of working package */
|
|
|
17 |
(
|
|
|
18 |
SELECT UNIQUE dpkg_id AS pkg_id
|
|
|
19 |
FROM package_dependencies dep
|
|
|
20 |
CONNECT BY PRIOR dpkg_id = pkg_id AND pv_id IN ( $RELIST$ )
|
|
|
21 |
START WITH pkg_id IN ( $DEPLIST$ ) AND pv_id IN ( $RELIST$ )
|
|
|
22 |
UNION
|
|
|
23 |
SELECT pkg.pkg_id
|
|
|
24 |
FROM packages pkg, package_versions pv, release_content rc
|
|
|
25 |
WHERE pkg.pkg_id = pv.pkg_id
|
|
|
26 |
AND pv.pv_id = rc.pv_id
|
|
|
27 |
AND pkg.pkg_name IN ( $DEPNAMESTR$ )
|
|
|
28 |
AND rc.pv_id IN ( $RELIST$ )
|
|
|
29 |
)
|