[openstack-dev] [Metrics][Nova] Using Bicho database to get stats about code review

Daniel Izquierdo dizquierdo at bitergia.com
Wed Jul 17 15:43:56 UTC 2013

On 07/03/2013 06:14 PM, Jesus M. Gonzalez-Barahona wrote:
> Hi all,
> Bicho [1] now has a Gerrit backend, which has been tested with
> OpenStack's Gerrit. We have used it to produce the MySQL database dump
> available at [2] ( gerrit.mysql.7z ). You can use it to compute the
> metrics mentioned in the previous threads about code review, and some
> others.
> [1] https://github.com/MetricsGrimoire/Bicho
> [2] http://activity.openstack.org/dash/browser/data/db/
> The database dump will be updated daily, starting in a few days.

It's working now :). Databases can be downloaded at [1].

> For some examples on how to run queries on it, or how to produce the
> database using Bicho, fresh from OpenStack's gerrit, have a look at [3].
> [3] https://github.com/MetricsGrimoire/Bicho/wiki/Gerrit-backend
> At some point, we plan to visualize the data as a part of the
> development dashboard [4], so any comment on interesting metrics, or
> bugs, will be welcome. For now, we're taking not of all metrics
> mentioned in the previous posts about code review stats.
> [4] http://activity.openstack.org/dash/browser/

So far aggregated data was added [2], and I hope we'll have that data 
per repository in the following days.


[1] http://activity.openstack.org/dash/browser/data/db/
[2] http://activity.openstack.org/dash/browser/scr.html

> Saludos,
> 	Jesus.

Daniel Izquierdo Cortazar, PhD
Chief Data Officer
"Software Analytics for your peace of mind"

More information about the OpenStack-dev mailing list