<form method="POST">
    <h3>Editing: Migrator.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php

namespace Illuminate\Database\Migrations;

use Doctrine\DBAL\Schema\SchemaException;
use Illuminate\Contracts\Events\Dispatcher;
use Illuminate\Database\ConnectionResolverInterface as Resolver;
use Illuminate\Database\Events\MigrationEnded;
use Illuminate\Database\Events\MigrationsEnded;
use Illuminate\Database\Events\MigrationsStarted;
use Illuminate\Database\Events\MigrationStarted;
use Illuminate\Database\Events\NoPendingMigrations;
use Illuminate\Filesystem\Filesystem;
use Illuminate\Support\Arr;
use Illuminate\Support\Collection;
use Illuminate\Support\Str;
use ReflectionClass;
use Symfony\Component\Console\Output\OutputInterface;

class Migrator
{
    /**
     * The event dispatcher instance.
     *
     * @var \Illuminate\Contracts\Events\Dispatcher
     */
    protected $events;

    /**
     * The migration repository implementation.
     *
     * @var \Illuminate\Database\Migrations\MigrationRepositoryInterface
     */
    protected $repository;

    /**
     * The filesystem instance.
     *
     * @var \Illuminate\Filesystem\Filesystem
     */
    protected $files;

    /**
     * The connection resolver instance.
     *
     * @var \Illuminate\Database\ConnectionResolverInterface
     */
    protected $resolver;

    /**
     * The name of the default connection.
     *
     * @var string
     */
    protected $connection;

    /**
     * The paths to all of the migration files.
     *
     * @var array
     */
    protected $paths = [];

    /**
     * The output interface implementation.
     *
     * @var \Symfony\Component\Console\Output\OutputInterface
     */
    protected $output;

    /**
     * Create a new migrator instance.
     *
     * @param  \Illuminate\Database\Migrations\MigrationRepositoryInterface  $repository
     * @param  \Illuminate\Database\ConnectionResolverInterface  $resolver
     * @param  \Illuminate\Filesystem\Filesystem  $files
     * @param  \Illuminate\Contracts\Events\Dispatcher|null  $dispatcher
     * @return void
     */
    public function __construct(MigrationRepositoryInterface $repository,
                                Resolver $resolver,
                                Filesystem $files,
                                Dispatcher $dispatcher = null)
    {
        $this-&gt;files = $files;
        $this-&gt;events = $dispatcher;
        $this-&gt;resolver = $resolver;
        $this-&gt;repository = $repository;
    }

    /**
     * Run the pending migrations at a given path.
     *
     * @param  array|string  $paths
     * @param  array  $options
     * @return array
     */
    public function run($paths = [], array $options = [])
    {
        // Once we grab all of the migration files for the path, we will compare them
        // against the migrations that have already been run for this package then
        // run each of the outstanding migrations against a database connection.
        $files = $this-&gt;getMigrationFiles($paths);

        $this-&gt;requireFiles($migrations = $this-&gt;pendingMigrations(
            $files, $this-&gt;repository-&gt;getRan()
        ));

        // Once we have all these migrations that are outstanding we are ready to run
        // we will go ahead and run them &quot;up&quot;. This will execute each migration as
        // an operation against a database. Then we'll return this list of them.
        $this-&gt;runPending($migrations, $options);

        return $migrations;
    }

    /**
     * Get the migration files that have not yet run.
     *
     * @param  array  $files
     * @param  array  $ran
     * @return array
     */
    protected function pendingMigrations($files, $ran)
    {
        return Collection::make($files)
                -&gt;reject(function ($file) use ($ran) {
                    return in_array($this-&gt;getMigrationName($file), $ran);
                })-&gt;values()-&gt;all();
    }

