diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2016-08-07 19:28:08 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2016-08-07 19:28:08 +0100 |
| commit | e075b6e48cd7c23d8940419fe7be0878512116fe (patch) | |
| tree | a2ba2c73666c47a99a0a44a6de0ba3e61214b587 | |
| parent | Allow control of --dll-export and --ice (diff) | |
| download | gentoobrowse-1.1.3.tar.bz2 gentoobrowse-1.1.3.tar.xz gentoobrowse-1.1.3.zip | |
Use tables in GentooBrowse API DBgentoobrowse-1.1.3
| -rw-r--r-- | gentoobrowse/views/package.xml | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/gentoobrowse/views/package.xml b/gentoobrowse/views/package.xml index f4f6048..e581430 100644 --- a/gentoobrowse/views/package.xml +++ b/gentoobrowse/views/package.xml @@ -79,10 +79,11 @@ <project2:sqlrows name="packageBugs" datasource="postgres-web"> <sql> SELECT b.bugid, b.summary - FROM bugs b, package_bugs pb - WHERE b.bugid = pb.bugid + FROM bugs b, categories c, packages p + WHERE p.categoryid = c.categoryid + AND gentoobrowse.bugpackages(b) @> array[c.name || '/' || p.name] <filter name="pkg"> - AND pb.packageid = <param name="pkgid" /> + AND p.packageid = <param name="pkgid" /> </filter> ORDER BY b.bugid </sql> @@ -158,13 +159,16 @@ </project2:sqlrows> <project2:sqlrows name="changeLog" datasource="postgres-web"> <sql> - SELECT date, person, email, comment, r.name AS reponame - FROM package_changelogs c, repos r - WHERE c.repoid = r.repoid + SELECT committime AS date, authorname person, authoremail email, cl.summary AS comment, r.name AS reponame + FROM changelog cl, categories c, packages p, repos r + WHERE p.categoryid = c.categoryid + AND cl.repoid = r.repoid + AND gentoobrowse.changelogpackages(cl) @> array[c.name || '/' || p.name] <filter name="pkg"> AND packageid = <param name="pkgid" /> </filter> - ORDER BY date DESC, n DESC, c.repoid + AND cl.authoremail != 'repo-qa-checks@gentoo.org' + ORDER BY cl.committime DESC, cl.repoid </sql> </project2:sqlrows> </block> |