How to delete entities that have relationships?

Question

symfony

The user needs to be deleted.

Wrote this code

$notification = $user->getNotificationSettings();
                            $em->remove($notification);

                            $groups = $user->getGroups();
                            foreach ($groups as $value) {
                                $em->remove($value);
                            }

                            $myShops = $user->getMyShops();
                            foreach ($myShops as $value) {
                                $em->remove($value);
                            }

                            $referrals = $user->getReferrals();
                            foreach ($referrals as $value) {
                                $em->remove($value);
                            }

                            $em->remove($user);
                            $em->flush();

I believe that I delete because I get an error

How to delete relations correctly?

Answer 1

If you want to delete links, use cascade delete (or SET NULL). Something like this:

//* @Entity */
class Group
{
    /**
     * @ManyToMany(targetEntity="User")
     * @JoinTable(
     *     joinColumns={@JoinColumn(onDelete="CASCADE")},
     *     inverseJoinColumns={@JoinColumn(onDelete="CASCADE")}
     * )
     */
    private $users;
}

https://www.doctrine-project.org/projects/doctrine...