Extracting bug metrics from Launchpad
I'm being asked by management to provide bug count metrics for the StarlingX project. Our LP instance is at https://bugs.launchpad.net/starlingx. They are looking for things like "average age of closed bugs", "# bugs closed per week" and so on. There doesn't seem to be a way to gather this kind of data from Launchpad. Some of the items needed like "bug creation date" aren't visible in the UI and may not exist in the database. I can't search using date ranges in the advanced search. If I could export all of the bug info into a spreadsheet I could just pound it out, but I can't see how to do that. Even better would be to extend our project's bitergia page https://starlingx.biterg.io/ to show some of these metrics. But I'm not sure how to do that or if it's even possible. Thoughts and suggestions would be greatly appreciated. Thank you in advance! brucej
[I've left Bruce in the Cc for my reply as he does not seem to be subscribed to this mailing list.] On 2020-04-17 17:44:05 +0000 (+0000), Jones, Bruce E wrote:
I'm being asked by management to provide bug count metrics for the StarlingX project. Our LP instance is at https://bugs.launchpad.net/starlingx.
They are looking for things like "average age of closed bugs", "# bugs closed per week" and so on.
There doesn't seem to be a way to gather this kind of data from Launchpad. Some of the items needed like "bug creation date" aren't visible in the UI and may not exist in the database. I can't search using date ranges in the advanced search. If I could export all of the bug info into a spreadsheet I could just pound it out, but I can't see how to do that.
Even better would be to extend our project's bitergia page https://starlingx.biterg.io/ to show some of these metrics. But I'm not sure how to do that or if it's even possible.
Thoughts and suggestions would be greatly appreciated. Thank you in advance!
OpenDev doesn't operate Launchpad (nor maintain your Bitergia dashboard), so the most we can really do is provide suggestions. Launchpad has an extensive HTTP API which is documented here: https://launchpad.net/+apidoc/devel.html The entry on the "bug" collection object indicates that "date_created" is one of the attributes it provides. You can see examples of how we interface with Launchpad's API for some code review integration here: https://opendev.org/opendev/jeepyb/src/branch/master/jeepyb/cmd/update_bug.p... As a convenience we rely on the launchpadlib package from PyPI: https://pypi.org/project/launchpadlib/ Hopefully that helps? -- Jeremy Stanley
Jeremy, thank you for the prompt reply! brucej -----Original Message----- From: Jeremy Stanley [mailto:fungi@yuggoth.org] Sent: Friday, April 17, 2020 11:22 AM To: service-discuss@lists.opendev.org Cc: Jones, Bruce E <bruce.e.jones@intel.com> Subject: Re: Extracting bug metrics from Launchpad [I've left Bruce in the Cc for my reply as he does not seem to be subscribed to this mailing list.] On 2020-04-17 17:44:05 +0000 (+0000), Jones, Bruce E wrote:
I'm being asked by management to provide bug count metrics for the StarlingX project. Our LP instance is at https://bugs.launchpad.net/starlingx.
They are looking for things like "average age of closed bugs", "# bugs closed per week" and so on.
There doesn't seem to be a way to gather this kind of data from Launchpad. Some of the items needed like "bug creation date" aren't visible in the UI and may not exist in the database. I can't search using date ranges in the advanced search. If I could export all of the bug info into a spreadsheet I could just pound it out, but I can't see how to do that.
Even better would be to extend our project's bitergia page https://starlingx.biterg.io/ to show some of these metrics. But I'm not sure how to do that or if it's even possible.
Thoughts and suggestions would be greatly appreciated. Thank you in advance!
OpenDev doesn't operate Launchpad (nor maintain your Bitergia dashboard), so the most we can really do is provide suggestions. Launchpad has an extensive HTTP API which is documented here: https://launchpad.net/+apidoc/devel.html The entry on the "bug" collection object indicates that "date_created" is one of the attributes it provides. You can see examples of how we interface with Launchpad's API for some code review integration here: https://opendev.org/opendev/jeepyb/src/branch/master/jeepyb/cmd/update_bug.p... As a convenience we rely on the launchpadlib package from PyPI: https://pypi.org/project/launchpadlib/ Hopefully that helps? -- Jeremy Stanley
participants (2)
-
Jeremy Stanley
-
Jones, Bruce E