# Importando Libreria mysql.connector para conectar Python con MySQL
import os
import mysql.connector


def connectionBD():

    try:
        # connection = mysql.connector.connect(
        connection = mysql.connector.connect(
            host=os.environ.get("DB_HOST", "localhost"),
            user=os.environ.get("DB_USER", "informatica"),
            passwd=os.environ.get("DB_PASS", "Ugel2025*"),
            database=os.environ.get("DB_NAME", "ugelcond_python"),
            charset='utf8mb4',
            collation='utf8mb4_unicode_ci',
            raise_on_warnings=True,
        )

        if connection.is_connected():
            # print("Conexión exitosa a la BD")
            return connection

    except mysql.connector.Error as error:
        print(f"No se pudo conectar: {error}")