User talk:MichaelSchoenitzer/FLOSS/outdated

Code to generate this list:

#!/bin/env python3
import requests
from packaging.version import parse
import urllib.parse

# starttext = "List of outdated packages"
# missing = "%s has no package in Arch!"
# outofdate = "%s (%s) is out of date. Arch: %s – WD: %s"
# endtext = ""
starttext = """{|
! Package !! Version in Arch !! Version in Wikidata"""
missing = """|-
| [[%s|%s]] || Package does not exist!"""
outofdate = """|-
| [[%s|%s]] || %s || %s"""
endtext = "|}"

archurl = 'https://www.archlinux.org/packages/search/json/?name={}'
wdqurl = 'https://query.wikidata.org/sparql?format=json&query='
query = """
SELECT ?item ?itemLabel ?archlabel ?vers
WHERE
{
  ?item wdt:P3454 ?archlabel.
  ?item wdt:P348 ?vers.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
"""


def runquery(url):
    r = requests.get(url)
    if r.status_code == 200:
        return r.json()["results"]
    else:
        return None


wdlist = runquery(wdqurl + urllib.parse.quote_plus(query))
softwarelist = {}
qidlist = {}
for software in wdlist['bindings']:
    qid = software['item']['value'][31:]
    name = software['archlabel']['value']
    wdversion = parse(software['vers']['value'])
    if name in softwarelist:
        softwarelist[name] = max(wdversion, softwarelist[name])
    else:
        softwarelist[name] = wdversion
        qidlist[name] = qid


print(starttext)
for software in softwarelist:
    searchres = runquery(archurl.format(software))
    qid = qidlist[software]
    if searchres == []:
        print(missing % (qid, software))
    else:
        archversion = parse(searchres[0]["pkgver"])
        wdversion = softwarelist[software]
        if archversion > wdversion:
            print(outofdate % (qid, software, archversion, wdversion))
print(endtext)

Start a discussion about User:MichaelSchoenitzer/FLOSS/outdated

Talk pages are where people discuss how to make content on Wikidata the best that it can be. You can use this page to start a discussion with others about how to improve User:MichaelSchoenitzer/FLOSS/outdated.

Start a discussion