56 lines
1.7 KiB
PHP
56 lines
1.7 KiB
PHP
<?php
|
|
require_once __DIR__ . '/config.php';
|
|
|
|
try {
|
|
$pdo = db();
|
|
echo "Connected to database successfully.\n";
|
|
|
|
$migrations = glob(__DIR__ . '/migrations/*.sql');
|
|
sort($migrations);
|
|
|
|
foreach ($migrations as $migrationFile) {
|
|
if (!file_exists($migrationFile)) {
|
|
die("Migration file not found: $migrationFile\n");
|
|
}
|
|
echo "Applying migration: " . basename($migrationFile) . "...\n";
|
|
$sql = file_get_contents($migrationFile);
|
|
$pdo->exec($sql);
|
|
}
|
|
|
|
echo "Migrations applied successfully.\n";
|
|
|
|
// Now, let's insert the initial data from data.php into the new 'cases' table.
|
|
require_once __DIR__ . '/../data.php';
|
|
|
|
$stmt = $pdo->prepare(
|
|
"INSERT INTO cases (fir_no, ps, accused_name, sections, complainant, address, facts)
|
|
VALUES (:fir_no, :ps, :accused_name, :sections, :complainant, :address, :facts)
|
|
ON DUPLICATE KEY UPDATE
|
|
ps=VALUES(ps),
|
|
accused_name=VALUES(accused_name),
|
|
sections=VALUES(sections),
|
|
complainant=VALUES(complainant),
|
|
address=VALUES(address),
|
|
facts=VALUES(facts)"
|
|
);
|
|
|
|
$cases = get_mock_cases();
|
|
foreach ($cases as $case) {
|
|
$stmt->execute([
|
|
':fir_no' => $case['fir_no'],
|
|
':ps' => $case['ps'],
|
|
':accused_name' => $case['accused_name'],
|
|
':sections' => $case['sections'],
|
|
':complainant' => $case['complainant'],
|
|
':address' => $case['address'],
|
|
':facts' => $case['facts'],
|
|
]);
|
|
}
|
|
|
|
echo "Initial case data seeded into the database.\n";
|
|
|
|
|
|
} catch (PDOException $e) {
|
|
die("Database error: " . $e->getMessage() . "\n");
|
|
}
|