    /**
     * Run an array of migrations.
     *
     * @param  array  $migrations
     * @param  array  $options
     * @return void
     */
    public function runPending(array $migrations, array $options = [])
    {
        // First we will just make sure that there are any migrations to run. If there
        // aren't, we will just make a note of it to the developer so they're aware
        // that all of the migrations have been run against this database system.
        if (count($migrations) === 0) {
            $this-&gt;fireMigrationEvent(new NoPendingMigrations('up'));

            $this-&gt;note('&lt;info&gt;Nothing to migrate.&lt;/info&gt;');

            return;
        }

        // Next, we will get the next batch number for the migrations so we can insert
        // correct batch number in the database migrations repository when we store
        // each migration's execution. We will also extract a few of the options.
        $batch = $this-&gt;repository-&gt;getNextBatchNumber();

        $pretend = $options['pretend'] ?? false;

        $step = $options['step'] ?? false;

        $this-&gt;fireMigrationEvent(new MigrationsStarted('up'));

        // Once we have the array of migrations, we will spin through them and run the
        // migrations &quot;up&quot; so the changes are made to the databases. We'll then log
        // that the migration was run so we don't repeat it next time we execute.
        foreach ($migrations as $file) {
            $this-&gt;runUp($file, $batch, $pretend);

            if ($step) {
                $batch++;
            }
        }

        $this-&gt;fireMigrationEvent(new MigrationsEnded('up'));
    }

    /**
     * Run &quot;up&quot; a migration instance.
     *
     * @param  string  $file
     * @param  int  $batch
     * @param  bool  $pretend
     * @return void
     */
    protected function runUp($file, $batch, $pretend)
    {
        // First we will resolve a &quot;real&quot; instance of the migration class from this
        // migration file name. Once we have the instances we can run the actual
        // command such as &quot;up&quot; or &quot;down&quot;, or we can just simulate the action.
        $migration = $this-&gt;resolvePath($file);

        $name = $this-&gt;getMigrationName($file);

        if ($pretend) {
            return $this-&gt;pretendToRun($migration, 'up');
        }

        $this-&gt;note(&quot;&lt;comment&gt;Migrating:&lt;/comment&gt; {$name}&quot;);

        $startTime = microtime(true);

        $this-&gt;runMigration($migration, 'up');

        $runTime = number_format((microtime(true) - $startTime) * 1000, 2);

        // Once we have run a migrations class, we will log that it was run in this
        // repository so that we don't try to run it next time we do a migration
        // in the application. A migration repository keeps the migrate order.
        $this-&gt;repository-&gt;log($name, $batch);

        $this-&gt;note(&quot;&lt;info&gt;Migrated:&lt;/info&gt;  {$name} ({$runTime}ms)&quot;);
    }

    /**
     * Rollback the last migration operation.
     *
     * @param  array|string  $paths
     * @param  array  $options
     * @return array
     */
    public function rollback($paths = [], array $options = [])
    {
        // We want to pull in the last batch of migrations that ran on the previous
        // migration operation. We'll then reverse those migrations and run each
        // of them &quot;down&quot; to reverse the last migration &quot;operation&quot; which ran.
        $migrations = $this-&gt;getMigrationsForRollback($options);

        if (count($migrations) === 0) {
            $this-&gt;fireMigrationEvent(new NoPendingMigrations('down'));

            $this-&gt;note('&lt;info&gt;Nothing to rollback.&lt;/info&gt;');

            return [];
        }

        return $this-&gt;rollbackMigrations($migrations, $paths, $options);
    }

    /**
     * Get the migrations for a rollback operation.
     *
     * @param  array  $options
     * @return array
     */
    protected function getMigrationsForRollback(array $options)
    {
        if (($steps = $options['step'] ?? 0) &gt; 0) {
            return $this-&gt;repository-&gt;getMigrations($steps);
        }

        return $this-&gt;repository-&gt;getLast();
    }

