<?php
require_once __DIR__ . '/config/db.php';

$sql = file_get_contents(__DIR__ . '/../assets/data/waypoints.sql');
if ($sql === false) { exit("SQL-Datei nicht gefunden\n"); }

try {
    $db = getDB();
    $db->exec($sql);
    $count = $db->query("SELECT COUNT(*) FROM geo_waypoints")->fetchColumn();
    echo "OK — $count Waypoints geladen.\n";
} catch (PDOException $e) {
    exit("Fehler: " . $e->getMessage() . "\n");
}