#!/usr/bin/env python3
# Test-Script für Datenbankverbindungen

import mysql.connector
from mysql.connector import Error

# Test-Konfigurationen
configs = [
    {
        'name': 'Admin User (aktuell)',
        'host': 'localhost',
        'database': 'u750951906_NexusControl',
        'user': 'u750951906_admin',
        'password': 'HOk~k5$!0q',
        'charset': 'utf8mb4'
    },
    {
        'name': 'Root User',
        'host': 'localhost',
        'database': 'u750951906_NexusControl',
        'user': 'root',
        'password': '',  # Passwort anpassen
        'charset': 'utf8mb4'
    }
]

def test_connection(config):
    """Testet eine Datenbankverbindung"""
    try:
        print(f"\n🔍 Teste: {config['name']}")
        conn = mysql.connector.connect(**config)
        cursor = conn.cursor()
        
        # Test-Query
        cursor.execute("SELECT 'Connection successful!' as status")
        result = cursor.fetchone()
        
        print(f"✅ {result[0]}")
        print(f"   Datenbank: {conn.database}")
        print(f"   Benutzer: {conn.user}")
        
        conn.close()
        return True
        
    except Error as e:
        print(f"❌ Fehler: {e}")
        return False

if __name__ == "__main__":
    print("=== Datenbank-Verbindungstest ===")
    
    for config in configs:
        test_connection(config)
    
    print("\n💡 Tipp: Passwörter bei Bedarf anpassen!")