config.py

import bugzilla
import yaml
import sys
import os
import google_api as gapi

# [CHANGE NEEDED] Add the relevant information for you report
cfg_path = os.path.expanduser('~/.gapi/personal_cfg.yml')

if len(sys.argv) != 2:
    raise IndexError("You must provide the spreadsheet name to work with")

SPREADSHEET_NAME = sys.argv[1]

g = gapi.GoogleSpreadSheetAPI(SPREADSHEET_NAME, "Dashboard configuration")

PRODUCT = g.get_cell_value(7, 3)
BUGZILLA_PRODUCT = g.get_cell_value(7, 4)
VERSION = g.get_cell_value(7, 6)
# The version flag should contain only x and y releases:
# ocs-4.2.0 --> ocs-x.y.z so you'll need to add only ocs-4.2 in order to see
# all bugs in version x.y
BUGZILLA_VERSION_FLAG = g.get_cell_value(7, 5)
LAYERED_PRODUCT = g.get_cell_value(10, 4)

# [CHANGE NEEDED] List here all the teams you want to sample, for example:
team1 = "manage"
team2 = "e2e"
team3 = "ecosystem"

all_team = [team1, team2, team3]

severity = {
    "urgent": 1,
    "high": 2,
    "medium": 3,
    "low": 4,
    "unspecified": 5
}

BUGS_BY_TEAM = {
    team1: []
}

team_members_g = gapi.GoogleSpreadSheetAPI(SPREADSHEET_NAME, "QE_team_member")

TEAM_MEMBERS = list()
idx = 1
while True:
    member = team_members_g.get_cell_value(idx, 1)
    if member:
        TEAM_MEMBERS.append(member)
        idx += 1
    else:
        break
# [CHANGE NEEDED] Add the team members divided into teams. For example:
teams = {
    team1: [
            'racpatel@','skanta@','pdhiran@','mmurthy@'
            ,'vashastr@','pnataraj@','sunnagar@','mkasturi@','hyelloji@',
            'ukurundw@','julpark@','gpatta@','psathyan@','vimishra@','ymane@',
            'amsyedha@','mgowri@','tchandra@','sangadi@','vivk@','ckulal@',
            'amk@','anrao@','tmathew@','gsitlani@','vereddy@','ngangadh@',
            'hmaheswa@','hchebrol@', 'rlepaksh@', 'saraut@', 'hkumar@', 'vdas@',
            'vamahaja@', 'aramteke@', 'vpapnoi@', 'msaini@', 'giridhar.ramaraju@',
            'mobisht@', 'fkellehe@', 'prprakas@', 'rkhambad@', 'yweinste@',
    ],    
   
}

# [CHANGE NEEDED] Add *ALL* the product components exist in Bugzilla for your
# product
COMPONENTS = {
    'ceph': [],
    'build': [],
    'csi-driver': [],
    'distribution': [],
    'documentation': [],
    'installation': [],
    'Multi-Cloud Object Gateway': [],
    'releng': [],
    'rook': [],
    'storage-dashboard': [],
    'unclassified': [],
    'ocs-operator': [],
    'must-gather': [],

}

backlog = {}

# Create the API key at ~/.config/python-bugzilla/bugzillarc file
URL = "bugzilla.redhat.com"
bzapi = bugzilla.Bugzilla(URL)

# Bug statuses
VERIFIED = "VERIFIED"
ON_QA = "ON_QA"
MODIFIED = "MODIFIED"
OPEN_BUGS = "NEW,ASSIGNED,POST,MODIFIED"
OPEN_BUGS_LIST = ["NEW", "ASSIGNED", "POST", "MODIFIED"]
CLOSED_RESOLUTION = [
    "", "WONTFIX", "DEFFERED", "CURRENTRELEASE", "ERRATA", "UPSTREAM",
    "NEXTRELEASE", "CANTFIX"
]

# Bug flags
BLOCKER = "blocker+"
CANDIDATE_BLOCKER = "blocker?"
MISSING_ACK = [
    "pm_ack+",
    "devel_ack+",
    "qa_ack?"
]
NEEDINFO = "needinfo?"
QUALITY_IMPACT = "quality_impact="
COMPONENT_DOCUMENTATION = "Documentation"