Last modified: 2014-10-23 20:41:41 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T37508, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 35508 - List of Phabricator users
List of Phabricator users
Status: NEW
Product: Analytics
Classification: Unclassified
Tech community metrics (Other open bugs)
unspecified
All All
: Normal enhancement
: ---
Assigned To: Nobody - You can work on this!
: upstream
Depends on:
Blocks: 22596
  Show dependency treegraph
 
Reported: 2012-03-26 22:10 UTC by Sumana Harihareswara
Modified: 2014-10-23 20:41 UTC (History)
10 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Sumana Harihareswara 2012-03-26 22:10:07 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 .
Comment 1 Sumana Harihareswara 2012-03-26 22:11:10 UTC
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.
Comment 2 Sumana Harihareswara 2012-03-26 22:12:23 UTC
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 .
Comment 3 Ryan Lane 2012-03-27 04:04:46 UTC
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.
Comment 4 Chad H. 2012-03-27 11:23:29 UTC
(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.
Comment 5 Mark A. Hershberger 2012-03-28 19:57:36 UTC
unassigning hashar.
Comment 6 Sumana Harihareswara 2012-03-28 19:58:10 UTC
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 .
Comment 7 Antoine "hashar" Musso (WMF) 2012-03-28 20:01:48 UTC
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 ;-)
Comment 8 Antoine "hashar" Musso (WMF) 2012-03-28 20:02:40 UTC
Putting back Chad. I had a collision.
Comment 10 Chad H. 2012-05-07 11:35:54 UTC
(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
Comment 11 Chad H. 2012-05-07 11:37:50 UTC
Ignore me.
Comment 12 Platonides 2012-06-14 21:45:05 UTC
That's a LDAP query.
Comment 13 Andre Klapper 2013-02-19 22:32:16 UTC
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
Comment 14 Quim Gil 2013-03-15 04:16:56 UTC
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.
Comment 15 Quim Gil 2013-08-27 20:41:31 UTC
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
Comment 16 Nemo 2013-08-27 21:21:54 UTC
(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?
Comment 17 Quim Gil 2014-01-15 18:21:17 UTC
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
Comment 18 Sumana Harihareswara 2014-09-23 19:10:05 UTC
I figure ECT will be able to use a list of Phabricator users once we've made the switch.
Comment 19 Ben B 2014-10-23 20:41:41 UTC
(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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links