umbrellio / rollback-missing-migrations

src/Console/RollbackNewMigrations.php

<?php

declare(strict_types=1);

namespace Umbrellio\RollbackMissingMigrations\Console;

use Illuminate\Console\Command;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\App;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Str;
use SplFileInfo;

class RollbackNewMigrations extends Command
{
    private const COMMAND_PATTERN = 'git ls-tree --name-only origin/master {git_migrations_path}';

    protected $signature = 'rollback_new_migrations:rollback {--git_migrations_path=}';
    protected $description = 'Rollback new migrations (default way for k8s staging)';

    public function handle(): void
    {
        if (App::environment('production')) {
            $this->error('It`s restricted to rollback new migrations on production.');
            return;
        }

        $gitMigrationsPath = $this->option('git_migrations_path') ?? 'database/migrations/';
        $gitCommand = str_replace('{git_migrations_path}', $gitMigrationsPath, self::COMMAND_PATTERN);

        $migrationsFromMaster = collect(explode(PHP_EOL, shell_exec($gitCommand)))
            ->filter()
            ->map(fn (string $path) => new SplFileInfo(base_path($path)));
        $migrationsFromCurrent = collect(File::files(base_path('database/migrations')));

        /** @var Collection|SplFileInfo[] $migrationsToRollback */
        $migrationsToRollback = $migrationsFromCurrent->keyBy->getFileName()
            ->diffKeys($migrationsFromMaster->keyBy->getFileName())
            ->sort(fn (SplFileInfo $file1, SplFileInfo $file2) => strcmp($file1->getFilename(), $file2->getFilename()))
            ->reverse();

        if ($migrationsToRollback->isEmpty()) {
            $this->info('There are no migrations to rollback.');
            return;
        }

        DB::transaction(function () use ($migrationsToRollback) {
            foreach ($migrationsToRollback as $migration) {
                $this->info('Rolling back: ' . $migration->getFilename());
                $this->downMigrationFile($migration);
            }
        });
    }

    private function downMigrationFile(SplFileInfo $f): void
    {
        $migration = require_once $f;
        $filename = explode('.php', $f->getRelativePathname())[0];

The method getRelativePathname() does not exist on SplFileInfo. It seems like you code against a sub-type of SplFileInfo such as Nette\Utils\FileInfo or Psy\Readline\Hoa\IteratorSplFileInfo or ECSPrefix20211002\Symfony\Component\Finder\SplFileInfo or Symfony\Component\Finder\SplFileInfo or Illuminate\Http\UploadedFile.

        if (!$migration instanceof Migration) {
            $class = Str::studly(implode('_', array_slice(explode('_', $filename), 4)));
            $migration = new $class();
        }
        if (method_exists($migration, 'down')) {
            $migration->down();
            DB::table(config('database.migrations', 'migrations'))->where('migration', $filename)->delete();
        }
    }
}