diff options
| author | randomdan <randomdan@localhost> | 2010-09-12 17:10:58 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-09-12 17:10:58 +0000 |
| commit | 60b9f52e6bf406701911e1f5bb533fea2bb17718 (patch) | |
| tree | 9760ad5f6d0c9419d7f238296525793b67e82348 /gentoobrowse/views | |
| parent | Import the masks (diff) | |
| download | gentoobrowse-60b9f52e6bf406701911e1f5bb533fea2bb17718.tar.bz2 gentoobrowse-60b9f52e6bf406701911e1f5bb533fea2bb17718.tar.xz gentoobrowse-60b9f52e6bf406701911e1f5bb533fea2bb17718.zip | |
Show mask status
Fix import of slot and license
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/package.xml | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/gentoobrowse/views/package.xml b/gentoobrowse/views/package.xml index a4ba735..4cb0a0d 100644 --- a/gentoobrowse/views/package.xml +++ b/gentoobrowse/views/package.xml @@ -99,5 +99,29 @@ <param bind="0" value="^packageid" /> </parameters> </project2:sqlview> + <project2:sqlview name="maskstatus" recordname="mask" datasource="postgres"> + <sql> + SELECT em.ebuildid, RANK() OVER(ORDER BY em.setno) AS setno + FROM ebuild_masks em, ebuilds e + WHERE em.ebuildid = e.ebuildid + AND e.packageid = ? + </sql> + <parameters> + <param bind="0" value="^packageid" /> + </parameters> + </project2:sqlview> + <project2:sqlview name="maskdetails" recordname="mask" datasource="postgres"> + <sql> + SELECT DISTINCT RANK() OVER(ORDER BY em.setno), ms.person, ms.message, ms.dateadded + FROM ebuild_masks em, ebuilds e, masksets ms + WHERE em.ebuildid = e.ebuildid + AND ms.setno = em.setno + AND e.packageid = ? + ORDER BY RANK() OVER(ORDER BY em.setno) + </sql> + <parameters> + <param bind="0" value="^packageid" /> + </parameters> + </project2:sqlview> </project2:sqlview> </block> |