;i dZddlZddlZdZdS)a Database connection module for Dr. Robert Young's semantic search system This module provides database connection functionality for the semantic search system. It manages MySQL connections for storing and retrieving articles with their embeddings. Configuration: - Supports environment variables for cloud deployment (Railway, Render, etc.) - Falls back to localhost defaults for local development - Environment variables: * DB_HOST: Database host (default: localhost) * DB_USER: Database username (default: root) * DB_PASSWORD: Database password (default: empty string) * DB_NAME: Database name (default: case_studies_db) Usage: - Local development: Works automatically with defaults - Cloud deployment: Set environment variables in platform settings Nc tjtjdptjddtjdptjddtjdptjdd tjd ptjd d t tjd ptjddS)a Establish and return a connection to the MySQL database This function creates a connection using environment variables if available, otherwise falls back to localhost defaults for development. Environment variables (optional): - DB_HOST: Database host - DB_USER: Database username - DB_PASSWORD: Database password - DB_NAME: Database name Returns: mysql.connector.connection.MySQLConnection: Database connection object Note: - Automatically detects local vs cloud environment - Local: Uses localhost with default credentials - Cloud: Uses environment variables from platform DB_HOST MYSQLHOST localhostDB_USER MYSQLUSERroot DB_PASSWORD MYSQLPASSWORDDB_NAME MYSQLDATABASEcase_studies_dbDB_PORT MYSQLPORT3306)hostuserpassworddatabaseport)mysql connectorconnectosgetenvintUC:\Users\Aakash\Desktop\Scrapping\Chatbot-Dr.Young O Robert\scraper\..\database\db.pyget_connectionr!s* ? " " Yy ! ! HRY{K%H%H Yy ! ! CRY{F%C%C=))KRY-K-K9%%V?DU)V)V 9%%G;)G)G H H #  r)__doc__rmysql.connectorrr!rrr r$sA* r