import os

try:
    from dotenv import load_dotenv

    load_dotenv()
except ImportError:
    pass

DB_HOST = os.getenv("DB_HOST", "localhost")
DB_PORT = int(os.getenv("DB_PORT", "3306"))
DB_USER = os.getenv("DB_USER", "moonuserh")
DB_PASS = os.getenv("DB_PASS", "")
DB_NAME_MOONFLOW = os.getenv("DB_NAME_MOONFLOW", "moonflow")

def get_db_config() -> dict:
    """Retorna el diccionario de conexión para mysql.connector."""
    return {
        "host": 'localhost',
        "port": '3306',
        "user": 'moonuserh',
        "password": 't5/1iokiz)dh7ifU',
        "database": 'moonflow',
        "charset": "utf8mb4",
        "use_unicode": True,
        "connection_timeout": 10,
    }