For use in our monthly report, due to come out tomorrow
https://www.mediawiki.org/wiki/Wikimedia_engineering_report/2012/June
I'd like to know how many unique contributors ("owners") had commits merged into the mediawiki & mediawiki/* Gerrit projects between June 1-30 inclusive. I've had luck in using "age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot" as a search on https://gerrit.wikimedia.org to get a big paginated table of all the commits (and then I figure I'd look for all the unique owner names and count them), but when I try that on the command line as
ssh -p 29418 gerrit.wikimedia.org gerrit query 'age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot'
I get the error "fatal: "-age:34d" is not a valid option".
I'll accept either help in running this query correctly so I get the giant table on the command line so I can gin up the status myself, or I will simply accept a number if you want to do my homework for me. :-)
Not sure if it produces what you actually need, but
ssh -p 29418 gerrit.wikimedia.org gerrit query 'age:4d age:-34d status:merged project:^mediawiki.* owner:L10n-bot'
does give an output...
G
On 07/05/2012 04:52 AM, Sumana Harihareswara wrote:
For use in our monthly report, due to come out tomorrow
https://www.mediawiki.org/wiki/Wikimedia_engineering_report/2012/June
I'd like to know how many unique contributors ("owners") had commits merged into the mediawiki & mediawiki/* Gerrit projects between June 1-30 inclusive. I've had luck in using "age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot" as a search on https://gerrit.wikimedia.org to get a big paginated table of all the commits (and then I figure I'd look for all the unique owner names and count them), but when I try that on the command line as
ssh -p 29418 gerrit.wikimedia.org gerrit query 'age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot'
I get the error "fatal: "-age:34d" is not a valid option".
I'll accept either help in running this query correctly so I get the giant table on the command line so I can gin up the status myself, or I will simply accept a number if you want to do my homework for me. :-)
Not sure if it produces what you actually need, but
ssh -p 29418 gerrit.wikimedia.org gerrit query 'age:4d age:-34d status:merged project:^mediawiki.* owner:L10n-bot'
does give an output...
G
On 07/05/2012 04:52 AM, Sumana Harihareswara wrote:
For use in our monthly report, due to come out tomorrow
https://www.mediawiki.org/wiki/Wikimedia_engineering_report/2012/June
I'd like to know how many unique contributors ("owners") had commits merged into the mediawiki & mediawiki/* Gerrit projects between June 1-30 inclusive. I've had luck in using "age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot" as a search on https://gerrit.wikimedia.org to get a big paginated table of all the commits (and then I figure I'd look for all the unique owner names and count them), but when I try that on the command line as
ssh -p 29418 gerrit.wikimedia.org gerrit query 'age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot'
I get the error "fatal: "-age:34d" is not a valid option".
I'll accept either help in running this query correctly so I get the giant table on the command line so I can gin up the status myself, or I will simply accept a number if you want to do my homework for me. :-)
On 07/04/2012 10:52 PM, Sumana Harihareswara wrote:
For use in our monthly report, due to come out tomorrow
https://www.mediawiki.org/wiki/Wikimedia_engineering_report/2012/June
I'd like to know how many unique contributors ("owners") had commits merged into the mediawiki & mediawiki/* Gerrit projects between June 1-30 inclusive. I've had luck in using "age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot" as a search on https://gerrit.wikimedia.org to get a big paginated table of all the commits (and then I figure I'd look for all the unique owner names and count them), but when I try that on the command line as
ssh -p 29418 gerrit.wikimedia.org gerrit query 'age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot'
I get the error "fatal: "-age:34d" is not a valid option".
I'll accept either help in running this query correctly so I get the giant table on the command line so I can gin up the status myself, or I will simply accept a number if you want to do my homework for me. :-)
Got help from Mark Holmquist and advice from Giovanni Luca Ciampaglia -- needed to use double quote marks. Mark wrote:
It's because you've passed in that string (which was good) as one argument to the SSH command, which is then read as multiple arguments on the remote server. This works for me, adding double quotes around the remote command:
ssh -p 29418 gerrit.wikimedia.org "gerrit query 'age:4d -age:34d status:merged project:^mediawiki.* -owner:L10n-bot'"
Mark then also wrote:
Hm, the SSH interface only returns 500 at a time, and won't accept limit: keywords to the contrary. I've hacked together some results, but I wouldn't recommend reproducing it by hand. I could write up a script with minimal effort, I think.
It took 3 queries but he got all 1401 results. And with that:
$ grep ' name:' wmf-results.txt | sort -u | wc -l 92
So, 92 unique committers in June. Which is way better than Ohloh has been saying, yay.
Sumana Harihareswara, 05/07/2012 20:10:
It took 3 queries but he got all 1401 results. And with that:
$ grep ' name:' wmf-results.txt | sort -u | wc -l 92
So, 92 unique committers in June. Which is way better than Ohloh has been saying, yay.
I noticed the jump in the June engineering report. Where does the big difference compared to previous month's number come from?
Nemo
On 07/18/2012 01:12 PM, Federico Leva (Nemo) wrote:
Sumana Harihareswara, 05/07/2012 20:10:
It took 3 queries but he got all 1401 results. And with that:
$ grep ' name:' wmf-results.txt | sort -u | wc -l 92
So, 92 unique committers in June. Which is way better than Ohloh has been saying, yay.
I noticed the jump in the June engineering report. Where does the big difference compared to previous month's number come from?
Nemo
Now that we've re-calculated our numbers for the past few months, it's not really that big a jump -- see http://lists.wikimedia.org/pipermail/wikitech-l/2012-July/061649.html .
wiki-research-l@lists.wikimedia.org