U
    >Fj                     @   s8   d Z ddlZddlmZ ddlZdd Zedd ZdS )zMySQL connection helper.    N)contextmanagerc                  C   s   ddl m}  |   td}td}td}ttdp@d}td}t|||||gshtd	tj	j
|||||d
dS )Nr   )Config
MYSQL_HOST
MYSQL_USERMYSQL_PASSWORD
MYSQL_PORTi  MYSQL_DATABASEz#Missing MySQL environment variablesF)hostuserpasswordportdatabase
autocommit)configr   validate_database_environmentosgetenvintall	Exceptionmysql	connectorconnect)r   r	   r
   r   r   r    r   (/var/www/html/LojaOnline_hml/database.pyconectar   s"    



r   c                  c   sL   t  } z6z| V  |   W n tk
r8   |    Y nX W 5 |   X d S )N)r   closecommitr   rollback)connr   r   r   transaction   s    r    )__doc__r   
contextlibr   mysql.connectorr   r   r    r   r   r   r   <module>   s   