PostrgreSQL 15 with Symfony 6.4 ID generation deprecation - SEQUENCE for Doctrine\DBAL\Platforms\PostgreSqlPlatform about doctrinebundle HOT 4 CLOSED

@Mepcuk Are your sure? I'm experiencing the same issue and based on the code in the ClassMetadataFactory on line 750 (src) it always throws an deprecation.

This is also what I experience when trying different values. And as far as I can see this library doesn't support the setIdentityGenerationPreferences method yet.

As a side remark, one thing I found is that this deprecation only happens when an association mapping is part of the entity.

from doctrinebundle.

Found solution -> in your Entity's id field need to specify strategy 'SEQUENCE'

#[ORM\Entity(repositoryClass: WebpageRepository::class)]
#[ORM\Table(name: '`webpage`')]
class Webpage
{
    #[ORM\Id]
    #[ORM\GeneratedValue(strategy: 'SEQUENCE')]
    #[ORM\Column]
    private ?int $id = null;
....

from doctrinebundle.

Solved - more in docs https://www.doctrine-project.org/projects/doctrine-orm/en/2.9/reference/basic-mapping.html#identifier-generation-strategies

from doctrinebundle.

I'm with @DannyvdSluijs, this bundle can't set the setIdentityGenerationPreferences and entities generated by Symfony Maker don't use any default strategies. To fix it you can override the default config using compiler pass in the src\Kernel.php

<?php

namespace App;

use Doctrine\DBAL\Platforms\PostgreSQLPlatform;
use Doctrine\ORM\Mapping\ClassMetadata;
use Symfony\Bundle\FrameworkBundle\Kernel\MicroKernelTrait;
use Symfony\Component\DependencyInjection\{Compiler\CompilerPassInterface, ContainerBuilder};
use Symfony\Component\HttpKernel\Kernel as BaseKernel;

class Kernel extends BaseKernel implements CompilerPassInterface
{
    use MicroKernelTrait;

    public function process(ContainerBuilder $container): void
    {
        $container
            ->getDefinition("doctrine.orm.configuration")
            ->addMethodCall("setIdentityGenerationPreferences", [[PostgreSQLPlatform::class => ClassMetadata::GENERATOR_TYPE_SEQUENCE]]);
    }
}

from doctrinebundle.