
    ͟ i              	       (   d dl Z d dlmZmZ d dlmZ d dlmZ  e              e j        d          Z	 e j        d          Z
 e j        dd          Z e j        d	          Zd
e	 de
 de de d	Z eedd          Z edde          Zd ZdS )    N)create_enginetext)sessionmaker)load_dotenvDB_USERDB_PASSWORDDB_HOST	localhostDB_NAMEzmysql+pymysql://:@/z?charset=utf8mb4Ti  )pool_pre_pingpool_recycleF)
autocommit	autoflushbindc                     t                                           5 } |                     t          d                     d |                     t          d                    D             }|cd d d            S # 1 swxY w Y   d S )NzSELECT 1c                     g | ]
}|d          S )r    ).0rows     /var/www/findabus/app/db.py
<listcomp>z"db_healthcheck.<locals>.<listcomp>   s    FFFS#a&FFF    zSHOW TABLES)engineconnectexecuter   )conntabless     r   db_healthcheckr!      s    			 TT*%%&&&FFDLLm1D1D$E$EFFF                 s   AA77A;>A;)os
sqlalchemyr   r   sqlalchemy.ormr   dotenvr   getenvr   r   r	   r   URLr   SessionLocalr!   r   r   r   <module>r)      s   				 * * * * * * * * ' ' ' ' ' '       
")I

bi&&
")I{
+
+
")I

TTT;TTTT7TTT	s$T	B	B	B|uFKKK    r   