Author: neronus-guest
Date: 2008-07-28 13:59:38 +0000 (Mon, 28 Jul 2008)
New Revision: 952
Modified:
udd/src/setup-db.sql
Log:
Edited popcon_src_* to work for every distribution, not only for debian
Modified: udd/src/setup-db.sql
===================================================================
--- udd/src/setup-db.sql 2008-07-28 13:23:55 UTC (rev 951)
+++ udd/src/setup-db.sql 2008-07-28 13:59:38 UTC (rev 952)
@@ -48,22 +48,21 @@
CREATE VIEW popcon_src_average AS
SELECT sources.package, avg(vote) AS vote, avg(olde) AS old, avg(recent) AS
recent, avg(nofiles) as nofiles, sources.distribution
FROM sources, popcon,
- (SELECT DISTINCT packages.package, packages.source FROM packages
WHERE packages.distribution = 'debian') as packages
- WHERE sources.release = 'sid' AND
+ (SELECT DISTINCT packages.package, packages.source FROM packages) as
packages
+ WHERE
packages.source = sources.package AND
popcon.name = packages.package AND
- popcon.distribution = 'debian'
+ popcon.distribution = sources.distribution
GROUP BY sources.package, sources.distribution;
-
CREATE VIEW popcon_src_max AS
SELECT sources.package, max(vote) AS vote, max(olde) AS old, max(recent) AS
recent, max(nofiles) as nofiles, sources.distribution
- FROM sources, popcon, packages
- WHERE sources.release = 'sid' AND
- packages.distribution = 'debian' AND
+ FROM sources, popcon,
+ (SELECT DISTINCT packages.package, packages.source FROM packages) as
packages
+ WHERE
packages.source = sources.package AND
popcon.name = packages.package AND
- popcon.distribution = 'debian'
+ popcon.distribution = sources.distribution
GROUP BY sources.package, sources.distribution;
CREATE INDEX pkgs_src_id_idx ON Packages USING btree (Source);
_______________________________________________
Collab-qa-commits mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/collab-qa-commits
