import mysql.connector
from mysql.connector import Error

def get_connection():
    try:
        connection = mysql.connector.connect(
            host="10.31.105.4",
            user="admin_root",
            password="r-HvaKVo_96YoJ-d",
            database="imparables_dev"
        )
        # connection = mysql.connector.connect(
        #     host="rds-mysql01.crs0e6k0ssxf.us-east-2.rds.amazonaws.com",
        #     user="agencycic",
        #     password="3fU(>C&~I[X5,}%",
        #     database="imparables"
        # )
        if connection.is_connected():
            return connection
    except Error as e:
        print(f"Error de conexión: {e}")
        import logging
        logging.error(f"Error de conexión: {e}")
        return None