Thanks!
Stephen
--
To unsubscribe, email repo-discuss...@googlegroups.com
More info at http://groups.google.com/group/repo-discuss?hl=en
Hi,I am also working on mining Gerrit as part of my Ph.D Dissertation. Currently, I retrieve data directly from the database but the more robust approach would be to create a metric database by retrieving the data from the Gerrit API.@Stephen, please let me know what kind of metric are you interested in getting. Hopefully we can work together on this. I am working on proposing metrics that can be used to evaluate and improve review process.The related table for collecting metrics are1) accounts -> store user information2) changes -> store Gerrit change requests3) change_message -> store comments for change requests4) patch_sets -> store patchset information but it doesn't have content of patch of patch_set. The content of patch is stored in Git.5) patch_comments -> stores comment for each line in a patch@Edwin, could you let us know where we can learn more about the possible changes when the data is moved to Git. How Gerrit is going to store review history and how to retrieve them? What is the status of this effort?
It should be relatively easy to collect metrics via the Gerrit JSON
interface. This interface should be decoupled from Gerrit's internal
data layout.
See docs for the "query" command:
http://gerrit.googlecode.com/svn/documentation/2.2.1/cmd-query.html
Not everything is available via this interface but this should be
enough for information like # of reviews done, average number of
iterations per change, etc. My goal has been to compute a "review
latency" metric from Gerrit.
I've written Haskell code to talk to Gerrit via SSH and parse the JSON
responses to Haskell data structures. This is pretty handy for
further data mining in Haskell. Ping me if you're interested, I can
make the code available if someone finds it useful.
Janne
2011/12/27 Janne Hellsten <jjhe...@gmail.com>:
> I've written Haskell code to talk to Gerrit via SSH and parse the JSON
> responses to Haskell data structures. This is pretty handy for
> further data mining in Haskell. Ping me if you're interested, I can
> make the code available if someone finds it useful.
Here is the ping ;-)
I find it useful, where can I find the code?
Kind regards,
Remy
You can find the GerritJson module here: https://github.com/nurpax/gerrit-json
I only recently went back to Haskell so there are probably many ways
in which the code can be improved.
Janne
2011/12/29 Janne Hellsten <jjhe...@gmail.com>:
Thanks for sharing!
I will look into it in detail next year/week ;-)
Kind regards,
Remy