import os
from dotenv import load_dotenv
from pathlib import Path

load_dotenv(Path('C:/xampp/htdocs/voice-agent/agent/.env'))

import mysql.connector

print("DB_HOST =", os.environ.get('DB_HOST'))
print("DB_PORT =", os.environ.get('DB_PORT'))
print("DB_USER =", os.environ.get('DB_USER'))
print("DB_NAME =", os.environ.get('DB_NAME'))

try:
    conn = mysql.connector.connect(
        host=os.environ.get('DB_HOST'),
        port=int(os.environ.get('DB_PORT', '3306')),
        user=os.environ.get('DB_USER'),
        password=os.environ.get('DB_PASS'),
        database=os.environ.get('DB_NAME'),
        ssl_disabled=True,
        connection_timeout=10
    )
    print("Connected:", conn.is_connected())
    conn.close()
except Exception as e:
    print("ERROR:", e)