44 lines
1.4 KiB
PHP
Executable File
44 lines
1.4 KiB
PHP
Executable File
#!/usr/bin/env php
|
|
<?php
|
|
require __DIR__ . '/../bootstrap/autoload.php';
|
|
|
|
use App\Core\Database;
|
|
|
|
date_default_timezone_set(config('app.timezone', 'UTC'));
|
|
|
|
$pdo = Database::connection();
|
|
$config = config('database');
|
|
$migrationsTable = $config['migrations_table'];
|
|
$pdo->exec("CREATE TABLE IF NOT EXISTS {$migrationsTable} (id INT AUTO_INCREMENT PRIMARY KEY, migration VARCHAR(255) NOT NULL, ran_at DATETIME NOT NULL)");
|
|
|
|
$statement = $pdo->query("SELECT migration FROM {$migrationsTable}");
|
|
$ran = $statement ? $statement->fetchAll(PDO::FETCH_COLUMN) : [];
|
|
|
|
$files = glob(base_path('database/migrations/*.php'));
|
|
sort($files);
|
|
|
|
foreach ($files as $file) {
|
|
$name = basename($file);
|
|
if (in_array($name, $ran, true)) {
|
|
continue;
|
|
}
|
|
|
|
$migration = require $file;
|
|
if (!is_callable($migration)) {
|
|
throw new RuntimeException("Migration {$name} must return a callable.");
|
|
}
|
|
|
|
$pdo->beginTransaction();
|
|
try {
|
|
$migration($pdo);
|
|
$stmt = $pdo->prepare("INSERT INTO {$migrationsTable} (migration, ran_at) VALUES (:migration, :ran_at)");
|
|
$stmt->execute(['migration' => $name, 'ran_at' => (new \DateTimeImmutable())->format('Y-m-d H:i:s')]);
|
|
$pdo->commit();
|
|
echo "Migrated: {$name}\n";
|
|
} catch (\Throwable $e) {
|
|
$pdo->rollBack();
|
|
fwrite(STDERR, "Failed: {$name} - {$e->getMessage()}\n");
|
|
exit(1);
|
|
}
|
|
}
|