diff options
| author | randomdan <randomdan@localhost> | 2012-03-17 01:26:05 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2012-03-17 01:26:05 +0000 |
| commit | e3e86c54c5ea7aa65fbc4c98735687e61d516e32 (patch) | |
| tree | 78564d876928292df03aee8be8a6eb3ba9424205 /gentoobrowse/views | |
| parent | Create 404s when row sets optionally don't return rows (diff) | |
| download | gentoobrowse-e3e86c54c5ea7aa65fbc4c98735687e61d516e32.tar.bz2 gentoobrowse-e3e86c54c5ea7aa65fbc4c98735687e61d516e32.tar.xz gentoobrowse-e3e86c54c5ea7aa65fbc4c98735687e61d516e32.zip | |
Add a sitemap
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/categories.xml | 2 | ||||
| -rw-r--r-- | gentoobrowse/views/package.xml | 9 |
2 files changed, 10 insertions, 1 deletions
diff --git a/gentoobrowse/views/categories.xml b/gentoobrowse/views/categories.xml index 1faec02..e40ff98 100644 --- a/gentoobrowse/views/categories.xml +++ b/gentoobrowse/views/categories.xml @@ -3,7 +3,7 @@ xmlns:project2="http://project2.randomdan.homeip.net"> <project2:sqlrows name="categories" datasource="postgres-web"> <sql> - SELECT c.categoryid, MIN(c.name) AS catname, COUNT(*) AS packages, MIN(c.summary) AS summary + SELECT c.categoryid, MIN(c.name) AS catname, COUNT(*) AS packages, MIN(c.summary) AS summary, MAX(p.firstseen) AS pkgfirstseen FROM categories c, packages p WHERE c.categoryid = p.categoryid GROUP BY c.categoryid diff --git a/gentoobrowse/views/package.xml b/gentoobrowse/views/package.xml index af36f44..7f10887 100644 --- a/gentoobrowse/views/package.xml +++ b/gentoobrowse/views/package.xml @@ -1,6 +1,15 @@ <?xml version="1.0"?> <block xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:project2="http://project2.randomdan.homeip.net"> + <project2:sqlrows name="sitemap-packages" datasource="postgres-web"> + <sql> + SELECT c.name AS catname, p.name AS pkgname, MAX(e.moddate) AS moddate + FROM categories c, packages p, ebuilds e + WHERE p.packageid = e.packageid + AND c.categoryid = p.categoryid + GROUP BY c.name, p.name + </sql> + </project2:sqlrows> <project2:sqlrows name="packages" datasource="postgres-web"> <sql> SELECT p.packageid, p.name AS pkgname, p.description, p.firstseen, c.name AS catname, p.herd, p.summary |