---

db.py

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

---

docroot: /var/www/469ed2f6-4d4b-4a8a-9f5e-ee4ef04d3bc8/public_html

---

curdir: /usr/lib/python3/dist-packages/CommandNotFound/db

	.		4096
	..		4096
X	__init__.py		39
	__pycache__		4096
X	creator.py		12234
X	db.py		868