Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
29 jtweddle 1 
/* Finds all dependencies recursively for a package */
2 
SELECT DISTINCT
3 
      qry.dpv_id, dep_pkg.pkg_name, dep_pv.pkg_version, dep_pv.v_ext
4 
FROM  (
5 
          SELECT dep.dpv_id
6 
          FROM package_dependencies dep
7 
          START WITH dep.pv_id IN ( :PV_ID_A )
8 
          CONNECT BY PRIOR dep.dpv_id = dep.pv_id
9 
      ) qry,
10 
      packages dep_pkg,
11 
      package_versions dep_pv
12 
WHERE qry.dpv_id = dep_pv.pv_id
13 
  AND dep_pv.pkg_id = dep_pkg.pkg_id
14 
  AND qry.dpv_id NOT IN
15 
      (
16 
          SELECT dep.dpv_id
17 
          FROM package_dependencies dep
18 
          START WITH dep.pv_id IN ( :PV_ID_B )
19 
          CONNECT BY PRIOR dep.dpv_id = dep.pv_id
20 
      )
21 
ORDER BY UPPER(dep_pkg.pkg_name || ' ' || dep_pv.pkg_version)