%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream
#!/usr/bin/python3 import sqlite3 import apt_pkg apt_pkg.init() class SqliteDatabase(object): def __init__(self, filename): self.con = sqlite3.connect(filename) self.component = "" def lookup(self, command): # deal with invalid unicode (LP: #1130444) command = command.encode("utf-8", "surrogateescape").decode("utf-8", "replace") results = [] for row in self.con.execute( """ SELECT packages.name, packages.version, packages.component FROM commands INNER JOIN packages on packages.pkgID = commands.pkgID WHERE commands.command=? ORDER BY packages.priority DESC """, (command,)).fetchall(): results.append( (row[0], row[1], row[2]) ) return results