Page MenuHomePhabricator

AWMD leader board stats tool to analyze monthly stats for patch contributors
Closed, ResolvedPublic

Assigned To
Authored By
Mar 2 2018, 8:28 AM
"Love" token, awarded by srishakatux."Like" token, awarded by Tgr."Mountain of Wealth" token, awarded by xSavitar."Love" token, awarded by rosalieper.


This tool will be used to summarize and visualize patches contributed by African Developers on a monthly basis, this will speed up the process of collecting and publishing Leader Board statistics at the end of each month.

The project is led by @samuelguebo and @D3r1ck01 is making contributions. It's an open project so anyone in the community can contribute.

Link to tool on Toolforge:
Link to the project on Gitiles (Gerrit):

Event Timeline

xSavitar triaged this task as Medium priority.Mar 2 2018, 8:28 AM
xSavitar created this task.

That's a nice idea. I will like to contribute. When you are set could you please share on our mailing list this idea and necessary resources to contribute.

@samuelguebo, maybe i'm missing something, you can add please? The link to the running prototype on Toolforge, can you add in the task description? Thanks

Have you looked at Maybe it's possible to build a dashboard on top of that.

Thanks so much for this link @Tgr. We would definitely have a look and see how we can build an interface on it. So far, this is what we have: at the moment. We'll get to you for any questions when looking at the link you provided. Thanks.

In T188705#4018477, @D3r1ck01 wrote:

We'll get to you for any questions when looking at the link you provided. Thanks.

Nah, please ask on instead, as private questions do not scale. :)

@@D3r1ck01: I fail to find the source code of (which might be a policy violation) so I wonder how it defines the data scope. Hardcoded list of user names? Hardcoded list of repositories? Pointers to the code welcome.

Hey @Aklapper, ooh yes, thanks so much for this, I totally agree with you on, personal questions really do not scale ! :) @samuelguebo and I will make sure we don't use 3rd party. The tool resides here: as the previous link was just something for test. The source codes can be found here: and the tool is open for contributions from community as it's a fresh project :)

So if I interpret correctly, the user names are hardcoded?
If that's correct, here is a link covering activity in Wikimedia Gerrit in the last year (I could not find Alhassane though in the database behind though):

See for info on the user interface (filtering, changing the time frame, etc).

@Aklapper thanks for this useful link. As for Alhassane I guess his username was misspelled : alhassane, in lowrecase, is the right one.

Ah, thanks a lot for the link!! I couldn't find him because my last local database dump here that I used for searching is from 2018-02-19.
Updated query that now includes Alhassane:

Good to hear that. Metrics are very well presented on biterg. As for Gerrit, is it using the REST API or any dump? We have been searching for ways to run queries on Gerrit dumps with no success.

@samuelguebo, any updates here? Maybe this should be closed as we've already got a prototype?

@D3r1ck01 , I agree too, we should close it.

samuelguebo updated the task description. (Show Details)