o
    h                     @   s  d dl mZ d dlZd dlmZ d dlmZmZ d dlm	Z	 d dl
mZ e	e jjd Zeed e	e jjd Zeed ed	d
ZeddZeddZedZedZeedZe de de de de de Zdd ZeeddZeddedZe ZdS )    )
quote_plusN)create_engine)sessionmakerdeclarative_base)Path)load_dotenvz.env)dotenv_pathDB_CONNECTIONZmysqlDB_HOST	localhostDB_PORTZ3306DB_DATABASEDB_USERNAMEDB_PASSWORDz+pymysql://:@/c                  c   s(    t  } z
| V  W |   d S |   w )N)SessionLocalclose)db r   */var/www/html/vive_backend/app/database.pyget_db   s
   r   T)Zpool_pre_pingF)Z
autocommitZ	autoflushbind)urllib.parser   osZ
sqlalchemyr   Zsqlalchemy.ormr   r   pathlibr   dotenvr   __file__resolveparentr   getenvr	   r
   r   r   r   r   ZDATABASE_URLr   enginer   Baser   r   r   r   <module>   s8    




