From e3e86c54c5ea7aa65fbc4c98735687e61d516e32 Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Sat, 17 Mar 2012 01:26:05 +0000
Subject: Add a sitemap

---
 gentoobrowse/.htaccess               |  2 ++
 gentoobrowse/present/sitemap.xml.xml |  9 +++++++++
 gentoobrowse/views/categories.xml    |  2 +-
 gentoobrowse/views/package.xml       |  9 +++++++++
 gentoobrowse/xslt/sitemap.xslt       | 36 ++++++++++++++++++++++++++++++++++++
 5 files changed, 57 insertions(+), 1 deletion(-)
 create mode 100644 gentoobrowse/present/sitemap.xml.xml
 create mode 100644 gentoobrowse/xslt/sitemap.xslt

diff --git a/gentoobrowse/.htaccess b/gentoobrowse/.htaccess
index c727c5d..e33d832 100644
--- a/gentoobrowse/.htaccess
+++ b/gentoobrowse/.htaccess
@@ -9,6 +9,8 @@ RewriteCond %{REQUEST_URI} !^/images/
 RewriteCond %{REQUEST_URI} !^/[^/]+\.[^/]+$
 RewriteCond %{REQUEST_URI} !^/p2web
 RewriteRule ^(.*) /p2web/\1 [L]
+RewriteCond %{REQUEST_URI} ^/sitemap\.xml$
+RewriteRule ^(.*) /p2web/\1 [L]
 
 FilterDeclare XSLT
 FilterProvider XSLT XSLT resp=Content-Type $text/xml-xslt
diff --git a/gentoobrowse/present/sitemap.xml.xml b/gentoobrowse/present/sitemap.xml.xml
new file mode 100644
index 0000000..900fcc0
--- /dev/null
+++ b/gentoobrowse/present/sitemap.xml.xml
@@ -0,0 +1,9 @@
+<?xml version="1.0"?>
+<view name="sitemap" root="gentoo" contenttype="text/xml-xslt" style="xslt/sitemap.xslt" xmlns:xi="http://www.w3.org/2001/XInclude"
+		xmlns:project2="http://project2.randomdan.homeip.net">
+	<xi:include href="../views/categories.xml" />
+	<xi:include href="../views/package.xml" />
+	<project2:view name="categories" source="categories" rootname="categories" recordname="category" />
+	<project2:view name="packages" source="sitemap-packages" rootname="packages" recordname="package" />
+</view>
+
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
diff --git a/gentoobrowse/xslt/sitemap.xslt b/gentoobrowse/xslt/sitemap.xslt
new file mode 100644
index 0000000..a90e150
--- /dev/null
+++ b/gentoobrowse/xslt/sitemap.xslt
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"
+	xmlns:project2="http://project2.randomdan.homeip.net" exclude-result-prefixes="project2" >
+  <xsl:output encoding="utf-8" method="xml" media-type="text/xml" indent="yes" />
+  <xsl:template match="/gentoo">
+		<urlset>
+			<url>
+				<loc>http://gentoobrowse.randomdan.homeip.net/</loc>
+				<changefreq>daily</changefreq>
+			</url>
+			<url>
+				<loc>http://gentoobrowse.randomdan.homeip.net/popular</loc>
+				<changefreq>weekly</changefreq>
+			</url>
+			<url>
+				<loc>http://gentoobrowse.randomdan.homeip.net/categories</loc>
+				<changefreq>monthly</changefreq>
+			</url>
+			<xsl:for-each select="packages/package">
+				<url>
+					<loc>http://gentoobrowse.randomdan.homeip.net/package/<xsl:value-of select="catname" />/<xsl:value-of select="pkgname" /></loc>
+					<lastmod><xsl:value-of select="moddate" /></lastmod>
+					<changefreq>weekly</changefreq>
+				</url>
+			</xsl:for-each>
+			<xsl:for-each select="categories/category">
+				<url>
+					<loc>http://gentoobrowse.randomdan.homeip.net/category/<xsl:value-of select="catname" /></loc>
+					<lastmod><xsl:value-of select="pkgfirstseen" /></lastmod>
+					<changefreq>daily</changefreq>
+				</url>
+			</xsl:for-each>
+		</urlset>
+	</xsl:template>
+</xsl:stylesheet>
+
-- 
cgit v1.2.3