U
    hƙb
                     @   sL   d dl Z dd Zdd Zdd Zdd	 Zd
d Zdd Zdd Zdd ZdS )    Nc                   C   s   t dat ad S )NzT/var/www/rientel_ru/data/www/rientel.ru/utils/db_api/utils/db_api/tg_olimpiad.sqlite)sqlite3connectconcursorcur r   r   0/var/www/rientel_ru/data/www/rientel.ru/SQL_1.pymain   s    
r	   c                  C   s$   t   td t } t  | S )NzSELECT * FROM urls_anotherr	   r   executeZfetchallr   closerowsr   r   r   select_urls   s
    
r   c                 C   s,   t   td|  d t  t  d S )NzDELETE FROM fiks WHERE url = ''r	   r   r   r   Zcommitr   urlr   r   r   del_fiks   s    
r   c                 C   s,   t   td|  d t  t  d S )Nz&DELETE FROM urls_another WHERE url = 'r   r   r   r   r   r   del_nothers    s    
r   c                  C   s$   t   td t } t  | S )NzSELECT * FROM fiksr
   r   r   r   r   select_fiks)   s
    
r   c                 C   s2   t   td| d|  d t  t  d S )Nz%UPDATE check_stavki SET answer_card='' WHERE id='r   r   telegram_idanswerr   r   r   update_stavki_users2   s    r   c                 C   s2   t   td| d|  d t  t  d S )Nz&UPDATE check_stavki SET answer_finds='r   r   r   r   r   r   r   update_stavki_finds_users;   s    r   c                 C   s,   t   td|  d t }t  |S )Nz.SELECT * FROM registration WHERE telegram_id='r   r
   )r   r   r   r   r   subscriber_existsD   s
    r   )	r   r	   r   r   r   r   r   r   r   r   r   r   r   <module>   s   
						