    /**
     * Rollback the given migrations.
     *
     * @param  array  $migrations
     * @param  array|string  $paths
     * @param  array  $options
     * @return array
     */
    protected function rollbackMigrations(array $migrations, $paths, array $options)
    {
        $rolledBack = [];

        $this-&gt;requireFiles($files = $this-&gt;getMigrationFiles($paths));

        $this-&gt;fireMigrationEvent(new MigrationsStarted('down'));

        // Next we will run through all of the migrations and call the &quot;down&quot; method
        // which will reverse each migration in order. This getLast method on the
        // repository already returns these migration's names in reverse order.
        foreach ($migrations as $migration) {
            $migration = (object) $migration;

            if (! $file = Arr::get($files, $migration-&gt;migration)) {
                $this-&gt;note(&quot;&lt;fg=red&gt;Migration not found:&lt;/&gt; {$migration-&gt;migration}&quot;);

                continue;
            }

            $rolledBack[] = $file;

            $this-&gt;runDown(
                $file, $migration,
                $options['pretend'] ?? false
            );
        }

        $this-&gt;fireMigrationEvent(new MigrationsEnded('down'));

        return $rolledBack;
    }

    /**
     * Rolls all of the currently applied migrations back.
     *
     * @param  array|string  $paths
     * @param  bool  $pretend
     * @return array
     */
    public function reset($paths = [], $pretend = false)
    {
        // Next, we will reverse the migration list so we can run them back in the
        // correct order for resetting this database. This will allow us to get
        // the database back into its &quot;empty&quot; state ready for the migrations.
        $migrations = array_reverse($this-&gt;repository-&gt;getRan());

        if (count($migrations) === 0) {
            $this-&gt;note('&lt;info&gt;Nothing to rollback.&lt;/info&gt;');

            return [];
        }

        return $this-&gt;resetMigrations($migrations, $paths, $pretend);
    }

    /**
     * Reset the given migrations.
     *
     * @param  array  $migrations
     * @param  array  $paths
     * @param  bool  $pretend
     * @return array
     */
    protected function resetMigrations(array $migrations, array $paths, $pretend = false)
    {
        // Since the getRan method that retrieves the migration name just gives us the
        // migration name, we will format the names into objects with the name as a
        // property on the objects so that we can pass it to the rollback method.
        $migrations = collect($migrations)-&gt;map(function ($m) {
            return (object) ['migration' =&gt; $m];
        })-&gt;all();

        return $this-&gt;rollbackMigrations(
            $migrations, $paths, compact('pretend')
        );
    }

    /**
     * Run &quot;down&quot; a migration instance.
     *
     * @param  string  $file
     * @param  object  $migration
     * @param  bool  $pretend
     * @return void
     */
    protected function runDown($file, $migration, $pretend)
    {
        // First we will get the file name of the migration so we can resolve out an
        // instance of the migration. Once we get an instance we can either run a
        // pretend execution of the migration or we can run the real migration.
        $instance = $this-&gt;resolvePath($file);

        $name = $this-&gt;getMigrationName($file);

        $this-&gt;note(&quot;&lt;comment&gt;Rolling back:&lt;/comment&gt; {$name}&quot;);

        if ($pretend) {
            return $this-&gt;pretendToRun($instance, 'down');
        }

        $startTime = microtime(true);

        $this-&gt;runMigration($instance, 'down');

        $runTime = number_format((microtime(true) - $startTime) * 1000, 2);

        // Once we have successfully run the migration &quot;down&quot; we will remove it from
        // the migration repository so it will be considered to have not been run
        // by the application then will be able to fire by any later operation.
        $this-&gt;repository-&gt;delete($migration);

        $this-&gt;note(&quot;&lt;info&gt;Rolled back:&lt;/info&gt;  {$name} ({$runTime}ms)&quot;);
    }

    /**
     * Run a migration inside a transaction if the database supports it.
     *
     * @param  object  $migration
     * @param  string  $method
     * @return void
     */
    protected function runMigration($migration, $method)
    {
        $connection = $this-&gt;resolveConnection(
            $migration-&gt;getConnection()
        );

        $callback = function () use ($connection, $migration, $method) {
            if (method_exists($migration, $method)) {
                $this-&gt;fireMigrationEvent(new MigrationStarted($migration, $method));

                $this-&gt;runMethod($connection, $migration, $method);

                $this-&gt;fireMigrationEvent(new MigrationEnded($migration, $method));
            }
        };

        $this-&gt;getSchemaGrammar($connection)-&gt;supportsSchemaTransactions()
            &amp;&amp; $migration-&gt;withinTransaction
                    ? $connection-&gt;transaction($callback)
                    : $callback();
    }

