| 119 |
ghuddy |
1 |
SELECT DISTINCT dep.dpkg_id
|
|
|
2 |
FROM package_dependencies dep, package_versions pv,
|
|
|
3 |
(
|
|
|
4 |
/* Simulate release after packages have bee added */
|
|
|
5 |
SELECT rel.pv_id
|
|
|
6 |
FROM release_content rel
|
|
|
7 |
WHERE rtag_id = $RTAG_ID$
|
|
|
8 |
UNION
|
|
|
9 |
SELECT spv.pv_id
|
|
|
10 |
FROM packages spkg, package_versions spv
|
|
|
11 |
WHERE spkg.pkg_id = spv.pkg_id
|
|
|
12 |
AND spkg.pkg_name || spv.pkg_version IN ( $PKG_NAME_VERSION$ )
|
|
|
13 |
AND spkg.pkg_id NOT IN
|
|
|
14 |
(
|
|
|
15 |
/* pkg_id list from current release */
|
|
|
16 |
SELECT pkg.pkg_id
|
|
|
17 |
FROM release_content rel, packages pkg, package_versions pv
|
|
|
18 |
WHERE pkg.pkg_id = pv.pkg_id
|
|
|
19 |
AND pv.pv_id = rel.pv_id
|
|
|
20 |
AND rel.rtag_id = $RTAG_ID$
|
|
|
21 |
AND pkg.pkg_name || pv.pkg_version IN ( $PKG_NAME_VERSION$ )
|
|
|
22 |
)
|
|
|
23 |
) simrel
|
|
|
24 |
WHERE pv.pv_id = simrel.pv_id
|
|
|
25 |
AND pv.pkg_id = dep.pkg_id
|
|
|
26 |
AND dep.pkg_id IN ( $TO_TRACK$ )
|
|
|
27 |
AND dep.dpkg_id IN (SELECT pkg_id FROM packages WHERE pkg_name IN ( $PKG_NAMES$ ) )
|