/[collab-qa]/udd/web/cgi-bin/sources_in_unstable_but_not_in_testing_by_popcon_max.cgi
ViewVC logotype

Diff of /udd/web/cgi-bin/sources_in_unstable_but_not_in_testing_by_popcon_max.cgi

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 950 by neronus-guest, Mon Jul 28 12:41:58 2008 UTC revision 966 by neronus-guest, Mon Jul 28 16:49:58 2008 UTC
# Line 8  use CGI; Line 8  use CGI;
8    
9  my $dbh = DBI->connect("dbi:Pg:dbname=udd") or die $!;  my $dbh = DBI->connect("dbi:Pg:dbname=udd") or die $!;
10  my $sth = $dbh->prepare(<<EOF  my $sth = $dbh->prepare(<<EOF
11          SELECT DISTINCT unstable.package, (vote + popcon_src_max.old + recent + nofiles) as pvote          SELECT DISTINCT unstable.package, insts
12          FROM (SELECT DISTINCT package FROM sources          FROM (SELECT DISTINCT package FROM sources
13                  WHERE distribution = 'debian' and release = 'sid')                  WHERE distribution = 'debian' and release = 'sid')
14            AS unstable,            AS unstable,
15               popcon_src_max               popcon_src_max
16          WHERE NOT EXISTS (SELECT * FROM sources WHERE distribution = 'debian'          WHERE NOT EXISTS (SELECT * FROM sources WHERE distribution = 'debian'
17                            AND release = 'lenny' and package = unstable.package)                            AND release = 'lenny' and package = unstable.package)
18                AND popcon_src_max.package = unstable.package AND popcon_src_max.distribution = 'debian' ORDER BY pvote DESC;                AND popcon_src_max.package = unstable.package AND popcon_src_max.distribution = 'debian' ORDER BY insts DESC;
19  EOF  EOF
20          );          );
21    
Legend:
Removed from v.950  
changed lines
  Added in v.966
  ViewVC Help
Powered by ViewVC 1.1.5