You can download a database dump with (hopefully) information for all
Launchpad tickets corresponding to OpenStack, already organized and
ready to be queried:

http://activity.openstack.org/dash/browser/data/db/tickets.mysql.7z

(linked from
http://activity.openstack.org/dash/browser/data_sources.html )

It is a 7z-zipped file with includes a MySQL dump of the actual
database, produced by Bicho (one of the tools in MetricsGrimoire). It is
updated daily.

You can just feed it to MySQL, and start to do your queries. There is
some information about Bicho and the database schema used at

https://github.com/MetricsGrimoire/Bicho/wiki

https://github.com/MetricsGrimoire/Bicho/wiki/Database-Schema

Please, let me know if you need further info.

Saludos,

        Jesus.

On Wed, 2014-12-03 at 20:20 +0800, zfx0...@gmail.com wrote:
> Hi, all
> 
> 
> I am a graduate student in Peking University, our lab do some research
> on open source projects. 
> This is our introduction: https://passion-lab.org/
> 
> 
> Now we need openstack issues data for research, I found the issues
> list: https://bugs.launchpad.net/openstack/
> I want to download the openstack issues data, Could anyone tell me how
> to download the data? Or is there some link or API for download the
> data?
> 
> 
> And I found 9464  bugs in https://bugs.launchpad.net/openstack/ ´╝îis
> this all? why so few?
> 
> 
> Many thanks!
> 
> 
> Beat regards,
> Feixue, Zhang
> 
> 
> 
> ______________________________________________________________________
> zfx0...@gmail.com
> _______________________________________________
> OpenStack-dev mailing list
> OpenStack-dev@lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

-- 
Bitergia: http://bitergia.com
/me at Twitter: https://twitter.com/jgbarah


_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Reply via email to