
    Ւi.                         d Z ddlmZmZmZ ddlmZ ddlmZ ddl	Z	 e	j
        dd          Z e	j        dd	
            eed          Zd Zdeeddf         fdZd ZdS )z,
Database connection and session management
    )SQLModelcreate_engineSession)	Generator)loggerNDATABASE_URLzsqlite:///./data/hk_racing.dbdataT)exist_okF)echoc                      t          j        d           t          j                            t
                     t          j        d           dS )zCreate database and tableszCreating database tables...u   ✅ Database tables createdN)r   infor   metadata
create_allengine     T/home/node/.openclaw/workspace-simple/hk-racing-analytics/backend/app/db/database.pycreate_db_and_tablesr      sA    
K-...  (((
K-.....r   returnc               #   l   K   t          t                    5 } | V  ddd           dS # 1 swxY w Y   dS )zGet database sessionN)r   r   )sessions    r   get_sessionr      s|      	 G                 s   )--c                  "    t                       dS )zInitialize databaseN)r   r   r   r   init_dbr   #   s    r   )__doc__sqlmodelr   r   r   typingr   logurur   osgetenvr   makedirsr   r   r   r   r   r   r   <module>r"      s     6 5 5 5 5 5 5 5 5 5             				 ry#  FT " " " " 
|%	0	0	0/ / /Ywd23        r   