
     h                         d dl mZmZmZmZmZmZmZ d dlm	Z	m
Z
 d dlmZ  ede      Zej                  dddg      d	        Zej                  d
      d        Zy)    )	Blueprintrequestrender_templateredirecturl_forflashsession)generate_password_hashcheck_password_hash)get_db_connectionauth_bpz/loginGETPOST)methodsc                  P   t         j                  dk(  rt         j                  j                  d      } t         j                  j                  d      }t	               }|j                         5 }|j                  d| f       |j                         }d d d        |j                          rGt        |d   |      r8|d   t        d<   |d   t        d<   t        d	d
       t        t        d            S t        dd       t        t        d            S t        d      S # 1 sw Y   xY w)Nr   usernamepasswordz%SELECT * FROM users WHERE username=%spassword_hashiduser_idroleu+   Успешный вход в системуsuccessmain_bp.indexu/   Неверный логин или парольdangerzauth_bp.loginz
login.html)r   methodformgetr   cursorexecutefetchonecloser   r	   r   r   r   r   )r   r   conncurusers        +/var/www/html/app/blueprints/auth/routes.pyloginr&      s    ~~<<##J/<<##J/ !"[[] 	"cKK?(M<<>D	" 	

 '_(=xH!%dGI"6lGFO?KGO455CXNGO455<((	" 	"s   ,$DD%z/logoutc                  j    t        j                          t        dd       t        t	        d            S )Nu$   Вы вышли из системы.infor   )r	   clearr   r   r        r%   logoutr,       s&    MMO	
0&9GO,--r+   N)flaskr   r   r   r   r   r   r	   werkzeug.securityr
   r   app.databaser   __name__r   router&   r,   r*   r+   r%   <module>r2      sb    X X X I *
Ix
( 	x%1) 2). 	y. .r+   