Bug#609857: Bug#609800: qa.debian.org: please add NEW queue info to madison.php

[Lucas Nussbaum <lucas@lucas-nussbaum.net>]

On 02/12/11 at 11:05 +0000, Iain Lane wrote:
> Hi,
> 
> 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?

Raphael, ping?

(I'm OK with a view being added.)

Lucas