How to override database connection grammar for artisan?

[ProteanCode]

Hi there

Using Laravel 8 I can use following code:

class AppServiceProvider extends ServiceProvider
{
    public function register()
    {
        Connection::resolverFor('pgsql', function ($connection, $database, $prefix, $config) {
            return new PostgresConnection($connection, $database, $prefix, $config);
        });
    }

    // ...
}

to override some of the query builder behaviour, but this does not work for commands like php artisan migrate:refresh --seed

I do not know why it happens, I think that MigrationServiceProvider messes up something

Still cannot use custom query grammar during migration :(

[ProteanCode]

Got it working by creating something more advanced

class EncryptedMigration extends \Illuminate\Database\Migrations\Migration
{
    public function __construct()
    {
        Connection::resolverFor('pgsql', function ($connection, $database, $prefix, $config) {
            return new PostgresConnection($connection, $database, $prefix, $config);
        });
        app('db')->purge();
    }

    /**
     * Get the migration connection name.
     *
     * @return string|null
     */
    public function getConnection()
    {
        return $this->connection;
    }
}

The key is to call

app('db')->purge();

after setting the resolver for connection