RobinDev
commented
8 months ago About BC Break, i am not sure, because it's required to update from unserialized to json encoded.
I run a migration on a current project using sonataUserBundle, should I add it to this PR ?
<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
final class Version1709056840 extends AbstractMigration
{
public function up(Schema $schema): void
{
$rows = $this->connection->fetchAllAssociative('SELECT id,roles FROM user');
/** @var array{'id': scalar, 'roles': string}[] $rows */
foreach ($rows as $row) {
$id = $row['id'];
$roles = json_encode(unserialize($row['roles']));
$this->connection->executeQuery('UPDATE user SET roles = :roles WHERE id = :id', ['roles' => $roles, 'id' => $id]);
}
}
}
VincentLanglet
core23
rande
Hanmac
Compatibility with doctrine dbal 4
Just switching the deprecated array type to json - cf Upgrade Guide
I am targeting this branch, because it's a patch wich is not introducing bc break.
About BC Break, i am not sure, because it's required to update from unserialized to json encoded.
Changelog