ankn
a5f8fb49ab
Bahn: aisupport, Analyse-O2C-C2S, awesome-bahn-mcp-servers, beam-mcp,
Confluence_Bot, db-planet-mcp-server, O2C-Harness, project-audit,
Projekt-KIQ-HP, teamlandkarte-mcp
Dhive: Jury-Voting
Privat: CV, NoteGraph (NOTE: NoteGraph needs complete redo after consolidation)
Shared: AI-Orchestrator, OrgMyLife, power_skills_and_more
Shared/references: symphony (read-only)
Bahn repos remain available as independent remotes - this monorepo
pulls them in via subtree, the originals are untouched.
118 lines
4.1 KiB
Python
118 lines
4.1 KiB
Python
"""
|
|
BSSUPPORT Bugs mit Releases in KW 18+19 (28.04 - 07.05.2026).
|
|
Sucht Bugs die:
|
|
- FixVersion enthalten (KTU oder Prod Release)
|
|
- In den letzten 2 Kalenderwochen aktualisiert wurden
|
|
- Status: Fertig/Geschlossen ODER ReTest (= im Release enthalten)
|
|
"""
|
|
import urllib.request, json, ssl, urllib.parse
|
|
|
|
secrets = {}
|
|
with open("project-audit/.secrets", "r", encoding="utf-8-sig") as f:
|
|
for line in f:
|
|
if "=" in line and not line.startswith("#"):
|
|
k, v = line.strip().split("=", 1)
|
|
secrets[k.strip()] = v.strip()
|
|
|
|
TOKEN = secrets.get("JIRA_TOKEN", "")
|
|
ctx = ssl.create_default_context()
|
|
ctx.check_hostname = False
|
|
ctx.verify_mode = ssl.CERT_NONE
|
|
|
|
JIRA_URL = "https://arija.jaas.service.deutschebahn.com"
|
|
|
|
def search(jql, max_results=100):
|
|
url = f"{JIRA_URL}/rest/api/2/search?jql={urllib.parse.quote(jql)}&maxResults={max_results}&fields=key,summary,status,issuetype,updated,resolved,resolution,fixVersions,labels,description"
|
|
req = urllib.request.Request(url)
|
|
req.add_header("Authorization", f"Bearer {TOKEN}")
|
|
try:
|
|
resp = urllib.request.urlopen(req, context=ctx, timeout=30)
|
|
return json.loads(resp.read().decode("utf-8"))
|
|
except Exception as e:
|
|
print(f" API-Fehler: {e}")
|
|
return {"issues": [], "total": 0}
|
|
|
|
# KW18 Start: Montag 28.04.2026
|
|
START_DATE = "2026-04-28"
|
|
|
|
print(f"=== BSSUPPORT: Bugs mit Release-Bezug seit {START_DATE} (KW18+19) ===")
|
|
print()
|
|
|
|
# Suche: Bugs mit FixVersion die in KW18/19 aktualisiert wurden
|
|
jql = f'project = BSSUPPORT AND issuetype = Bug AND fixVersions is not EMPTY AND updated >= "{START_DATE}" ORDER BY fixVersions DESC, updated DESC'
|
|
r = search(jql)
|
|
print(f"Bugs mit FixVersion (aktualisiert seit {START_DATE}): {r.get('total', 0)}")
|
|
print()
|
|
|
|
# Auch Bugs im ReTest (= im Release, noch nicht abgenommen)
|
|
jql2 = f'project = BSSUPPORT AND issuetype = Bug AND status = ReTest AND updated >= "{START_DATE}" ORDER BY updated DESC'
|
|
r2 = search(jql2)
|
|
|
|
# Auch geschlossene Bugs ohne FixVersion aber mit Release-Bezug im Label
|
|
jql3 = f'project = BSSUPPORT AND issuetype = Bug AND statusCategory = Done AND updated >= "{START_DATE}" ORDER BY updated DESC'
|
|
r3 = search(jql3)
|
|
|
|
# Alle zusammenfuehren (deduplizieren)
|
|
all_issues = {}
|
|
for issue_list in [r.get("issues", []), r2.get("issues", []), r3.get("issues", [])]:
|
|
for i in issue_list:
|
|
all_issues[i["key"]] = i
|
|
|
|
print(f"Gesamt (dedupliziert): {len(all_issues)} Bugs")
|
|
print()
|
|
|
|
# Ausgabe als Tabelle
|
|
print(f"{'Ticket':<18} {'Titel':<55} {'Release':<20} {'Status'}")
|
|
print("=" * 110)
|
|
|
|
for key in sorted(all_issues.keys()):
|
|
i = all_issues[key]
|
|
f = i["fields"]
|
|
s = f["status"]["name"]
|
|
res = (f.get("resolution") or {}).get("name", "")
|
|
fv = ", ".join([v["name"] for v in f.get("fixVersions", [])])
|
|
summary = f["summary"][:54]
|
|
|
|
# Status-Anzeige
|
|
if s == "Geschlossen" and res == "Fertig":
|
|
status_display = "Fertig"
|
|
elif s == "Geschlossen" and res:
|
|
status_display = res
|
|
elif s == "ReTest":
|
|
status_display = "ReTest"
|
|
else:
|
|
status_display = s
|
|
|
|
# Nur KTU/Prod Releases oder geschlossene Bugs
|
|
if fv or status_display in ["Fertig", "ReTest"]:
|
|
link = f"{JIRA_URL}/browse/{key}"
|
|
print(f" {key:<16} {summary:<55} {fv:<20} {status_display}")
|
|
|
|
print()
|
|
print()
|
|
print("=== Markdown-Tabelle ===")
|
|
print()
|
|
print("| Ticket | Titel | Release | Status |")
|
|
print("|--------|-------|---------|--------|")
|
|
|
|
for key in sorted(all_issues.keys()):
|
|
i = all_issues[key]
|
|
f = i["fields"]
|
|
s = f["status"]["name"]
|
|
res = (f.get("resolution") or {}).get("name", "")
|
|
fv = ", ".join([v["name"] for v in f.get("fixVersions", [])])
|
|
summary = f["summary"][:65]
|
|
|
|
if s == "Geschlossen" and res == "Fertig":
|
|
status_display = "✅ Fertig"
|
|
elif s == "Geschlossen" and res:
|
|
status_display = f"🔒 {res}"
|
|
elif s == "ReTest":
|
|
status_display = "🔄 ReTest"
|
|
else:
|
|
status_display = s
|
|
|
|
if fv or "Fertig" in status_display or "ReTest" in status_display:
|
|
link = f"[{key}]({JIRA_URL}/browse/{key})"
|
|
print(f"| {link} | {summary} | {fv} | {status_display} |")
|