alexandrump/id-to-uuid-doctrine3

Easily migrate from auto incremented id to uuid

1.0.0 2022-09-15 11:56 UTC

Requires

• php: >=8.0
• doctrine/dbal: ^3.0.0
• doctrine/doctrine-migrations-bundle: ^3.0.0
• doctrine/orm: ^2.1.3
• ramsey/uuid-doctrine: ^1.5

Requires (Dev)

• friendsofphp/php-cs-fixer: ^2.3

MIT

• Aurélien David
• Daniel Esteve
• Alejandro Martínez

README

This library is a port of habbim/id-to-uuid package for Doctrine 3.

Easily migrate from an auto incremented integer id to a uuid in a project using DoctrineMigrationsBundle. Autodetect your foreign keys and update them. Works only on MySQL.

Installation

composer require alexandrump/id-to-uuid-doctrine3

Usage

1. Update your id column from integer to guid:

# User.orm.xml
<entity name="AppBundle\Entity\User" table="user">
---    <id name="id" column="id" type="integer">
---        <generator strategy="AUTO" />
+++    <id name="id" column="id" type="uuid_binary_ordered_time">
+++        <generator strategy="CUSTOM"/>
+++        <custom-id-generator class="Ramsey\Uuid\Doctrine\UuidGenerator"/>           
    </id>
 #...
</entity>

1. Config your symfony:

Click here

1. Add a new migration:

// app/DoctrineMigrations/VersionXYZ.php
<?php

namespace Application\Migrations;

use Doctrine\DBAL\Schema\Schema;
use Habbim\IdToUuid\IdToUuidMigration;

class VersionXYZ extends IdToUuidMigration
{
    public function postUp(Schema $schema)
    {
        $this->migrate('user');
    }
}