<?php

require_once "./include/sql_db.php";

header('Content-Type: application/json');
http_response_code(200);

$response = [
    "Host"      => getDbHost(),
    "InService" => false
];

try {
    $pdo = getDbConnection();

    // Lightweight health check
    $stmt = $pdo->query("SELECT 1 AS Alive");
    $result = $stmt->fetch();

    if (!empty($result['Alive'])) {
        $response['InService'] = true;
    }
} catch (Throwable $e) {
    $response['sqlError'] = $e->getMessage();
}

echo json_encode($response, JSON_PRETTY_PRINT);
?>