
    Xj                     2   d dl mZ d dlmZ d dlmZ d dlmZ d dlm	Z	  e	e
          Z e            Zej                            dd          Z eedd	d
ej                  Z edde          Z e            Ze                    d           d Zd ZdS )    )create_engine)declarative_base)sessionmaker)get_settings)
get_loggerzpostgresql://zpostgresql+psycopg://T
      )pool_pre_ping	pool_sizemax_overflowechoF)
autocommit	autoflushbindzdatabase engine createdc               #      K   t                      } 	 | V  |                                  d S # |                                  w xY w)N)SessionLocalclose)dbs    :/lsinfo/ai/hellotax_ai/data_center/backend/app/database.pyget_dbr      s@      	B









s	   , Ac                  v   ddl m}  t                                          5 }|                     | dt
          j                              |                                 d d d            n# 1 swxY w Y   t
          j        t          j	        _
        t                              dt
          j                    d S )Nr   )textzCREATE SCHEMA IF NOT EXISTS zdatabase schema initialized: )
sqlalchemyr   engineconnectexecutesettingsdatabase_schemacommitBasemetadataschemaloggerinfo)r   conns     r   init_dbr&      s    			 TTTS9QSSTTUUU               $3DM
KKJ0HJJKKKKKs   A A,,A03A0N)r   r   sqlalchemy.ext.declarativer   sqlalchemy.ormr   
app.configr   common_loggingr   __name__r#   r   database_url_with_schemareplacedatabase_urldebugr   r   r    r$   r   r&        r   <module>r2      s   $ $ $ $ $ $ 7 7 7 7 7 7 ' ' ' ' ' ' # # # # # # % % % % % %	H		<>>088Jabb	|42TV]e]k	l	l	l|uFKKK % & & &  L L L L Lr1   