Skip to content

rakeshgm/bugzilla-reports-tool

 
 

Repository files navigation

bugzilla-reports-tool

This tool will allow you to create a Quality dashboard for your product and send (weekly or whenever you want, depend on cronjob) reports with bug status. The quality dashboard is fully automated and the template Google Spreadsheet can be found here - https://docs.google.com/spreadsheets/d/1hmsG9wDIi0sayeAOEmYjpS8sV4c5diZhbsA3uyhQeGU/edit?usp=sharing

Quality dashboard

An exeample of this dashboard:

alt text

Usage:

  1. Copy this template and add your team name in the titie --> <"YOUR TEAM NAME INITIALS"> QE - Quality Dashboard

  2. To enable interaction with Google spreadsheet, follow the steps in https://developers.google.com/sheets/api/quickstart/python and after, steps in here https://gspread.readthedocs.io/en/latest/oauth2.html#oauth-credentials (until step 6). Name the Json from step 3 as 'google_api_secret.json'

  3. Creeate .gapi directory under ~/. with: $ mkdir ~/.gapi

  4. place the google_api_secret.json under ~/.gapi/google_api_secret.json

  5. Ensure you give 'Edit' permissions in your copied spreadsheet, to the 'client' in this json file

  6. install the following on the machine that will execute the script:

  7. In the copied spreadsheet -> "Dashboard configuration", please change the values to fit your product and version

  8. Create a yml file under ~/.gapi (from step 3) and name the file 'personal_cfg.yml' and add the following data:

bugzilla:
    user: <your RH account>@redhat.com
    password: <your Bugzilla passowrd>

# Optional
bugzilla_report:
    gmail_address: <your personal email address>
    gmail_pass: <your personal email password>

The 'Bugzilla' section is a must have for this dashboard to work as the scripts needs access to Bugzilla

  1. Execute with:

$ python3.7 release_readiness_criteria.py SPREADSHEET_NAME

  1. A list of recommended cronjob exist in the 'Dashboard configuration' tab

QE Tracking dashboard

An exeample of this dashboard:

alt text

Usage:

Same steps as above with changing the script you execute in step 8 to:

$ python3.7 tracking_dashboard.py SPREADSHEET_NAME

Arrival vs. Resolved trend

An exeample of this dashboard:

alt text

Usage:

Same steps as above with changing the script you execute in step 8 to:

$ python3.7 arrivals_vs_resolved.py SPREADSHEET_NAME

Bugzilla reports - Currently in a POC

An example of this report: alt text

Sections currently available:

  • New arrivals
  • Resolved bugs (count only)
  • Total ON_QA (count only)
  • ON_QA 'blockers'
  • Open 'blockers?'
  • Open 'blockers+'

Usage:

  1. install the following on the machine that will execute the script:
  2. Under config.py you have few lines that needs your attention to be specific to your product - please follow the guidelines in comments under config.py
  3. Under personal_config.py add your relevant information so the tool will be able to access
  4. Execute with: $ python bugzilla_report.py

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%