#!/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

cfg = repocfg()
dbhdl = pgdb.connect(host=cfg.pgdbhost, database=cfg.pgdbname, user=cfg.pgdbuser, password=cfg.pgdbpw)
dbcur = dbhdl.cursor()


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 'Source' not in pkg and 'Debian Games Team' not in pkg['Maintainer']:
				dbcur.execute("SELECT 1 FROM src_rev WHERE sourcepackagename=%s AND version=%s LIMIT 1", (pkg['Package'], pkg['Version']))
				if dbcur.rowcount != 1:
					print(pkg['Package'], pkg['Version'])