U
    ânld-  ã                   @   s2   d dl Z d dlZd dlmZ dZG dd„ dƒZdS )é    N)ÚExpiringDictúdb/suggestions.dbc                   @   s$   e Zd Zeddfdd„Zdd„ ZdS )ÚDatabaseiè  é   c              
   C   s˜   t j d¡rdt j d¡sdtdd ƒ zt  dd¡ W n. tk
rb } ztt|ƒƒ W 5 d }~X Y nX || _t||d�| _	t
j|dd�| _| j d¡ d S )	Núsuggestions.dbr   zMigrating %s to %s)r   r   )Úmax_lenÚmax_age_secondsF)Úcheck_same_threadz¸CREATE TABLE IF NOT EXISTS suggestions (
            "q"	TEXT NOT NULL,
            "s"	TEXT NOT NULL,
            "source"	TEXT NOT NULL,
            "target"	TEXT NOT NULL
        );)ÚosÚpathÚisfileÚprintÚrenameÚ	ExceptionÚstrÚdb_pathr   ÚcacheÚsqlite3ÚconnectÚcÚexecute)Úselfr   Úmax_cache_lenÚmax_cache_ageÚe© r   ú:/var/www/html/LibreTranslate/libretranslate/suggestions.pyÚ__init__
   s    ÿzDatabase.__init__c                 C   s$   | j  d||||f¡ | j  ¡  dS )NzBINSERT INTO suggestions (q, s, source, target) VALUES (?, ?, ?, ?)T)r   r   Úcommit)r   ÚqÚsÚsourceÚtargetr   r   r   Úadd!   s    
þ
zDatabase.addN)Ú__name__Ú
__module__Ú__qualname__ÚDEFAULT_DB_PATHr   r#   r   r   r   r   r   	   s   r   )r   r
   Úexpiringdictr   r'   r   r   r   r   r   Ú<module>   s   