o

���ad�@s,dd
lZdd
l
Z
e
��
Gdd�de�Zd
S)�Nc@seZ
dZd
d�Zdd�ZdS)�SqliteDatabasecCst�
|
�
|_d
|_dS)N�)�sqlite3�connect�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�decoder�execute�fetchall�append)r�command�results�rowr
r
r�lookups


��
zSqliteDatabase.lookupN)�__name__�
__module__�__qualname__rrr
r
r
rr	sr)r�apt_pkg�init�objectrr
r
r
r�<module>
s