o
    ŸŽ°ad  ã                   @   s,   d dl Z d dlZe ¡  G dd„ deƒZdS )é    Nc                   @   s   e Zd Zdd„ Zdd„ ZdS )ÚSqliteDatabasec                 C   s   t  |¡| _d| _d S )NÚ )Úsqlite3ZconnectÚconZ	component)ÚselfÚfilename© r   ú7/usr/lib/python3/dist-packages/CommandNotFound/db/db.pyÚ__init__   s   
zSqliteDatabase.__init__c                 C   sR   |  dd¡ dd¡}g }| j d|f¡ ¡ D ]}| |d |d |d f¡ q|S )Nzutf-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   ZexecuteZfetchallÚappend)r   ZcommandÚresultsÚrowr   r   r	   Úlookup   s   ùùzSqliteDatabase.lookupN)Ú__name__Ú
__module__Ú__qualname__r
   r   r   r   r   r	   r   	   s    r   )r   Úapt_pkgZinitÚobjectr   r   r   r   r	   Ú<module>   s   