[Teammetrics-discuss] Please update updatenames.py

[Andreas Tille]

Hi Sukhbir,

I did not verified whether it is now possible to call updatenames.py
from shell to fix some names without running any other code as I asked
for in 

    http://lists.alioth.debian.org/pipermail/teammetrics-discuss/2011-November/000622.html

When doing my last run of my old code (I think it was actually the last
run because the webparser perfectly fits the results - it is probably
even better because it seems to fetch some more messages I obviosely
missed) I needed to do some more name replacements.  I'm simply attaching
the SQL statements I issued to fix the old database which will probably
not harm on the new database as well.

In the end I decided to use 'ILIKE' in any case and we need to accept
more than one ILIKE statement connected by OR.  I think I previousely
suggested to always use (I)LIKE and not "author =" because if we leave
out any '%' character in the expression it is defacto a "=" and you can
simplify the code.  It also might make sense to move the replacement
strings into a separate file which is just read by updatenames.py and
this finally would be a configuration file and thus belongs to
/etc/teammetrics.

So if I try to stick to the attached examples an input file say

   /etc/teammetrics/changed_names.conf

could look like:

'Joost van Baal':		'Joost van Baal%', 'joostvb'
'Michael Hanke':		'mhanke-guest', 'mih'
'Mechtilde Stehmann':		'Mechtilde'
'Gonéri Le Bouder':		'Gon%ri Le Bouder'
'Frédéric-Emmanuel PICCA':	'Picca Fr%d%ric%', 'Fr%d%ric% PICCA', 'picca'

This file should be read by updatenames.py and turned into the
following statements

UPDATE listarchives SET name = 'Joost van Baal'         WHERE name ILIKE 'Joost van Baal%' OR name ILIKE 'joostvb' ;
UPDATE listarchives SET name = 'Michael Hanke'          WHERE name ILIKE 'mhanke-guest' OR name ILIKE 'mih' ;
UPDATE listarchives SET name = 'Mechtilde Stehmann'     WHERE name ILIKE 'Mechtilde'
UPDATE listarchives SET name = 'Gonéri Le Bouder'       WHERE name ILIKE 'Gon%ri Le Bouder' ;
UPDATE listarchives SET name = 'Frédéric-Emmanuel PICCA' WHERE name ILIKE 'Picca Fr%d%ric%' OR name ILIKE 'Fr%d%ric% PICCA' OR name ILIKE 'picca';

IMHO there is no need to call updatenames.py in the middle of any
archive gathering run but just at the end of each script which gathers
data.

Kind regards

        Andreas.

-- 
http://fam-tille.de
-------------- next part --------------
-- <new>
UPDATE listarchives SET name = 'Joost van Baal'         WHERE name like 'Joost van Baal%' OR name = 'joostvb' ;
UPDATE listarchives SET name = 'Michael Hanke'          WHERE name = 'mhanke-guest' OR name = 'mih' ;
UPDATE listarchives SET name = 'Mechtilde Stehmann'     WHERE name = 'Mechtilde' AND project = 'lex' ;
UPDATE listarchives SET name = 'Gonéri Le Bouder'       WHERE name like 'Gon%ri Le Bouder' ;

--  updated at 5.1.2012
UPDATE listarchives SET name = 'Johannes Ring'          WHERE name like 'johannr-guest' ;
UPDATE listarchives SET name = 'Christophe Trophime'    WHERE name LIKE 'trophime%' OR name LIKE 'christophe.trophime' ;
UPDATE listarchives SET name = 'Frédéric-Emmanuel PICCA' WHERE name ILIKE 'Picca Fr%d%ric%' OR name ILIKE 'Fr%d%ric% PICCA' OR name like 'picca';
UPDATE listarchives SET name = 'Pierre Saramito'        WHERE name ILIKE 'saramito-guest' ;
UPDATE listarchives SET name = 'Gudjon I. Gudjonsson'   WHERE name ILIKE 'gudjon-guest' ;
UPDATE listarchives SET name = 'Ko van der Sloot'       WHERE name ILIKE 'sloot-guest' ;
UPDATE listarchives SET name = 'Sargis Dallakyan'       WHERE name ILIKE 'sargis' OR name ILIKE 'sargis-guest' ;
UPDATE listarchives SET name = 'Nicholas Breen'         WHERE name ILIKE 'nbreen%';
UPDATE listarchives SET name = 'Karol M. Langner'       WHERE name ILIKE 'kml-guest' OR name ILIKE 'Karol Langner';
UPDATE listarchives SET name = 'Ben Armstrong'          WHERE name ILIKE 'synrg';
UPDATE listarchives SET name = 'Bart Cornelis'          WHERE name ILIKE 'cobaco%' ;
UPDATE listarchives SET name = 'Jordà Polo'             WHERE name ILIKE 'Jord% Polo' ;
UPDATE listarchives SET name = 'Bruno "Fuddl" Kleinert' WHERE name ILIKE  'Bruno%Fuddl%' ;
UPDATE listarchives SET name = 'IOhannes M. Zmölnig'    WHERE name ILIKE '%zmoelnig%' ;
UPDATE listarchives SET name = 'Benjamin Drung'         WHERE name ILIKE '%bdrung%' ;
UPDATE listarchives SET name = 'Felipe Sateler'         WHERE name ILIKE 'fsateler%' ;
UPDATE listarchives SET name = 'Maia Kozheva'           WHERE name ILIKE 'lucidfox%' OR name ILIKE 'Sikon' ;
UPDATE listarchives SET name = 'Matteo F. Vescovi'      WHERE name ILIKE 'mfv%' OR name ILIKE 'Matteo%Vescovi';
UPDATE listarchives SET name = 'Alessandro Ghedini'     WHERE name ILIKE 'ghedo%' ;
UPDATE listarchives SET name = 'Alexandre Quessy'       WHERE name ILIKE 'alexandrequessy%' ;
UPDATE listarchives SET name = 'Ryan Kavanagh'          WHERE name ILIKE 'ryanakca%' ;
UPDATE listarchives SET name = 'Roman Haefeli'          WHERE name ILIKE 'rdz%' ;
UPDATE listarchives SET name = 'Free Ekanayaka'         WHERE name ILIKE 'freee%' ;
UPDATE listarchives SET name = 'Matthias Klumpp'        WHERE name ILIKE 'ximion%' ;
UPDATE listarchives SET name = 'Rosea Grammostola'      WHERE name ILIKE 'rosea-%' OR name ILIKE 'rosea%grammosto%a' OR name ILIKE 'Grammostola Rosea' OR name ILIKE 'rosea';
UPDATE listarchives SET name = 'Andriy Beregovenko'     WHERE name ILIKE 'jet-guest' ;
UPDATE listarchives SET name = 'Philippe Coval'         WHERE name ILIKE 'rzr-guest' OR name ILIKE 'Philippe COVAL' ;
UPDATE listarchives SET name = 'Miguel Colon'           WHERE name ILIKE 'micove-%' ;
UPDATE listarchives SET name = 'Sebastian Dröge'        WHERE name ILIKE 'slomo' ;
UPDATE listarchives SET name = 'Harry Rickards'         WHERE name ILIKE 'hrickards%' OR name ILIKE 'Harry RIckards' ;
UPDATE listarchives SET name = 'Jordi Gutiérrez Hermoso' WHERE name ILIKE '%Jord%G%t%rrez%Hermoso%' ;
UPDATE listarchives SET name = 'Felipe Augusto van de Wiel' WHERE name ILIKE 'Felipe Augusto van de Wiel%' ;

-- </new>