Re: [openstack-dev] How to get openstack bugs data for research?

2014-12-03 Thread Jesus M. Gonzalez-Barahona
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


Re: [openstack-dev] How to get openstack bugs data for research?

2014-12-03 Thread Angelo Matarazzo

Hi,
you could take a look at Stackalytics and how this website communicates 
with launchpad.


https://wiki.openstack.org/wiki/Stackalytics/HowToRun

Best,
Angelo

On 03/12/2014 13:41, Louis Taylor wrote:

On Wed, Dec 03, 2014 at 08:20:45PM +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?

That is the number of currently open bugs. There are 47733 bugs including
closed ones. Launchpad has an API [1], which can probably list the bugs filed
against a project.

[1] https://help.launchpad.net/API


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


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


Re: [openstack-dev] How to get openstack bugs data for research?

2014-12-03 Thread Louis Taylor
On Wed, Dec 03, 2014 at 08:20:45PM +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?

That is the number of currently open bugs. There are 47733 bugs including
closed ones. Launchpad has an API [1], which can probably list the bugs filed
against a project.

[1] https://help.launchpad.net/API


signature.asc
Description: Digital signature
___
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev


[openstack-dev] How to get openstack bugs data for research?

2014-12-03 Thread zfx0...@gmail.com
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