U

Ubd�@s,dd
lZdd
l
Z
e
��
Gdd�de�Zd
S)�Nc@seZ
dZd
d�Zdd�ZdS)�SqliteDatabasecCst�
|
�
|_d
|_dS)N�)�sqlite3Zconnect�conZ	component)�self�filename�r�7/usr/lib/python3/dist-packages/CommandNotFound/db/db.py�__init__s

zSqliteDatabase.__init__cCsR|
�d
d��
d
d�}
g}|j�d|
f
���D] }|�|d|d|df�

q,|S)Nzutf-8�surrogateescape�replacea

                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
                r
�
�)�encode�decoderZexecuteZfetchall�append)rZcommandZresults�rowrrr	�lookups


�
zSqliteDatabase.lookupN)�__name__�
__module__�__qualname__r
rrrrr	r	sr)r�apt_pkgZinit�objectrrrrr	�<module>s