Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
119 ghuddy 1 
SELECT pv.pv_id AS dpv_id,
2 
       sorted.build_order,
3 
       sorted.pkg_name,
4 
       sorted.pkg_id
5 
  FROM
6 
      package_versions pv, release_content rel,
7 
     (
8 
     /* Remove duplicates by finding the MAX build order per package */
9 
     SELECT DISTINCT bord.pkg_id,
10 
             MAX(bord.build_order) OVER (PARTITION BY bord.pkg_id) AS build_order,
11 
             pkg.pkg_name
12 
      FROM packages pkg,
13 
           (
14 
              /* Get dependency tree limited to current release */
15 
              SELECT dpkg_id AS pkg_id, LEVEL AS build_order
16 
                FROM package_dependencies dep
17 
              CONNECT BY PRIOR dpkg_id = pkg_id AND pv_id IN ( $RELPVLIST$ )
18 
              START WITH pkg_id = $PKG_ID$ AND pv_id IN ( $RELPVLIST$ )
19 
           ) bord
20 
      WHERE pkg.pkg_id = bord.pkg_id
21 
        AND bord.pkg_id <> 0
22 
     ) sorted
23 
 WHERE pv.pkg_id = sorted.pkg_id
24 
   AND pv.pv_id = rel.pv_id
25 
   AND rel.rtag_id = $RTAG_ID$
26 
   /* AND pv.pv_id IN ( $RELPVLIST$  )   */
27 
ORDER BY sorted.build_order ASC