Subversion Repositories DevTools

/* Get parents of dependencies of submitted pkgs */
SELECT DISTINCT dep.pkg_id
 FROM package_dependencies dep,
      (
      /* 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 simrel.pv_id = dep.pv_id
  AND dep.dpkg_id IN 
               (
               /* Package_ids of submitted packages*/
               SELECT pkg.pkg_id
               FROM packages pkg
               WHERE pkg.pkg_name IN ( $PKG_NAMES$ )
               )