Last modified: 2014-10-23 20:41:41 UTC
https://groups.google.com/group/repo-discuss/msg/c426b6a83400b58e?dmode=source&pli=1 Create and automatically update a list of the users in Gerrits (by username + auto-obfuscated email addresses) that links to that user's changesets and Gerrit reviews. Examples of requested functionality: https://www.mediawiki.org/wiki/Developers and http://toolserver.org/~krinkle/wikimedia-svn-users.php .
It would also be great if this list could also explain what Gerrit projects the user is an owner of but that is probably impracticable.
I'd prefer for this list to live within MediaWiki.org, but it could live on Labs or be on gerrit.wikimedia.org like https://gerrit.wikimedia.org/mediawiki-extensions.txt .
The userlist in labsconsole is also the gerrit user list. It would be awesome if we had user profiles, then we could have the user's profile link to their gerrit contributions. We could also semantically annotate it, so that we can have a query that pulls them all into a paged table.
(In reply to comment #3) > The userlist in labsconsole is also the gerrit user list. > > It would be awesome if we had user profiles, then we could have the user's > profile link to their gerrit contributions. We could also semantically annotate > it, so that we can have a query that pulls them all into a paged table. That would be so totally awesome. Having developer profiles would also eliminate the need for USERINFO files.
unassigning hashar.
This request is for us to hack something by generating a user page based on the Gerrit database, per the instructions in https://groups.google.com/group/repo-discuss/msg/c426b6a83400b58e?dmode=source&pli=1 .
From Sumanah, tip about how to get a list of user is at : https://groups.google.com/group/repo-discuss/msg/c426b6a83400b58e Aka: gerrit gsql --format PRETTY -c "select full_name,preferred_email from accounts" This can be done in a way similar to https://gerrit.wikimedia.org/mediawiki-extensions.txt , have a look at: operations/puppet.git manifests/gerrit.pp class gerrit::crons The cron generating the list of extensions is list_mediawiki_extensions. Just need to add a new cron there ;-)
Putting back Chad. I had a collision.
* https://www.mediawiki.org/wiki/Developers * https://toolserver.org/~krinkle/wikimedia-svn-users.php * https://www.mediawiki.org/wiki/Special:Code/MediaWiki/author
(In reply to comment #7) > From Sumanah, tip about how to get a list of user is at : > https://groups.google.com/group/repo-discuss/msg/c426b6a83400b58e > > Aka: > gerrit gsql --format PRETTY -c "select full_name,preferred_email from accounts" > You sure about that? $ ssh -p 29418 gerrit.wikimedia.org gerrit gsql --format PRETTY -c "select full_name,preferred_email from accounts" fatal: No argument is allowed: full_name,preferred_email
Ignore me.
That's a LDAP query.
Upstream http://code.google.com/p/gerrit/issues/detail?id=1709 is about ssh -p 29418 aklapper@gerrit.wikimedia.org gerrit ls-users similar to already existing ssh -p 29418 aklapper@gerrit.wikimedia.org gerrit ls-projects
Considering this request under the possibility that this proposal goes further: http://www.mediawiki.org/wiki/User:Qgil/Contributors All MediaWiki users at http://wikitech.wikimedia.org have a connected Gerrit account, right? If so, the list of Gerrit users == the list of Wikitech users already today. What other information/permissions has Gerrit about a user, and would there be a way to pass that information to the corresponding MediaWiki profile? Interesting data could be: * Users with admin rights? * Users with +2 / -2 for all projects. From a project perspective: * Who has +2 / -2 rights for this project. * Who has contributed code to this project. * Who has reviewed code for this project.
Getting closer through tech community metrics: Top Gerrit closers: http://korma.wmflabs.org/browser/scr.html Siebrand stats: http://korma.wmflabs.org/browser/people.html?id=21&name=Siebrand
(In reply to comment #15) > Getting closer through tech community metrics: > > Top Gerrit closers: > http://korma.wmflabs.org/browser/scr.html > > Siebrand stats: > http://korma.wmflabs.org/browser/people.html?id=21&name=Siebrand What's the thing with the 5000 units peak in March?
Still not perfect but http://korma.wmflabs.org/browser/contributors.html shows a list of all the Gerrit users that got at least one patch merged. (In reply to comment #16) > What's the thing with the 5000 units peak in March? Probably related to Bug 58349 - Graph of pending reviews in Gerrit shows wrong data
I figure ECT will be able to use a list of Phabricator users once we've made the switch.
(In reply to Antoine "hashar" Musso (WMF) from comment #7) > From Sumanah, tip about how to get a list of user is at : > https://groups.google.com/group/repo-discuss/msg/c426b6a83400b58e > > Aka: > gerrit gsql --format PRETTY -c "select full_name,preferred_email from > accounts" > > This can be done in a way similar to > https://gerrit.wikimedia.org/mediawiki-extensions.txt , have a look at: > operations/puppet.git > manifests/gerrit.pp > class gerrit::crons > > The cron generating the list of extensions is list_mediawiki_extensions. > > Just need to add a new cron there ;-) (In reply to Chad H. from comment #10) > (In reply to comment #7) > > From Sumanah, tip about how to get a list of user is at : > > https://groups.google.com/group/repo-discuss/msg/c426b6a83400b58e > > > > Aka: > > gerrit gsql --format PRETTY -c "select full_name,preferred_email from accounts" > > > > You sure about that? > > $ ssh -p 29418 gerrit.wikimedia.org gerrit gsql --format PRETTY -c "select > full_name,preferred_email from accounts" > fatal: No argument is allowed: full_name,preferred_email To anyone trying to run this command via SSH make sure you escape the quotes around the sql statement with backslashes.
