Author: neronus-guest Date: 2008-06-26 20:58:53 +0000 (Thu, 26 Jun 2008) New Revision: 900
Modified: udd/src/popcon_gatherer.py udd/src/setup-db.sql Log: * A little (2 lines) documentation for popcon_gatherer * three new indice * Faster popcon_max Modified: udd/src/popcon_gatherer.py =================================================================== --- udd/src/popcon_gatherer.py 2008-06-26 14:34:18 UTC (rev 899) +++ udd/src/popcon_gatherer.py 2008-06-26 20:58:53 UTC (rev 900) @@ -1,3 +1,10 @@ +#!/usr/bin/env python + +""" +This script imports the popcon data into the database +See http://popcon.debian.org/ +""" + import aux import sys import gzip Modified: udd/src/setup-db.sql =================================================================== --- udd/src/setup-db.sql 2008-06-26 14:34:18 UTC (rev 899) +++ udd/src/setup-db.sql 2008-06-26 20:58:53 UTC (rev 900) @@ -29,19 +29,10 @@ popcon.name = packages.package GROUP BY sources.package; -CREATE VIEW popcon_sum AS - SELECT sources.package, sum(vote) AS vote, sum(olde) AS old, sum(recent) AS recent, sum(nofiles) as nofiles - FROM sources, popcon, - (SELECT DISTINCT packages.package, packages.source FROM packages) as packages - WHERE sources.release = 'sid' AND - packages.source = sources.package AND - popcon.name = packages.package - GROUP BY sources.package; CREATE VIEW popcon_max AS SELECT sources.package, max(vote) AS vote, max(olde) AS old, max(recent) AS recent, max(nofiles) as nofiles - FROM sources, popcon, - (SELECT DISTINCT packages.package, packages.source FROM packages) as packages + FROM sources, popcon, packages WHERE sources.release = 'sid' AND packages.source = sources.package AND popcon.name = packages.package @@ -51,7 +42,10 @@ CREATE INDEX pkgs_name_idx ON Packages (Package); CREATE INDEX sources_id_idx ON sources (Package); CREATE INDEX pkgs_src_id_idx ON Packages USING btree (Source); -CREATE INDEX popcon_name ON popcon (name); +CREATE INDEX popcon_name_idx ON popcon (name); +CREATE INDEX sources_distribution_idx on sources(distribution); +CREATE INDEX sources_release_idx on sources(release); +CREATE INDEX sources_component_idx on sources(component); GRANT SELECT ON Packages TO PUBLIC; GRANT SELECT ON sources TO PUBLIC; _______________________________________________ Collab-qa-commits mailing list [email protected] http://lists.alioth.debian.org/mailman/listinfo/collab-qa-commits
