<?php
$dsn = "pgsql:host=localhost;dbname=adx_system2";
$username = "admin";  
$password = "656//8520//@963PMloik";

// Simulation exacte de ce que fait le contrôleur save()
echo "Test simulation save() du contrôleur...\n";

try {
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Données de test exactement comme le formulaire
    $data = [
        'name' => 'Test-Simulation',
        'status' => 'Activated', 
        'region' => 'eu-west-101',
        'access_key' => 'SIMULATION123456789',
        'secret_key' => 'simulation_secret_key_123456',
        'project_id' => '',
        'domain_id' => ''
    ];
    
    echo "Données préparées:\n";
    print_r($data);
    
    // Test INSERT direct comme le ferait ActiveRecord
    $sql = "INSERT INTO admin.huawei_accounts 
            (name, status, region, access_key, secret_key, project_id, domain_id, created_by, created_date, last_updated_by, last_updated_date) 
            VALUES 
            (:name, :status, :region, :access_key, :secret_key, :project_id, :domain_id, :created_by, CURRENT_DATE, :last_updated_by, CURRENT_DATE)";
    
    $stmt = $pdo->prepare($sql);
    
    $params = [
        ':name' => $data['name'],
        ':status' => $data['status'],  
        ':region' => $data['region'],
        ':access_key' => $data['access_key'],
        ':secret_key' => $data['secret_key'],
        ':project_id' => $data['project_id'] ?: null,
        ':domain_id' => $data['domain_id'] ?: null,
        ':created_by' => 'test@example.com',
        ':last_updated_by' => 'test@example.com'
    ];
    
    echo "Paramètres SQL:\n";
    print_r($params);
    
    $result = $stmt->execute($params);
    
    if ($result) {
        $id = $pdo->lastInsertId();
        echo "✓ INSERT réussi! ID généré: $id\n";
    } else {
        echo "✗ Échec INSERT\n";
        print_r($stmt->errorInfo());
    }
    
} catch (Exception $e) {
    echo "✗ ERREUR: " . $e->getMessage() . "\n";
    echo "Code: " . $e->getCode() . "\n";
}

echo "\nTest de simulation terminé.\n";
?>