    /**
     * Pretend to run the migrations.
     *
     * @param  object  $migration
     * @param  string  $method
     * @return void
     */
    protected function pretendToRun($migration, $method)
    {
        try {
            foreach ($this-&gt;getQueries($migration, $method) as $query) {
                $name = get_class($migration);

                $reflectionClass = new ReflectionClass($migration);

                if ($reflectionClass-&gt;isAnonymous()) {
                    $name = $this-&gt;getMigrationName($reflectionClass-&gt;getFileName());
                }

                $this-&gt;note(&quot;&lt;info&gt;{$name}:&lt;/info&gt; {$query['query']}&quot;);
            }
        } catch (SchemaException $e) {
            $name = get_class($migration);

            $this-&gt;note(&quot;&lt;info&gt;{$name}:&lt;/info&gt; failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.&quot;);
        }
    }

    /**
     * Get all of the queries that would be run for a migration.
     *
     * @param  object  $migration
     * @param  string  $method
     * @return array
     */
    protected function getQueries($migration, $method)
    {
        // Now that we have the connections we can resolve it and pretend to run the
        // queries against the database returning the array of raw SQL statements
        // that would get fired against the database system for this migration.
        $db = $this-&gt;resolveConnection(
            $migration-&gt;getConnection()
        );

        return $db-&gt;pretend(function () use ($db, $migration, $method) {
            if (method_exists($migration, $method)) {
                $this-&gt;runMethod($db, $migration, $method);
            }
        });
    }

    /**
     * Run a migration method on the given connection.
     *
     * @param  \Illuminate\Database\Connection  $connection
     * @param  object  $migration
     * @param  string  $method
     * @return void
     */
    protected function runMethod($connection, $migration, $method)
    {
        $previousConnection = $this-&gt;resolver-&gt;getDefaultConnection();

        try {
            $this-&gt;resolver-&gt;setDefaultConnection($connection-&gt;getName());

            $migration-&gt;{$method}();
        } finally {
            $this-&gt;resolver-&gt;setDefaultConnection($previousConnection);
        }
    }

    /**
     * Resolve a migration instance from a file.
     *
     * @param  string  $file
     * @return object
     */
    public function resolve($file)
    {
        $class = $this-&gt;getMigrationClass($file);

        return new $class;
    }

    /**
     * Resolve a migration instance from a migration path.
     *
     * @param  string  $path
     * @return object
     */
    protected function resolvePath(string $path)
    {
        $class = $this-&gt;getMigrationClass($this-&gt;getMigrationName($path));

        if (class_exists($class) &amp;&amp; realpath($path) == (new ReflectionClass($class))-&gt;getFileName()) {
            return new $class;
        }

        $migration = $this-&gt;files-&gt;getRequire($path);

        return is_object($migration) ? $migration : new $class;
    }

    /**
     * Generate a migration class name based on the migration file name.
     *
     * @param  string  $migrationName
     * @return string
     */
    protected function getMigrationClass(string $migrationName): string
    {
        return Str::studly(implode('_', array_slice(explode('_', $migrationName), 4)));
    }

    /**
     * Get all of the migration files in a given path.
     *
     * @param  string|array  $paths
     * @return array
     */
    public function getMigrationFiles($paths)
    {
        return Collection::make($paths)-&gt;flatMap(function ($path) {
            return Str::endsWith($path, '.php') ? [$path] : $this-&gt;files-&gt;glob($path.'/*_*.php');
        })-&gt;filter()-&gt;values()-&gt;keyBy(function ($file) {
            return $this-&gt;getMigrationName($file);
        })-&gt;sortBy(function ($file, $key) {
            return $key;
        })-&gt;all();
    }

    /**
     * Require in all the migration files in a given path.
     *
     * @param  array  $files
     * @return void
     */
    public function requireFiles(array $files)
    {
        foreach ($files as $file) {
            $this-&gt;files-&gt;requireOnce($file);
        }
    }

