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

[Iain Lane <laney@debian.org>]

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?

Cheers,

-- 
Iain Lane                                  [ iain@orangesquash.org.uk ]
Debian Developer                                   [ laney@debian.org ]
Ubuntu Developer                                   [ laney@ubuntu.com ]
PhD student                                       [ ial@cs.nott.ac.uk ]