Description

The PR allows \craft\config\GeneralConfig::backupCommand and \craft\config\GeneralConfig::restoreCommand to be an options array to configure how the commands are generated.

Goals

• make small tweaks easy (eg ignore a single table). Currently this can only be done via event.
• make it easy to opt-in to postgres's archive format (possibly make this the default for v5?)
• make it clear when things are going to be replaced or merged (eg ignore-tables)
• provide a way to tap into command for modification
• be non-breaking

Valid values include:

<?php
use craft\config\GeneralConfig;
use mikehaertl\shellcommand\Command as ShellCommand;

return GeneralConfig::create()
    ->restoreCommand([
        'archiveFormat' => true, // pgsql-only

        // example: add an arg
        'callback' => fn(ShellCommand $command) => $command->addArg('--verbose'),
    ])
    ->backupCommand([
        'ignoreTables' => ['foo', 'bar'],
        'archiveFormat' => true, // pgsql-only

        // example: remove an arg
        'callback' => function (ShellCommand $command) {
            $command->setArgs(str_replace('--dump-date', '', $command->getArgs()));

            return $command;
        },
    ]);

etc…

• I ended up leveraging mikehaertl\shellcommand\Command because it was there and were already using it. Easier than stitching strings together.
• To keep backward compat, ignoreTables can either come from the EVENT_BEFORE_CREATE_BACKUP or from the new ignoreTables option. If both are present, the event will take precedence.
• The callback could easily be an event instead, but it seemed like it might be a pain to add an event listener just to add an additional arg.