From af228c082b6c94ff7de77ba0bf047b00ef8eca8a Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Fri, 22 Jul 2011 00:36:41 +0000
Subject: Don't blindly mark everything as cached... mark them cached when
 they've been processed

---
 gentoobrowse/console/fileimport.xml      | 6 +++++-
 gentoobrowse/console/packagemetadata.xml | 7 +++++++
 2 files changed, 12 insertions(+), 1 deletion(-)

diff --git a/gentoobrowse/console/fileimport.xml b/gentoobrowse/console/fileimport.xml
index 1a422ab..2018361 100644
--- a/gentoobrowse/console/fileimport.xml
+++ b/gentoobrowse/console/fileimport.xml
@@ -71,6 +71,10 @@
 	</project2:sqlmerge>
 
 	<project2:sqltask name="setCachedTime" datasource="postgres">
-		<sql>UPDATE files SET cachedat = moddate WHERE cachedat != moddate OR cachedat IS NULL</sql>
+		<sql>
+			UPDATE files SET cachedat = moddate
+			WHERE (cachedat != moddate OR cachedat IS NULL)
+			AND filetypeid IN (SELECT filetypeid FROM filetypes WHERE content = TRUE)
+		</sql>
 	</project2:sqltask>
 </packageimport>
diff --git a/gentoobrowse/console/packagemetadata.xml b/gentoobrowse/console/packagemetadata.xml
index fdcf870..1f89694 100644
--- a/gentoobrowse/console/packagemetadata.xml
+++ b/gentoobrowse/console/packagemetadata.xml
@@ -41,4 +41,11 @@
 			</project2:sqltask>
 		</project2:iterate>
 	</project2:iterate>
+	<project2:sqltask name="update" datasource="postgres">
+		<sql>
+			UPDATE files SET
+				cachedat = moddate
+			WHERE filetypeid = 4
+		</sql>
+	</project2:sqltask>
 </homepages>
-- 
cgit v1.2.3