import bugzilla
import sys
import time
from datetime import datetime
TRACKER = 2045109  # F37FailsToInstall
JUDGEMENT_DAY = datetime.fromisoformat("2022-09-27")
bzapi = bugzilla.Bugzilla("bugzilla.redhat.com")
fields = ["component", "creation_time"]
query = bzapi.build_query(product="Fedora", include_fields=fields)
query["blocks"] = TRACKER
query["status"] = "NEW"
query["limit"] = 1000
bugzillas = bzapi.query(query)
assert len(bugzillas) < 1000
def is_reminder(c):
    return (c["creator"].startswith("mhroncok@") and "reminder" in c["text"] or
        c["creator"].startswith("thrnciar@") and "any update" in c["text"])
def two_reminders(bug):
    return sum(is_reminder(c) for c in bug.getcomments()) >= 2
retire_ids = []
retire_packages = []
for bug in bugzillas:
    creation_time = datetime.fromtimestamp(time.mktime(bug.creation_time.timetuple()))
    delta = JUDGEMENT_DAY - creation_time
    symbol = "\N{GREEN HEART}"
    if delta.days >= 8 * 7 and two_reminders(bug):
        symbol = "\N{SKULL}"
        retire_ids.append(bug.id)
        retire_packages.append(bug.component)
    print(bug.component, f"{delta.days // 7} weeks", symbol, file=sys.stderr)
print(
    "https://bugzilla.redhat.com/buglist.cgi?bug_id="
    + ",".join(str(b) for b in retire_ids)
)
print(" ".join(retire_packages))