Subversion Repositories DevTools

SELECT DISTINCT dep.dpkg_id
 FROM package_dependencies dep, package_versions pv,
      (
        /* Simulate release after packages have bee added */
      SELECT rel.pv_id
        FROM release_content rel
       WHERE rtag_id = $RTAG_ID$
       UNION 
      SELECT spv.pv_id
        FROM packages spkg, package_versions spv
       WHERE spkg.pkg_id = spv.pkg_id
         AND spkg.pkg_name || spv.pkg_version IN ( $PKG_NAME_VERSION$ )
         AND spkg.pkg_id NOT IN 
                     (
                       /* pkg_id list from current release */
                       SELECT pkg.pkg_id 
                       FROM release_content rel, packages pkg, package_versions pv
                       WHERE pkg.pkg_id = pv.pkg_id
                         AND pv.pv_id = rel.pv_id
                         AND rel.rtag_id = $RTAG_ID$
                         AND pkg.pkg_name || pv.pkg_version IN ( $PKG_NAME_VERSION$ )
                     )
      ) simrel
WHERE pv.pv_id = simrel.pv_id
  AND pv.pkg_id = dep.pkg_id
  AND dep.pkg_id IN ( $TO_TRACK$ )
  AND dep.dpkg_id IN (SELECT pkg_id FROM packages WHERE pkg_name IN ( $PKG_NAMES$ ) )