diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-08-23 03:49:29 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-08-23 03:49:29 +0100 |
| commit | 01b5159b9cd62bb64c5ddf5ec5c22b47cd4be60d (patch) | |
| tree | 730356def8947b06ec7a5510875f03129db46ef7 | |
| parent | Add missing column mapping and correct file name (diff) | |
| download | gentoobrowse-01b5159b9cd62bb64c5ddf5ec5c22b47cd4be60d.tar.bz2 gentoobrowse-01b5159b9cd62bb64c5ddf5ec5c22b47cd4be60d.tar.xz gentoobrowse-01b5159b9cd62bb64c5ddf5ec5c22b47cd4be60d.zip | |
Filter out wildly inaccurate changelog dates, but accept long month namesgentoobrowse-1.1.0.2
| -rw-r--r-- | gentoobrowse/console/changelogs.xml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/console/changelogs.xml b/gentoobrowse/console/changelogs.xml index 0e191bf..16fe5bf 100644 --- a/gentoobrowse/console/changelogs.xml +++ b/gentoobrowse/console/changelogs.xml @@ -20,7 +20,7 @@ TRIM(l[4]) AS comment FROM ( SELECT repoid, cat, pkg, n, - REGEXP_MATCHES(r, '(\d+ *(?:jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec) \d+); (.+)? <(.+@[^ >]+)[>\s] (?:[^:]*:)? (.*)', 'i') l + REGEXP_MATCHES(r, '(\d{1,2} *(?:jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec)\w* 2\d{3}); (.+)? <(.+@[^ >]+)[>\s] (?:[^:]*:)? (.*)', 'i') l FROM ( SELECT repoid, pathparts[1] cat, pathparts[2] pkg, REGEXP_REPLACE(r, '\s+', ' ', 'g') r, ROW_NUMBER() OVER() n FROM files f, REGEXP_SPLIT_TO_TABLE(PG_READ_FILE(filename), '\n\s*\n') r |