36 lines
1.2 KiB
PHP
36 lines
1.2 KiB
PHP
<?php
|
|
require_once __DIR__ . '/config.php';
|
|
|
|
try {
|
|
$pdo = db();
|
|
// Check if table is empty
|
|
$stmt = $pdo->query("SELECT COUNT(*) FROM holidays");
|
|
if ($stmt->fetchColumn() > 0) {
|
|
echo "Holidays table is not empty. Skipping seeding.\n";
|
|
exit;
|
|
}
|
|
|
|
$holidays = [
|
|
['name' => 'New Year\'s Day', 'holiday_date' => '2025-01-01'],
|
|
['name' => 'Martin Luther King, Jr. Day', 'holiday_date' => '2025-01-20'],
|
|
['name' => 'Presidents\' Day', 'holiday_date' => '2025-02-17'],
|
|
['name' => 'Memorial Day', 'holiday_date' => '2025-05-26'],
|
|
['name' => 'Juneteenth', 'holiday_date' => '2025-06-19'],
|
|
['name' => 'Independence Day', 'holiday_date' => '2025-07-04'],
|
|
['name' => 'Labor Day', 'holiday_date' => '2025-09-01'],
|
|
['name' => 'Thanksgiving Day', 'holiday_date' => '2025-11-27'],
|
|
['name' => 'Christmas Day', 'holiday_date' => '2025-12-25'],
|
|
];
|
|
|
|
$stmt = $pdo->prepare("INSERT INTO holidays (name, holiday_date) VALUES (:name, :holiday_date)");
|
|
|
|
foreach ($holidays as $holiday) {
|
|
$stmt->execute($holiday);
|
|
}
|
|
|
|
echo "Holidays table seeded successfully.\n";
|
|
|
|
} catch (PDOException $e) {
|
|
die("Could not seed database: " . $e->getMessage());
|
|
}
|