import bugzilla
import sys
import time
from datetime import datetime
TRACKER = 2168845  # F39FailsToInstall
JUDGEMENT_DAY = datetime.fromisoformat("2023-08-15")
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("fti-bugs@") and "reminder" 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))

$ python fedora-fti-8-weeks-new.py 
appliance-tools 43 weeks 💀
awake 34 weeks 💚
golang-github-lucas-clemente-quic 23 weeks 💀
pykka 20 weeks 💚
androguard 12 weeks 💀
erlang-esip 12 weeks 💀
erlang-hyper 12 weeks 💀
erlang-stringprep 12 weeks 💀
erlang-xmpp 12 weeks 💀
wings 12 weeks 💀
python-aioguardian 10 weeks 💀
golang-github-coredns-corefile-migration 10 weeks 💀
pcb2gcodeGUI 9 weeks 💀
antlr32 9 weeks 💀
python-syrupy 6 weeks 💚
Mayavi 5 weeks 💚
RBTools 5 weeks 💚
aiodnsbrute 5 weeks 💚
andriller 5 weeks 💚
androwarn 5 weeks 💚
asv 5 weeks 💚
b43-tools 5 weeks 💚
botan2 5 weeks 💚
brd 5 weeks 💚
btest 5 weeks 💚
buildstream 5 weeks 💚
classification-banner 5 weeks 💚
dlrn 5 weeks 💚
electrum 5 weeks 💚
eric 5 weeks 💚
fedora-gather-easyfix 5 weeks 💚
gfal2-python 5 weeks 💚
libssh2-python 5 weeks 💚
manafirewall 5 weeks 💚
noggin 5 weeks 💚
oct2spec 5 weeks 💚
pico-wizard 5 weeks 💚
postfix-mta-sts-resolver 5 weeks 💚
pyflowtools 5 weeks 💚
pyftpdlib 5 weeks 💚
pygsl 5 weeks 💚
python-AppTools 5 weeks 💚
python-acora 5 weeks 💚
python-actdiag 5 weeks 💚
python-adext 5 weeks 💚
python-aioodbc 5 weeks 💚
python-aiozeroconf 5 weeks 💚
python-airthings 5 weeks 💚
python-alarmdecoder 5 weeks 💚
python-autopep8 5 weeks 💚
python-blockdiag 5 weeks 💚
python-bluepy 5 weeks 💚
python-btlewrap 5 weeks 💚
python-click-spinner 5 weeks 💚
python-convertdate 5 weeks 💚
python-cypari2 5 weeks 💚
python-dominate 5 weeks 💚
python-elpy 5 weeks 💚
python-envisage 5 weeks 💚
python-ephem 5 weeks 💚
python-flask-bootstrap 5 weeks 💚
python-flufl-bounce 5 weeks 💚
python-fpylll 5 weeks 💚
python-gccinvocation 5 weeks 💚
python-grako 5 weeks 💚
python-guizero 5 weeks 💚
python-interfile 5 weeks 💚
python-iowait 5 weeks 💚
python-ipgetter 5 weeks 💚
python-jsonrpc-server 5 weeks 💚
python-lacrosse 5 weeks 💚
python-lazr-smtptest 5 weeks 💚
python-leveldb 5 weeks 💚
python-liblarch 5 weeks 💚
python-logging-tree 5 weeks 💚
python-lsp-black 5 weeks 💚
python-lsp-server 5 weeks 💚
python-magnumclient 5 weeks 💚
python-manilaclient 5 weeks 💚
python-mathics3 5 weeks 💚
python-mathicsscript 5 weeks 💚
python-mne-bids 5 weeks 💚
python-mygpoclient 5 weeks 💚
python-neutronclient 5 weeks 💚
python-nmap 5 weeks 💚
python-nose_fixes 5 weeks 💚
python-notario 5 weeks 💚
python-nwdiag 5 weeks 💚
python-octaviaclient 5 weeks 💚
python-oslo-log 5 weeks 💚
python-parsley 5 weeks 💚
python-pathtools 5 weeks 💚
python-petlink 5 weeks 💚
python-protego 5 weeks 💚
python-py9p 5 weeks 💚
python-pyaes 5 weeks 💚
python-pybv 5 weeks 💚
python-pydiffx 5 weeks 💚
python-pyface 5 weeks 💚
python-pyls-spyder 5 weeks 💚
python-pytenable 5 weeks 💚
python-pytest-metadata 5 weeks 💚
python-pytest-virtualenv 5 weeks 💚
python-qdarkstyle 5 weeks 💚
python-restfly 5 weeks 💚
python-rosinstall 5 weeks 💚
python-saharaclient 5 weeks 💚
python-seqdiag 5 weeks 💚
python-simplewrap 5 weeks 💚
python-sklearn-genetic-opt 5 weeks 💚
python-slip 5 weeks 💚
python-smart-gardena 5 weeks 💚
python-sphinxcontrib-actdiag 5 weeks 💚
python-stdio-mgr 5 weeks 💚
python-tackerclient 5 weeks 💚
python-tambo 5 weeks 💚
python-textual 5 weeks 💚
python-troveclient 5 weeks 💚
python-uinput 5 weeks 💚
python-upoints 5 weeks 💚
python-uri-templates 5 weeks 💚
python-uvloop 5 weeks 💚
python-vcstools 5 weeks 💚
python-visionegg-quest 5 weeks 💚
python-yamlordereddictloader 5 weeks 💚
python-yourls 5 weeks 💚
python-zaqarclient 5 weeks 💚
python-zuul-client 5 weeks 💚
python3-saml 5 weeks 💚
python3-script 5 weeks 💚
pyutil 5 weeks 💚
sagemath 5 weeks 💚
spyder 5 weeks 💚
sword 5 weeks 💚
transmageddon 5 weeks 💚
xonsh 5 weeks 💚
breeze-icon-theme 5 weeks 💚
perl-LMDB_File 4 weeks 💚
pvs-sbcl 4 weeks 💚
php-ocramius-generated-hydrator 4 weeks 💚
php-symfony4 4 weeks 💚
python-pymc3 2 weeks 💚
golang-github-alicebob-miniredis 2 weeks 💚
belle-sip 0 weeks 💚
ghc-aeson-compat 0 weeks 💚
ghc-cabal-file-th 0 weeks 💚
ghc-union-find 0 weeks 💚
golang-gioui 0 weeks 💚
htmltest 0 weeks 💚
ortp 0 weeks 💚
python-xeddsa 0 weeks 💚
budgie-desktop 0 weeks 💚
rust-gix-object 0 weeks 💚
https://bugzilla.redhat.com/buglist.cgi?bug_id=2135410,2173916,2208494,2208978,2208982,2208989,2208990,2208997,2210958,2211332,2213110,2214043
appliance-tools golang-github-lucas-clemente-quic androguard erlang-esip erlang-hyper erlang-stringprep erlang-xmpp wings python-aioguardian golang-github-coredns-corefile-migration pcb2gcodeGUI antlr32