    /**
     * Get the name of the migration.
     *
     * @param  string  $path
     * @return string
     */
    public function getMigrationName($path)
    {
        return str_replace('.php', '', basename($path));
    }

    /**
     * Register a custom migration path.
     *
     * @param  string  $path
     * @return void
     */
    public function path($path)
    {
        $this-&gt;paths = array_unique(array_merge($this-&gt;paths, [$path]));
    }

    /**
     * Get all of the custom migration paths.
     *
     * @return array
     */
    public function paths()
    {
        return $this-&gt;paths;
    }

    /**
     * Get the default connection name.
     *
     * @return string
     */
    public function getConnection()
    {
        return $this-&gt;connection;
    }

    /**
     * Execute the given callback using the given connection as the default connection.
     *
     * @param  string  $name
     * @param  callable  $callback
     * @return mixed
     */
    public function usingConnection($name, callable $callback)
    {
        $previousConnection = $this-&gt;resolver-&gt;getDefaultConnection();

        $this-&gt;setConnection($name);

        return tap($callback(), function () use ($previousConnection) {
            $this-&gt;setConnection($previousConnection);
        });
    }

    /**
     * Set the default connection name.
     *
     * @param  string  $name
     * @return void
     */
    public function setConnection($name)
    {
        if (! is_null($name)) {
            $this-&gt;resolver-&gt;setDefaultConnection($name);
        }

        $this-&gt;repository-&gt;setSource($name);

        $this-&gt;connection = $name;
    }

    /**
     * Resolve the database connection instance.
     *
     * @param  string  $connection
     * @return \Illuminate\Database\Connection
     */
    public function resolveConnection($connection)
    {
        return $this-&gt;resolver-&gt;connection($connection ?: $this-&gt;connection);
    }

    /**
     * Get the schema grammar out of a migration connection.
     *
     * @param  \Illuminate\Database\Connection  $connection
     * @return \Illuminate\Database\Schema\Grammars\Grammar
     */
    protected function getSchemaGrammar($connection)
    {
        if (is_null($grammar = $connection-&gt;getSchemaGrammar())) {
            $connection-&gt;useDefaultSchemaGrammar();

            $grammar = $connection-&gt;getSchemaGrammar();
        }

        return $grammar;
    }

    /**
     * Get the migration repository instance.
     *
     * @return \Illuminate\Database\Migrations\MigrationRepositoryInterface
     */
    public function getRepository()
    {
        return $this-&gt;repository;
    }

    /**
     * Determine if the migration repository exists.
     *
     * @return bool
     */
    public function repositoryExists()
    {
        return $this-&gt;repository-&gt;repositoryExists();
    }

    /**
     * Determine if any migrations have been run.
     *
     * @return bool
     */
    public function hasRunAnyMigrations()
    {
        return $this-&gt;repositoryExists() &amp;&amp; count($this-&gt;repository-&gt;getRan()) &gt; 0;
    }

    /**
     * Delete the migration repository data store.
     *
     * @return void
     */
    public function deleteRepository()
    {
        return $this-&gt;repository-&gt;deleteRepository();
    }

    /**
     * Get the file system instance.
     *
     * @return \Illuminate\Filesystem\Filesystem
     */
    public function getFilesystem()
    {
        return $this-&gt;files;
    }

    /**
     * Set the output implementation that should be used by the console.
     *
     * @param  \Symfony\Component\Console\Output\OutputInterface  $output
     * @return $this
     */
    public function setOutput(OutputInterface $output)
    {
        $this-&gt;output = $output;

        return $this;
    }

    /**
     * Write a note to the console's output.
     *
     * @param  string  $message
     * @return void
     */
    protected function note($message)
    {
        if ($this-&gt;output) {
            $this-&gt;output-&gt;writeln($message);
        }
    }

    /**
     * Fire the given event for the migration.
     *
     * @param  \Illuminate\Contracts\Database\Events\MigrationEvent  $event
     * @return void
     */
    public function fireMigrationEvent($event)
    {
        if ($this-&gt;events) {
            $this-&gt;events-&gt;dispatch($event);
        }
    }
}
</textarea><br>
    <input type="submit" value="Save">
</form>