diff options
| author | randomdan <randomdan@localhost> | 2010-11-14 03:29:47 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-11-14 03:29:47 +0000 |
| commit | 50fcdea9977a29ad690cbb444b990b2d8c1092ae (patch) | |
| tree | b65ebba8d07edfba0cb1ba93f616f6c462d84082 /gentoobrowse/views | |
| parent | Remove most uses of files table from website, data now in ebuilds table (diff) | |
| download | gentoobrowse-50fcdea9977a29ad690cbb444b990b2d8c1092ae.tar.bz2 gentoobrowse-50fcdea9977a29ad690cbb444b990b2d8c1092ae.tar.xz gentoobrowse-50fcdea9977a29ad690cbb444b990b2d8c1092ae.zip | |
Populate and use new change logs table
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/package.xml | 13 |
1 files changed, 5 insertions, 8 deletions
diff --git a/gentoobrowse/views/package.xml b/gentoobrowse/views/package.xml index d526df4..cbf9dfc 100644 --- a/gentoobrowse/views/package.xml +++ b/gentoobrowse/views/package.xml @@ -157,15 +157,12 @@ <param bind="0" value="^packageid" /> </parameters> </project2:sqlview> - <project2:sqlview name="changelog" recordname="line" datasource="postgres-web"> + <project2:sqlview name="changelog" recordname="entry" datasource="postgres-web"> <sql> - SELECT line, content - FROM files f, filecache fc, packages p, categories c - WHERE f.fileid = fc.fileid - AND p.categoryid = c.categoryid - AND f.filename = c.name || '/' || p.name || '/ChangeLog' - AND p.packageid = ? - ORDER BY line + SELECT date, person, email, comment + FROM package_changelogs + WHERE packageid = ? + ORDER BY date DESC, n DESC </sql> <parameters> <param bind="0" value="^packageid" /> |