
    KiU                     4    d dl Zd dlmZ  G d d          ZdS )    N)MOVIEO_DATABASEc                       e Zd Zd Zd Zd Zddededefd	Zd
efdZde	defdZ
d ZddededefdZddede	fdZddede	fdZde	defdZde	defdZddededefdZdS )MovieoDatabasec                     t          j        j        di t          | _        | j                            d          | _        d S )NT)buffered )mysql	connectorconnectr   
connectioncursordbselfs    1/var/www/html/auto_sub_bot/base/utils/database.py__init__zMovieoDatabase.__init__   s:    !O3FFoFF/(($(77    c                     | S Nr   r   s    r   	__enter__zMovieoDatabase.__enter__	   s    r   c                 j    | j                                          | j                                         d S r   )r   closer   )r   exc_typeexc_valexc_tbs       r   __exit__zMovieoDatabase.__exit__   s+    r   *ORDER BY id ASCcolumngetorderc                     d                     |||          }| j                            ||f           | j                                        S )Nz$SELECT {} FROM titles WHERE {}=%s {}formatr   executefetchallr   r   idr    r!   sqls         r   	get_titlezMovieoDatabase.get_title   sE    4;;CuMMbU###w!!!r   imdb_idc                 h   d}| j                             ||f           | j         j        }| j                                         d}| j                             ||f           | j                                         d}| j                             ||f           | j                                         |S )Nz(INSERT INTO titles (imdb_id) VALUES (%s)z*INSERT INTO titles_rating (id) VALUES (%s)z)INSERT INTO titles_views (id) VALUES (%s))r   r%   	lastrowidr   commit)r   r+   r)   last_ids       r   	add_titlezMovieoDatabase.add_title   s    8gZ((('#   :gZ(((   9gZ(((   r   title_idc                     d                     |          }| j                            |||f           | j                                         d S )Nz'UPDATE titles SET {} = %s WHERE id = %sr$   r   r%   r   r.   )r   r1   r   entryr)   s        r   update_titlezMovieoDatabase.update_title"   sI    7>>vFFeX/000   r   c                    d}| j                             ||f           | j                                         d}| j                             ||f           | j                                         d}| j                             ||f           | j                                         d}| j                             ||f           | j                                         d S )Nz"DELETE FROM `titles` WHERE id = %sz)DELETE FROM `titles_rating` WHERE id = %sz(DELETE FROM `titles_views` WHERE id = %sz'DELETE FROM `files` WHERE title_id = %s)r   r%   r   r.   )r   r1   r)   s      r   delete_titlezMovieoDatabase.delete_title(   s    2h[)))   9h[)))   8h[)))   7h[)))   r   c                     d                     |||          }| j                            ||f           | j                                        S )Nz#SELECT {} FROM files WHERE {}=%s {}r#   r'   s         r   	get_fileszMovieoDatabase.get_files7   sE    3::3veLLbU###w!!!r   r(   c                     d| d| d| }| j                             ||f           | j                                         S )NSELECT z FROM users_requests WHERE =%s r   r%   r&   r'   s         r   get_users_requestsz!MovieoDatabase.get_users_requests<   sK    KKKKKEKKbU###w!!!r   c                     d| d| d| }| j                             ||f           | j                                         S )Nr;   z FROM admins_requests WHERE r<   r=   r'   s         r   get_admins_requestsz"MovieoDatabase.get_admins_requestsA   sK    LLLLLULLbU###w!!!r   
request_idc                     d                     |          }| j                            |||f           | j                                         d S )Nz0UPDATE admins_requests SET {} = %s WHERE id = %sr3   r   rA   r   r4   r)   s        r   update_admins_requestsz%MovieoDatabase.update_admins_requestsF   sI    @GGOOeZ1222   r   c                     d                     |          }| j                            |||f           | j                                         d S )Nz/UPDATE users_requests SET {} = %s WHERE id = %sr3   rC   s        r   update_users_requestsz$MovieoDatabase.update_users_requestsL   sI    ?FFvNNeZ1222   r   c                     d                     |||          }| j                            ||f           | j                                        S )Nz/SELECT {} FROM `30nama_accounts` WHERE {}=%s {}r#   r'   s         r   get_30nama_accountz!MovieoDatabase.get_30nama_accountR   sF    ?FFs6RWXXbU###w!!!r   N)r   r   )__name__
__module____qualname__r   r   r   strr*   r0   intr5   r7   r9   r>   r@   rD   rF   rH   r   r   r   r   r      s       8 8 8       " " "c " " " " "
    S #      " " "c " " " " "
" " "# " " " "
" "# "3 " " " "
 c     S    " " "s " " " " " " "r   r   )mysql.connectorr	   configr   r   r   r   r   <module>rP      s_        " " " " " "Q" Q" Q" Q" Q" Q" Q" Q" Q" Q"r   