diff options
| author | randomdan <randomdan@localhost> | 2010-06-09 23:23:40 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2010-06-09 23:23:40 +0000 |
| commit | 4cd0393f15a95e00f6172d29633fdc0cea51f548 (patch) | |
| tree | bee4fb6aa70427396e6aed6b5a748c8a4f92cd0a /gentoobrowse/views | |
| parent | Initial workings of project2 - renders gentoobrowse homepage (diff) | |
| download | gentoobrowse-4cd0393f15a95e00f6172d29633fdc0cea51f548.tar.bz2 gentoobrowse-4cd0393f15a95e00f6172d29633fdc0cea51f548.tar.xz gentoobrowse-4cd0393f15a95e00f6172d29633fdc0cea51f548.zip | |
Port of gentoobrowse to project, WIP
Diffstat (limited to 'gentoobrowse/views')
| -rw-r--r-- | gentoobrowse/views/newebuilds.xml | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/gentoobrowse/views/newebuilds.xml b/gentoobrowse/views/newebuilds.xml new file mode 100644 index 0000000..d27ee70 --- /dev/null +++ b/gentoobrowse/views/newebuilds.xml @@ -0,0 +1,16 @@ +<?xml version="1.0"?> +<block xmlns:xi="http://www.w3.org/2001/XInclude"> + <xi:include href="../datasources/postgres.xml" /> + <sqlview name="newebuilds" recordname="ebuild" datasource="postgres"> + <sql> + SELECT filename, EXTRACT('day' FROM NOW() - f.firstseen) AS age, description, + moddate, p.name AS pkgname, c.name AS catname + FROM ebuilds e, files f, packages p, categories c + WHERE e.ebuildid = f.fileid + AND e.packageid = p.packageid + AND p.categoryid = c.categoryid + AND f.firstseen > DATE_TRUNC('day', NOW()) - INTERVAL '3 days' + ORDER BY c.name, p.name, e.versioninst + </sql> + </sqlview> +</block> |