Bug#609857: Bug#609800: qa.debian.org: please add NEW queue info to madison.php
On 02/12/11 at 11:05 +0000, Iain Lane wrote:
> On Fri, Sep 16, 2011 at 05:41:05PM -0500, Raphael Geissert wrote:
> > reopen 609857
> > thanks
> > On Wednesday 27 July 2011 17:51:32 Lucas Nussbaum wrote:
> > > On 12/01/11 at 23:07 -0600, Raphael Geissert wrote:
> > > > Only a small change needs to be made to UDD and the rest is a snap.
> > >
> > > the release is there, except it's called distribution (which is not a
> > > very good name, I agree. But it's how ftpmasters call it).
> > My request still stands. I don't want to duplicate code in madison.cgi just to
> > cope with that name.
> > If you don't want to modify that schema please consider adding a view.
> Righto, how are these?
> CREATE OR REPLACE TEMPORARY VIEW new_sources_debian AS SELECT source,
> version, component, distribution AS release, TEXT 'debian' AS
> distribution FROM new_sources;
> CREATE OR REPLACE TEMPORARY VIEW new_packages_debian AS SELECT
> package, version, distribution AS release, architecture, component,
> TEXT 'debian'AS distribution from new_packages;
> Is that what you need?
(I'm OK with a view being added.)