Sponsors - who does (not) work on FE-NEEDSPONSOR tickets

Miroslav Suchý msuchy at redhat.com
Sat Aug 15 07:13:18 UTC 2015


Recently we had discussion here about the queue of package reviews with 
FE-NEEDSPONSOR flag.
I suggested to write some script which would query db and reveal those 
sponsors who does not make his duty.

Here comes this script:
    https://github.com/xsuchy/guard-fedora-sponsors

It is first version and I'm sure there will be some false negatives. The 
current logic is:
1. query FAS to get all usernames from packager group who are sponsors
2. for each such user get all bugs from past 365 day for Package Review 
component which are assigned to this sponsor
3. give the sponsor some credit when he changed bug status (to whatever 
state) as this indicate some work on this bug
4. give the sponsor some credit if he remove FE-NEEDSPONSOR from 
blocking bugs as this indicate finishing sponsor work

This does not reflect if you sponsor somebody directly. E.g. because he 
want to be become co-maintainer and does not submit package review.

This time I run it for past year. So this script reveals those who does 
not sponsor anybody for whole year. I hope that in future I can lower 
this constant to half year or even 3 months.

Ideas, patches and comments about this script are welcome.

Dear sponsor, remember that with great power comes great responsibility. 
You should regularly visit
   http://fedoraproject.org/PackageReviewStatus/NEEDSPONSOR.html
and pick up some review. Only if this queue length is close to zero and 
people does not need to wait for sponsor, only then we can attract more 
packagers to Fedora.

And here follows the output from my script (sorted by username).

Mirek


