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

$categories = [
    'Fitness',
    'Passing',
    'Dribbling',
    'Shooting',
    'Defense',
    'Goalkeeping',
    'Set Pieces',
    'Tactical'
];

try {
    $pdo = db();
    $stmt = $pdo->prepare("INSERT IGNORE INTO categories (name) VALUES (?)");

    foreach ($categories as $category) {
        $stmt->execute([$category]);
    }

    echo "Categories seeded successfully.\n";

} catch (PDOException $e) {
    die("Error seeding categories: " . $e->getMessage());
}