doctrine – Make Me Engineer

Doctrine 2 OneToMany Cascade SET NULL

June 9, 2023 by Tarik

You should add the option onDelete=”SET NULL” in the annotation of your entity Publication like this: class Publication { /** * @ORM\ManyToOne(targetEntity=”Teacher”, inversedBy=”publications”) * @ORM\JoinColumn(name=”teacher_id”, referencedColumnName=”id”, onDelete=”SET NULL”) */ protected $teacher; } This modification is registered in the table declaration itself. Hence, you need a database migration or a schema change for this to take … Read more

Explicitly set Id with Doctrine when using “AUTO” strategy

May 21, 2023 by Tarik

Although your solution work fine with MySQL, I failed to make it work with PostgreSQL as It’s sequence based. I’ve to add this line to make it work perfectly : $metadata->setIdGenerator(new \Doctrine\ORM\Id\AssignedGenerator());