Example of using the benmorel/smartdump PHP API instead of the CLI

dump.php

<?php

/**
 * Example valid with benmorel/smartdump~0.2.0
 *
 * https://github.com/BenMorel/smartdump
 */

use BenMorel\SmartDump\Configuration\DumpConfiguration;
use BenMorel\SmartDump\Configuration\TargetTable;
use BenMorel\SmartDump\Driver\MySQLDriver;
use BenMorel\SmartDump\Dumper;
use BenMorel\SmartDump\Object\Table;

require __DIR__ . '/vendor/autoload.php';

$pdo = new PDO('mysql:host=localhost;charset=utf8mb4', 'root', '');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$driver = new MySQLDriver($pdo);
$dumper = new Dumper($pdo, $driver);

$configuration = new DumpConfiguration();

$configuration->targetTables = [];
$configuration->targetTables[] = createTargetTable('mydb', 'table1');
$configuration->targetTables[] = createTargetTable('mydb', 'table2', 'LIMIT 100');

$configuration->addDropTable = false;
$configuration->addCreateTable = true;
$configuration->includeSchemaNameInOutput = true;
$configuration->merge = false;

foreach ($dumper->dump($configuration) as $statement) {
    echo $statement, PHP_EOL;
}

function createTargetTable(string $database, string $table, ?string $conditions = null): TargetTable
{
    $targetTable = new TargetTable();

    $targetTable->table      = new Table($database, $table);
    $targetTable->conditions = $conditions;

    return $targetTable;
}