Author: tille
Date: Fri Feb 4 14:44:21 2011
New Revision: 2653
URL: http://svn.debian.org/wsvn/blends/?sc=1&rev=2653
Log:
Handle gzipped data from old blends commit, unique user Steve M. Robbins
Modified:
blends/trunk/team_analysis_tools/get-archive-pages
Modified: blends/trunk/team_analysis_tools/get-archive-pages
URL:
http://svn.debian.org/wsvn/blends/blends/trunk/team_analysis_tools/get-archive-pages?rev=2653&op=diff
==============================================================================
--- blends/trunk/team_analysis_tools/get-archive-pages (original)
+++ blends/trunk/team_analysis_tools/get-archive-pages Fri Feb 4 14:44:21 2011
@@ -443,10 +443,10 @@
$datain->finish;
# Insert old data from blends-commit list which had a badly configured SVN
hook so that the parsing algorithm above did not worked
-# FIXME: Should use rather PWD to obtain directory
-$datain = $dbh->prepare_cached("COPY listarchive FROM
'/home/tille/debian-maintain/liststats/blends-commit_old.dat' ;");
-$datain->execute();
-$datain->finish;
+# $datain = $dbh->prepare_cached("COPY listarchive FROM
'/home/tille/debian-maintain/liststats/blends-commit_old.dat' ;");
+#$datain->execute();
+#$datain->finish;
+system("zcat blends-commit_old.dat.gz | psql listarchives -c 'COPY listarchive
FROM STDIN'")
# It turned out that several people are posting under different names
# This is fixed for active posters to keep the stats clean
@@ -469,64 +469,64 @@
$query = $query . "UPDATE listarchive SET author = 'Sven LUTHER'
WHERE project = 'ocaml-maint' AND author = 'Sven';" ;
$query = $query . "UPDATE listarchive SET author = 'Sven LUTHER'
WHERE author = 'Sven Luther';" ;
$query = $query . "UPDATE listarchive SET author = 'Steffen Möller'
WHERE author = 'smoe-guest' OR author = 'moeller' OR author = 'Steffen
Moeller';" ;
-$query = $query . "UPDATE listarchive SET author = 'Steve M. Robbins'
WHERE author = 'smr' or author = 'Steve M . Robbins' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Charles Plessy'
WHERE author = 'plessy' OR author = 'charles-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'David Paleino'
WHERE author = 'hanska-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Nelson A. de Oliveira'
WHERE author = 'naoliv';" ;
-$query = $query . "UPDATE listarchive SET author = 'Andreas Tille'
WHERE author = 'tille' OR author = 'tillea' OR author = 'TilleA';" ;
-$query = $query . "UPDATE listarchive SET author = 'Thijs Kinkhorst'
WHERE author = 'thijs';" ;
-$query = $query . "UPDATE listarchive SET author = 'Mathieu Malaterre'
WHERE author = 'malat-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Morten Kjeldgaard'
WHERE author = 'mok0-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Tobias Quathamer'
WHERE author = 'Tobias Toedter';" ;
-$query = $query . "UPDATE listarchive SET author = 'J.H.M. Dassen'
WHERE author = 'J.H.M.Dassen';" ;
-$query = $query . "UPDATE listarchive SET author = 'L. V. Gandhi'
WHERE author = 'L . V . Gandhi' OR author = 'L.V.Gandhi';" ;
-$query = $query . "UPDATE listarchive SET author = 'Jelmer Vernooij'
WHERE author = 'ctrlsoft-guest' OR author = 'jelmer';" ;
-$query = $query . "UPDATE listarchive SET author = 'Mathieu Parent'
WHERE author = 'mparent-guest' OR author = 'Mathieu PARENT' or author =
'sathieu';" ;
-$query = $query . "UPDATE listarchive SET author = 'Noèl Köthe'
WHERE author = 'Noel Koethe' OR author = 'noel';" ;
-$query = $query . "UPDATE listarchive SET author = 'Dominique Belhachemi'
WHERE author = 'domibel-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Philipp Benner'
WHERE author = 'pbenner-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Sylvestre Ledru'
WHERE author = 'sylvestre-guest' OR author = 'sylvestre' OR author =
'sylvestre.ledru' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Christophe Prud_homme'
WHERE author = 'prudhomm' OR author = 'prudhomm-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Torsten Werner'
WHERE author = 'twerner';" ;
-$query = $query . "UPDATE listarchive SET author = 'Jan Beyer'
WHERE author = 'beathovn-guest' OR author = 'jan\@beathovn.de';" ;
-$query = $query . "UPDATE listarchive SET author = 'Filippo Rusconi'
WHERE author = 'Filippo Rusconi (Debian Maintainer)' OR author = 'rusconi';" ;
-$query = $query . "UPDATE listarchive SET author = 'Daniel Leidert'
WHERE author = 'Daniel Leidert (dale)' OR author = 'dleidert-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Michael Banck'
WHERE author = 'mbanck';" ;
-$query = $query . "UPDATE listarchive SET author = 'Guido Günther'
WHERE author = 'Guido Günther' OR author = 'Guido Guenther';" ;
-$query = $query . "UPDATE listarchive SET author = 'Ahmed El-Mahmoudy'
WHERE author like '%Ahmed El-Mahmoudy%' OR author = 'aelmahmoudy-guest';" ;
-$query = $query . "UPDATE listarchive SET author = 'Branden Robinson'
WHERE author like 'Branden Robinson%' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'LI Daobing'
WHERE author = 'lidaobing-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Nicholas Breen'
WHERE author = 'nbreen-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Egon Willighagen'
WHERE author = 'egonw-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Jordan Mantha'
WHERE author = 'laserjock-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Eric Sharkey'
WHERE author = 'sharkey' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Fabio Tranchitella'
WHERE author = 'kobold' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Petter Reinholdtsen'
WHERE author = 'pere' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Andreas Putzo'
WHERE author = 'nd-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Giovanni Mascellani'
WHERE author = 'gmascellani-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Paul Wise'
WHERE author = 'pabs' OR author = 'pabs-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Alan Boudreault'
WHERE author = 'aboudreault-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Reinhard Tartler'
WHERE author = 'siretart' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Alessio Treglia'
WHERE author = 'quadrispro-guest' OR author = 'alessio';" ;
-$query = $query . "UPDATE listarchive SET author = 'M. Christophe Mutricy'
WHERE author = 'xtophe-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Jonas Smedegaard'
WHERE author = 'js' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'JaromÃr MikeÅ¡'
WHERE author = 'mira-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Adrian Knoth'
WHERE author = 'adiknoth-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Andres Mejia'
WHERE author = 'ceros-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Fabian Greffrath'
WHERE author = 'fabian-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Loïc Minier'
WHERE author = 'lool-guest' OR author = 'lool' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Benjamin Drung'
WHERE author = 'bdrung-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Yaroslav Halchenko'
WHERE author = 'yoh-guest' OR author = 'yoh' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Samuel Thibault'
WHERE author = 'sthibaul-guest' OR author = 'sthibault';" ;
-$query = $query . "UPDATE listarchive SET author = 'Andrew Lee'
WHERE author = 'ajqlee' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'David Bremner'
WHERE author = 'bremner-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Christian Kastner'
WHERE author = 'chrisk' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Christopher Walker'
WHERE author = 'cjw1006-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Michael Hanke'
WHERE author = 'mhanke-guest' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Alastair McKinstry'
WHERE author = 'mckinstry' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Otavio Salvador'
WHERE author = 'otavio' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Frederic Lehobey'
WHERE author = 'fdl-guest' or author = 'Frederic Daniel Luc Lehobey' ;" ;
-$query = $query . "UPDATE listarchive SET author = 'Sylvain Le Gall'
WHERE author = 'Sylvain LE GALL' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Steven M. Robbins'
WHERE author = 'smr' or author like 'Steve%Robbins';" ;
+$query = $query . "UPDATE listarchive SET author = 'Charles Plessy'
WHERE author = 'plessy' OR author = 'charles-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'David Paleino'
WHERE author = 'hanska-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Nelson A. de Oliveira'
WHERE author = 'naoliv';" ;
+$query = $query . "UPDATE listarchive SET author = 'Andreas Tille'
WHERE author = 'tille' OR author = 'tillea' OR author = 'TilleA';" ;
+$query = $query . "UPDATE listarchive SET author = 'Thijs Kinkhorst'
WHERE author = 'thijs';" ;
+$query = $query . "UPDATE listarchive SET author = 'Mathieu Malaterre'
WHERE author = 'malat-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Morten Kjeldgaard'
WHERE author = 'mok0-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Tobias Quathamer'
WHERE author = 'Tobias Toedter';" ;
+$query = $query . "UPDATE listarchive SET author = 'J.H.M. Dassen'
WHERE author = 'J.H.M.Dassen';" ;
+$query = $query . "UPDATE listarchive SET author = 'L. V. Gandhi'
WHERE author = 'L . V . Gandhi' OR author = 'L.V.Gandhi';" ;
+$query = $query . "UPDATE listarchive SET author = 'Jelmer Vernooij'
WHERE author = 'ctrlsoft-guest' OR author = 'jelmer';" ;
+$query = $query . "UPDATE listarchive SET author = 'Mathieu Parent'
WHERE author = 'mparent-guest' OR author = 'Mathieu PARENT' or author =
'sathieu';" ;
+$query = $query . "UPDATE listarchive SET author = 'Noèl Köthe'
WHERE author = 'Noel Koethe' OR author = 'noel';" ;
+$query = $query . "UPDATE listarchive SET author = 'Dominique Belhachemi'
WHERE author = 'domibel-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Philipp Benner'
WHERE author = 'pbenner-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Sylvestre Ledru'
WHERE author = 'sylvestre-guest' OR author = 'sylvestre' OR author =
'sylvestre.ledru' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Christophe Prud_homme'
WHERE author = 'prudhomm' OR author = 'prudhomm-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Torsten Werner'
WHERE author = 'twerner';" ;
+$query = $query . "UPDATE listarchive SET author = 'Jan Beyer'
WHERE author = 'beathovn-guest' OR author = 'jan\@beathovn.de';" ;
+$query = $query . "UPDATE listarchive SET author = 'Filippo Rusconi'
WHERE author = 'Filippo Rusconi (Debian Maintainer)' OR author = 'rusconi';" ;
+$query = $query . "UPDATE listarchive SET author = 'Daniel Leidert'
WHERE author = 'Daniel Leidert (dale)' OR author = 'dleidert-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Michael Banck'
WHERE author = 'mbanck';" ;
+$query = $query . "UPDATE listarchive SET author = 'Guido Günther'
WHERE author = 'Guido Günther' OR author = 'Guido Guenther';" ;
+$query = $query . "UPDATE listarchive SET author = 'Ahmed El-Mahmoudy'
WHERE author like '%Ahmed El-Mahmoudy%' OR author = 'aelmahmoudy-guest';" ;
+$query = $query . "UPDATE listarchive SET author = 'Branden Robinson'
WHERE author like 'Branden Robinson%' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'LI Daobing'
WHERE author = 'lidaobing-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Nicholas Breen'
WHERE author = 'nbreen-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Egon Willighagen'
WHERE author = 'egonw-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Jordan Mantha'
WHERE author = 'laserjock-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Eric Sharkey'
WHERE author = 'sharkey' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Fabio Tranchitella'
WHERE author = 'kobold' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Petter Reinholdtsen'
WHERE author = 'pere' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Andreas Putzo'
WHERE author = 'nd-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Giovanni Mascellani'
WHERE author = 'gmascellani-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Paul Wise'
WHERE author = 'pabs' OR author = 'pabs-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Alan Boudreault'
WHERE author = 'aboudreault-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Reinhard Tartler'
WHERE author = 'siretart' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Alessio Treglia'
WHERE author = 'quadrispro-guest' OR author = 'alessio';" ;
+$query = $query . "UPDATE listarchive SET author = 'M. Christophe Mutricy'
WHERE author = 'xtophe-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Jonas Smedegaard'
WHERE author = 'js' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'JaromÃr MikeÅ¡'
WHERE author = 'mira-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Adrian Knoth'
WHERE author = 'adiknoth-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Andres Mejia'
WHERE author = 'ceros-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Fabian Greffrath'
WHERE author = 'fabian-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Loïc Minier'
WHERE author = 'lool-guest' OR author = 'lool' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Benjamin Drung'
WHERE author = 'bdrung-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Yaroslav Halchenko'
WHERE author = 'yoh-guest' OR author = 'yoh' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Samuel Thibault'
WHERE author = 'sthibaul-guest' OR author = 'sthibault';" ;
+$query = $query . "UPDATE listarchive SET author = 'Andrew Lee'
WHERE author = 'ajqlee' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'David Bremner'
WHERE author = 'bremner-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Christian Kastner'
WHERE author = 'chrisk' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Christopher Walker'
WHERE author = 'cjw1006-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Michael Hanke'
WHERE author = 'mhanke-guest' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Alastair McKinstry'
WHERE author = 'mckinstry' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Otavio Salvador'
WHERE author = 'otavio' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Frederic Lehobey'
WHERE author = 'fdl-guest' or author = 'Frederic Daniel Luc Lehobey' ;" ;
+$query = $query . "UPDATE listarchive SET author = 'Sylvain Le Gall'
WHERE author = 'Sylvain LE GALL' ;" ;
$query = $query . "UPDATE listarchive SET author = 'Hans-Christoph Steiner'
WHERE author = 'eighthave-guest' ;" ;
# stupid spammers at project = 'pkg-grass-devel'
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/blends-commit
