Pimcore 6 Content Migration Script

pimcore-6-migrate-content.php

<?php

include_once __DIR__ . "/vendor/autoload.php";

\Pimcore\Bootstrap::setProjectRoot();
\Pimcore\Bootstrap::startupCli();

use Pimcore\Model\DataObject;

$search = 'O:30:"Pimcore\Model\Object\Data\Link"';
$replace = 'O:34:"Pimcore\Model\DataObject\Data\Link"';

$db = \Pimcore\Db::get();
$schema = $db->getSchemaManager();

foreach($schema->listTables() as $table) {
    if(strpos($table->getName(), 'object_') === 0) {

        // skip relation tables
        if(strpos($table->getName(), 'object_relations_') === 0) {
            continue;
        }

        foreach($table->getColumns() as $column) {
            //echo sprintf('[%s][%s]', $column->getName(), $table->getName()) . "\n";
            try {
                $sql = sprintf("SELECT %s FROM %s WHERE %s LIKE %s ESCAPE '|'",
                    $db->quoteIdentifier($column->getName()),
                    $db->quoteIdentifier($table->getName()),
                    $db->quoteIdentifier($column->getName()),
                    $db->quote('%' . $search . '%')
                );

                $result = $db->fetchOne($sql);

                if ($result) {
                    echo sprintf('Found link field [%s] in table [%s]', $column->getName(), $table->getName()) . "\n";

                    $db->query(sprintf('UPDATE %s SET %s = REPLACE(%s, ?, ?)',
                        $db->quoteIdentifier($table->getName()),
                        $db->quoteIdentifier($column->getName()),
                        $db->quoteIdentifier($column->getName())),
                    [
                        $search,
                        $replace,
                    ]);
                }
            } catch (\Exception $e) {
                echo $e->getMessage() . "\n";
            }
        }
    }
}