diff options
| author | randomdan <randomdan@localhost> | 2011-07-22 00:36:41 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2011-07-22 00:36:41 +0000 |
| commit | af228c082b6c94ff7de77ba0bf047b00ef8eca8a (patch) | |
| tree | 01820716a7ca8c2b605deb24aa12f2709e94e0d7 | |
| parent | Add another order by clause to stop random repition of package descriptions (diff) | |
| download | gentoobrowse-af228c082b6c94ff7de77ba0bf047b00ef8eca8a.tar.bz2 gentoobrowse-af228c082b6c94ff7de77ba0bf047b00ef8eca8a.tar.xz gentoobrowse-af228c082b6c94ff7de77ba0bf047b00ef8eca8a.zip | |
Don't blindly mark everything as cached... mark them cached when they've been processed
| -rw-r--r-- | gentoobrowse/console/fileimport.xml | 6 | ||||
| -rw-r--r-- | gentoobrowse/console/packagemetadata.xml | 7 |
2 files changed, 12 insertions, 1 deletions
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> |