diff options
Diffstat (limited to 'gentoobrowse-api/service/sql')
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql | 1 | ||||
| -rw-r--r-- | gentoobrowse-api/service/sql/maintenance/ebuildRDeps.sql | 8 |
2 files changed, 9 insertions, 0 deletions
diff --git a/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql b/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql index 801c877..ae33b65 100644 --- a/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql +++ b/gentoobrowse-api/service/sql/maintenance/ebuildDeps.sql @@ -4,4 +4,5 @@ WHERE c.categoryid = p.categoryid AND c.name = e.category AND p.name = e.package + AND e.runtime = false ) diff --git a/gentoobrowse-api/service/sql/maintenance/ebuildRDeps.sql b/gentoobrowse-api/service/sql/maintenance/ebuildRDeps.sql new file mode 100644 index 0000000..b0e54b9 --- /dev/null +++ b/gentoobrowse-api/service/sql/maintenance/ebuildRDeps.sql @@ -0,0 +1,8 @@ +( + SELECT DISTINCT ebuildid, packageid, e.version versionspec, flags, slot, op + FROM gentoobrowse.categories c, gentoobrowse.packages p, tmpEbuildDeps e + WHERE c.categoryid = p.categoryid + AND c.name = e.category + AND p.name = e.package + AND e.runtime = true +) |