U
|
TÚ(eu ã @ s$ d dl mZ G dd dZe ZdS )é )Ú create_enginec @ sL e Zd ZdZdZdZdZdZdZdZ dZ
|
dd Z d
|
d Z e e d d dZdS )ÚDataBaseu è¿ç¨æ°æ®åº Nz114.215.109.124Ú
|
fumeRemoteÚ feiyu2023iê Úfumec C s\ | j d ks| j jrVtd| j d| j d| j d| j d| j d dddd }| ¡ | _ | j S )
|
Númysql+pymysql://ú:ú@ú/ú ?charset=utf8é é r ©Ú pool_recycleÚ pool_sizeÚ max_overflow) Úcon_readÚclosedr ÚuserÚpasswordÚipÚportÚdata_base_nameÚconnect©ÚselfÚengine© r ú:e:\PycharmProject\fugitive_dust_new\db\database_connect.pyÚ connect_remote_database_read s , ÿ
|
z%DataBase.connect_remote_database_readc C s\ | j dks| j jrVtd| j d| j d| j d| j d| j d ddd d
|
}| ¡ | _ | j S ) u åNr r r r
|
r r r r r ) Ú con_writer r r r r r r r r r r r Ú connect_remote_database_write" s , ÿ
|
z&DataBase.connect_remote_database_write)Ú area_typeÚ option_typec C s | j ¡ dS )u¤ "æå¼è¿æ¥
|
|
Args:
|
area_type (str): æ°æ®åºæå±ä½ç½®ãlocalä¸remote
|
option_type (str): æä½ç±»åãwriteåread
|
N)r Úclose)r r" r# r r r Ú
|
disconnect+ s zDataBase.disconnect)Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r r r r r r r r r! Ústrr% r r r r r s r N)Ú
|
sqlalchemyr r Údatebase_single_objr r r r Ú<module> s 3
|
