
    R&ig                     >    S r SSKJr  SSKrSSKJr  S r\S 5       rg)zMySQL connection helper.    )contextmanagerN)Configc            	          [         R                  R                  [        R                  [        R
                  [        R                  [        R                  [        R                  SS9$ )NF)hostuserpasswordportdatabase
autocommit)	mysql	connectorconnectr   
MYSQL_HOST
MYSQL_USERMYSQL_PASSWORD
MYSQL_PORTMYSQL_DATABASE     BC:\Users\user\Desktop\Projetos_em_andamento\LojaOnline\database.pyconectarr   	   sN    ??""&&&& #  r   c               #      #    [        5       n  U v   U R                  5          U R	                  5         g ! [         a    U R                  5         e f = f! U R	                  5         f = f7f)N)r   commit	Exceptionrollbackclose)conns    r   transactionr      sR     :D

 	

	   	

s%   A(4 A(AA A%%A()	__doc__
contextlibr   mysql.connectorr   configr   r   r   r   r   r   <module>r#      s*     %   	 	r   