Attachment 10268 Details for Bug 49900

Fixed qa.py

qa.py (text/x-python), 1.24 KB, created by Philipp Hahn on 2019-12-12 17:11 CET

(hide)

Description:

Filename:

MIME Type:

Creator: Philipp Hahn

Created: 2019-12-12 17:11 CET

Size: 1.24 KB

patch

obsolete

>#!/usr/bin/python2.7
>from __future__ import print_function
>import gzip
>import glob
>import pgdb
>
>from debian.deb822 import Deb822
>
>from univention.repong.repo_lib_cfg import repocfg
>from univention.repong.const import RE_SRC
>
>cfg = repocfg()
>dbhdl = pgdb.connect(host=cfg.pgdbhost, database=cfg.pgdbname, user=cfg.pgdbuser, password=cfg.pgdbpw)
>dbcur = dbhdl.cursor()
>
>
>missing = set()
>for filename in glob.glob('/mnt/build-storage/upstream/debian/dists/buster/*/*/Packages*.gz'):
>	with gzip.open('/mnt/build-storage/upstream/debian/dists/buster/contrib/binary-all/Packages.gz') as fd:
>		for pkg in Deb822.iter_paragraphs(fd):
>			if 'Debian Games Team' in pkg['Maintainer']:
>				continue
>			if pkg.get('Section', '').endswith('games'):
>				continue
>
>			ver = pkg['Version']
>			try:
>				src = pkg['Source']
>				m = RE_SRC.match(src)
>				if m:
>					src, ver = m.groups()
>			except LookupError:
>				src = pkg['Package']
>
>			dbcur.execute("SELECT 1 FROM src_rev WHERE sourcepackagename=%s AND version=%s LIMIT 1", (src, ver))
>			if dbcur.rowcount != 1:
>				rec = (src, ver)
>				missing.add(rec)
>
>missing.discard(('gemrb', '0.8.5-1'))
>
>for src, ver in sorted(missing):
>	print('repo_admin.py -F -r 5.0 -p {}_{}.dsc'.format(src, ver.split(':', 1)[1] if ':' in ver else ver))

Actions: View

Attachments on bug 49900: 10243 | 10268 | 10271 | 10275