[Teammetrics-discuss] Bugs metric

[Andreas Tille]

On Fri, Jul 27, 2012 at 11:13:18PM +0530, Vipin Nair wrote:
> 
> My local db clone does not have bug_closer_names_of_pkg_group function
> defined. How do I get bug_close_history.py to run?

$ grep names_of_pkggroup * 2>/dev/null
bug_close_history.py:    query = "SELECT replace(uploader,' ','_') AS uploader FROM %s_names_of_pkggroup('%s', %i) AS (uploader text);" % (sql_procedure_prefix, teams[team], MAXUPLOADERS)
bug_close_history.py:             'SELECT * FROM %s_names_of_pkggroup(''%s'', %i) AS (category text)'
bug_close_history.py:             'SELECT * FROM %s_names_of_pkggroup(''%s'', %i) AS (category text)'
closed_bugs.sql:CREATE OR REPLACE FUNCTION bug_closer_names_of_pkggroup(text, int) RETURNS SETOF RECORD AS $$
closed_bugs.sql:SELECT * FROM bug_closer_names_of_pkggroup('debian-med-packaging at lists.alioth.debian.org',50) AS (name text);
closed_bugs.sql:SELECT * FROM bug_closer_names_of_pkggroup('debian-science-maintainers at lists.alioth.debian.org',50) AS (name text);
create_names_prefered.sql:CREATE OR REPLACE FUNCTION active_uploader_names_of_pkggroup(text, int) RETURNS SETOF RECORD AS $$
create_names_prefered.sql:SELECT * FROM active_uploader_names_of_pkggroup('debian-med-packaging at lists.alioth.debian.org',50) AS (name text);
create_names_prefered.sql:SELECT * FROM active_uploader_names_of_pkggroup('debian-science-maintainers at lists.alioth.debian.org',50) AS (name text);
upload_history.py:    query = "SELECT replace(uploader,' ','_') AS uploader FROM %s_names_of_pkggroup('%s', %i) AS (uploader text);" % (sql_procedure_prefix, teams[team], MAXUPLOADERS)
upload_history.py:             'SELECT * FROM %s_names_of_pkggroup(''%s'', %i) AS (category text)'
upload_history.py:             'SELECT * FROM %s_names_of_pkggroup(''%s'', %i) AS (category text)'

So the solution is:

   psql udd < closed_bugs.sql

Have fun and do not hesitate to keep on asking in case something might
remain unclear.

> PS: I successfully implemented uploads API :)

Great.

Kind regards

       Andreas. 

-- 
http://fam-tille.de