U

���ad�@s,dd
lZdd
l
Z
e
��
Gdd�de�Zd
S)�Nc@seZ
dZd
d�Zdd�ZdS)�SqliteDatabasecCst�
|
�
|_d
|_dS)N�)�sqlite3Zconnect�con�	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)r�commandZresults�rowr	r	r
�lookups


�
zSqliteDatabase.lookupN)�__name__�
__module__�__qualname__rrr	r	r	r
r	sr)r�apt_pkg�init�objectrr	r	r	r
�<module>s