a %i!@s\dZddlZddlmZddlmZddlZddZddZdad d Z d d Z d dZ dS)z[ Database connection pooling. Uses mysql-connector-python pool for efficient connections. N)pooling)configcCstd|dS)Nz[INFO] printmsgr5/var/www/lichun.app/lichun/ws/database/../database.pylog_info sr cCstd|dS)Nz[ERROR] rrrrr log_errorsr c CstdurzBtjdttjddtjtjtjtj tj dat dtjdWn4t y~}zt d|WYd}~n d}~00tS) z] Get or create database connection pool. Returns: MySQL connection pool NZ baolife_pool T) pool_name pool_sizepool_reset_sessionhostportuserpassworddatabasez(Database connection pool created (size: )z"Failed to create connection pool: )_connection_poolrMySQLConnectionPoolminrMAX_CONNECTIONSDB_HOSTDB_PORTDB_USER DB_PASSWORDDB_NAMEr Exceptionr )errr get_connection_pools"   r!c CsJzt}|WStyD}ztd|WYd}~n d}~00dS)a Get database connection from pool. Returns: MySQL connection Usage: conn = get_database_connection() try: cursor = conn.cursor() cursor.execute("SELECT ...") finally: conn.close() # Returns to pool z#Failed to get database connection: N)r!get_connectionrr )poolr rrr get_database_connection4s  r$cCstrdatddS)z+Close all connections in pool (for cleanup)NzDatabase connection pool closed)rr rrrr close_connection_poolKsr%) __doc__mysql.connectormysqlrrloggingr r rr!r$r%rrrr s