Aurelien Bompard <abompard> done no sponsor work
Adrien Devresse <adev> done no sponsor work
Adrian Reber <adrian> done no sponsor work
Alexander Kurtakov <akurtakov> is a good guy - removed FE-NEEDSPONSOR 
from BZ 1190728
Alexander Kurtakov <akurtakov> is a good guy - removed FE-NEEDSPONSOR 
from BZ 1226926
Alexander Larsson <alexl> done no sponsor work
Axel Thimm <athimm> done no sponsor work
Dennis Gilmore <ausil> done no sponsor work
Andrea Veri <averi> done no sponsor work
Andreas Bierfert <awjb> done no sponsor work
Björn "besser82" Esser <besser82> is a good guy - removed FE-NEEDSPONSOR 
from BZ 1129677
Bohuslav "Slavek" Kabrda <bkabrda> done no sponsor work
Christian Iseli <c4chris> done no sponsor work
Christopher Aillon (sabbatical, not receiving bugmail) <caillon> done no 
sponsor work
Chitlesh GOORAH <chitlesh> done no sponsor work
Ricky Elrod <codeblock> done no sponsor work
Ralf Corsepius <corsepiu> done no sponsor work
Cole Robinson <crobinso> done no sponsor work
Chris Weyl <cweyl> done no sponsor work
Christoph Wickert <cwickert> done no sponsor work
Denis Leroy <denis> done no sponsor work
Dave Malcolm <dmalcolm> done no sponsor work
Douglas Schilling Landgraf <dougsland> is a good guy - removed 
FE-NEEDSPONSOR from BZ 1191498
David Woodhouse <dwmw2> done no sponsor work
Eduardo Echeverria <echevemaster> is a good guy - removed FE-NEEDSPONSOR 
from BZ 1141494
Michał Bentkowski <ecik> done no sponsor work
Enrico Scholz <ensc> done no sponsor work
Thomas Fitzsimmons <fitzsim> done no sponsor work
Gérard Milmeister <gemi> done no sponsor work
Marek Goldmann <goldmann> is a good guy - removed FE-NEEDSPONSOR from BZ 
1213111
Haïkel Guémar <hguemar> is a good guy - removed FE-NEEDSPONSOR from BZ 
1090933
Haïkel Guémar <hguemar> is a good guy - worked on BZ 1150504
Haïkel Guémar <hguemar> is a good guy - removed FE-NEEDSPONSOR from BZ 
1196366
Haïkel Guémar <hguemar> is a good guy - removed FE-NEEDSPONSOR from BZ 
1219540
Haïkel Guémar <hguemar> is a good guy - removed FE-NEEDSPONSOR from BZ 
1231943
Haïkel Guémar <hguemar> is a good guy - worked on BZ 1241632
Haïkel Guémar <hguemar> is a good guy - worked on BZ 1241812
Haïkel Guémar <hguemar> is a good guy - removed FE-NEEDSPONSOR from BZ 
1242011
Haïkel Guémar <hguemar> is a good guy - worked on BZ 1243048
Richard Shaw <hobbes1069> done no sponsor work
Ian Weller <ianweller> done no sponsor work
Iain Arnell <iarnell> done no sponsor work
Ignacio Vazquez-Abrams <ivazquez> done no sponsor work
Andreas Thienemann <ixs> done no sponsor work
José Matos <jamatos> is a good guy - worked on BZ 1126100
Jerry James <jjames> done no sponsor work
Jesse Keating <jkeating> done no sponsor work
John (J5) Palmieri <johnp> done no sponsor work
Jose Pedro Oliveira <jpo> done no sponsor work
Jaroslav Škarvada <jskarvad> is a good guy - removed FE-NEEDSPONSOR from 
BZ 1184040
Jef Spaleta <jspaleta> done no sponsor work
Susi Lehtola <jussilehtola> done no sponsor work
Jarod Wilson <jwilson> done no sponsor work
Hans de Goede <jwrdegoede> done no sponsor work
Kalev Lember <kalev> done no sponsor work
Karsten Hopp <karsten> done no sponsor work
Jeremy Katz <katzj> done no sponsor work
David Nalley <ke4qqq> done no sponsor work
Kevin Kofler <kkofler> done no sponsor work
Ken Dreyer <ktdreyer> done no sponsor work
Xavier Lamien <laxathom> done no sponsor work
Jon Ciesla <limb> done no sponsor work
Lubomir Rintel <lkundrak> is a good guy - removed FE-NEEDSPONSOR from BZ 
823679
Lubomir Rintel <lkundrak> is a good guy - removed FE-NEEDSPONSOR from BZ 
1162148
Lubomir Rintel <lkundrak> is a good guy - removed FE-NEEDSPONSOR from BZ 
1196289
Luke Macken <lmacken> done no sponsor work
lutter at watzmann.net <lutter> done no sponsor work
Mario Blättermann <mariobl> done no sponsor work
Mark McLoughlin <markmc> done no sponsor work
Mat Booth <mbooth> done no sponsor work
Matthias Clasen <mclasen> done no sponsor work
Matthew Booth <mdbooth> is a good guy - removed FE-NEEDSPONSOR from BZ 
1132971
Matt Domsch <mdomsch> done no sponsor work
Martin Gieseking <mgieseki> done no sponsor work
Michael Scherer <misc> is a good guy - removed FE-NEEDSPONSOR from BZ 
1100870
Mikolaj Izdebski <mizdebsk> done no sponsor work
Marek Mahut <mmahut> done no sponsor work
Matthias Runge <mrunge> done no sponsor work
Michael Schwendt (Fedora Packager Sponsors Group) <mschwendt> is a good 
guy - removed FE-NEEDSPONSOR from BZ
1193878
Michael Schwendt (Fedora Packager Sponsors Group) <mschwendt> is a good 
guy - removed FE-NEEDSPONSOR from BZ
1197505
Miroslav Suchý <msuchy> is a good guy - worked on BZ 1061732
Miroslav Suchý <msuchy> is a good guy - worked on BZ 1113301
Miroslav Suchý <msuchy> is a good guy - removed FE-NEEDSPONSOR from BZ 
1119056
Miroslav Suchý <msuchy> is a good guy - removed FE-NEEDSPONSOR from BZ 
1131616
Miroslav Suchý <msuchy> is a good guy - removed FE-NEEDSPONSOR from BZ 
1134377
Mamoru TASAKA <mtasaka> done no sponsor work
Nick Bebout <nb> done no sponsor work
Neil Horman <nhorman> done no sponsor work
Nicolas Mailhot <nim> done no sponsor work
Bill Nottingham <notting> done no sponsor work
Nils Philippsen <nphilipp> done no sponsor work
Orcan Ogetbil <oget> done no sponsor work
Orion Poplawski <orion> is a good guy - worked on BZ 1226719
Orion Poplawski <orion> is a good guy - worked on BZ 1235404
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1154213
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1154743
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1156619
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1168511
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1174288
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1182261
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1200520
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1200955
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1201325
Parag AN(पराग) <paragn> is a good guy - removed FE-NEEDSPONSOR from BZ 
1202265
T.C. Hollingsworth <patches> done no sponsor work
Peter Robinson <pbrobinson> done no sponsor work
Paulo Andrade <pcpa> is a good guy - worked on BZ 1198246
Patrice Dumas <pertusus> done no sponsor work
Peter Lemenkov <peter> done no sponsor work
Jens Petersen <petersen> done no sponsor work
Paul W. Frields <pfrields> done no sponsor work
Paul Howarth <pghmcfc> done no sponsor work
Pierre-YvesChibon <pingou> done no sponsor work
Paul Nasrat <pnasrat> done no sponsor work
Parag Nemade <pnemade> done no sponsor work
Praveen K Paladugu <praveenp> done no sponsor work
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165620
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165625
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165627
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165629
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165631
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165637
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165639
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1165641
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1234791
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1242724
Petr Šabata <psabata> is a good guy - removed FE-NEEDSPONSOR from BZ 1242727
Patrick Uiterwijk <puiterwijk> is a good guy - removed FE-NEEDSPONSOR 
from BZ 1194576
Paul Wouters <pwouters> done no sponsor work
Ralph Bean <ralph> is a good guy - removed FE-NEEDSPONSOR from BZ 1225249
Dominik 'Rathann' Mierzejewski <rathann> done no sponsor work
Rex Dieter <rdieter> is a good guy - removed FE-NEEDSPONSOR from BZ 951496
Rex Dieter <rdieter> is a good guy - removed FE-NEEDSPONSOR from BZ 1099166
Rex Dieter <rdieter> is a good guy - removed FE-NEEDSPONSOR from BZ 1117209
Rex Dieter <rdieter> is a good guy - removed FE-NEEDSPONSOR from BZ 1177038
Remi Collet <remi> done no sponsor work
Debarshi Ray <rishi> done no sponsor work
Richard W.M. Jones <rjones> done no sponsor work
Ruben Kerkhof <ruben> done no sponsor work
Radek Vokal <rvokal> done no sponsor work
Jochen Schmitt <s4504kr> done no sponsor work
Michel Alexandre Salim <salimma> is a good guy - worked on BZ 1241919
Michel Alexandre Salim <salimma> is a good guy - worked on BZ 1245845
Eric Sandeen <sandeen> done no sponsor work
Ville Skyttä <scop> done no sponsor work
Steven Dake <sdake> done no sponsor work
Stephen Gallagher <sgallagh> done no sponsor work
Dan Horák <sharkcz> is a good guy - removed FE-NEEDSPONSOR from BZ 1136972
Jeff Sheltren <sheltren> done no sponsor work
Stanislav Ochotnicky <sochotni> done no sponsor work
Steven Pritchard <steve> done no sponsor work
Steve Traylen <stevetraylen> done no sponsor work
Matthias Saou <thias> done no sponsor work
Thorsten Leemhuis <thl> done no sponsor work
Thomas Vander Stichele <thomasvs> done no sponsor work
Till Maas <till> done no sponsor work
Tim Lauridsen <timlau> done no sponsor work
Tomas Mraz <tmraz> done no sponsor work
Thomas Spura <tomspur> done no sponsor work
Toshio Ernie Kuratomi <toshio> done no sponsor work
Steven M. Parrish <tuxbrewr> done no sponsor work
Tim Waugh <twaugh> done no sponsor work
Volker Fröhlich <volter> done no sponsor work
Vít Ondruch <vondruch> is a good guy - worked on BZ 1244760
Vít Ondruch <vondruch> is a good guy - worked on BZ 1244764
Wart <wart> done no sponsor work
Will Benton <willb> done no sponsor work
manuel wolfshant <wolfy> done no sponsor work
Warren Togami <wtogami> done no sponsor work


-- 
Miroslav Suchý
Red Hat Satellite Engineering


More information about the devel mailing list