Subversion Repositories DevTools

Rev

Rev 119 | Details | Compare with Previous | Last modification | View Log | RSS feed

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