On delete cascade with doctrine2

Question

I m trying to make a simple example in order to learn how to delete a row from a parent table and automatically delete the matching rows in the child table using Doctrine2   Here are the two entities I m using   Child php    lt  php  namespace Acme CascadeBundle Entity   use Doctrine ORM Mapping as ORM           ORM Entity     ORM Table name  child       class Child                    ORM Id         ORM Column type  integer           ORM GeneratedValue strategy  AUTO               private  id                  ORM ManyToOne targetEntity  Father   cascade   remove                   ORM JoinColumns             ORM JoinColumn name  father id   referencedColumnName  id                            var father             private  father      Father php   lt  php namespace Acme CascadeBundle Entity   use Doctrine ORM Mapping as ORM           ORM Entity     ORM Table name  father       class Father                   ORM Id         ORM Column type  integer           ORM GeneratedValue strategy  AUTO               private  id      The tables are correctly created on the database  but the On Delete Cascade option it s not created  What am I doing wrong

User · Accepted Answer

There are two kinds of cascades in Doctrine:

1) ORM level - uses cascade={"remove"} in the association - this is a calculation that is done in the UnitOfWork and does not affect the database structure. When you remove an object, the UnitOfWork will iterate over all objects in the association and remove them.

2) Database level - uses onDelete="CASCADE" on the association's joinColumn - this will add On Delete Cascade to the foreign key column in the database:

@ORM\JoinColumn(name="father_id", referencedColumnName="id", onDelete="CASCADE")

I also want to point out that the way you have your cascade={"remove"} right now, if you delete a Child object, this cascade will remove the Parent object. Clearly not what you want.

User · Answer

Here is simple example  A contact has one to many associated phone numbers  When a contact is deleted  I want all its associated phone numbers to also be deleted  so I use ON DELETE CASCADE  The one-to-many many-to-one relationship is implemented with by the foreign key in the phone numbers    CREATE TABLE contacts   contact id BIGINT AUTO INCREMENT NOT NULL   name VARCHAR 75  NOT NULL   PRIMARY KEY contact id   ENGINE   InnoDB   CREATE TABLE phone numbers   phone id BIGINT AUTO INCREMENT NOT NULL    phone number CHAR 10  NOT NULL   contact id BIGINT NOT NULL   PRIMARY KEY phone id    UNIQUE phone number   ENGINE   InnoDB   ALTER TABLE phone numbers ADD FOREIGN KEY  contact id  REFERENCES   contacts contact id    ON DELETE CASCADE    By adding  ON DELETE CASCADE  to the foreign key constraint  phone numbers will automatically be deleted when their associated contact is deleted   INSERT INTO table contacts name  VALUES  Robert Smith    INSERT INTO table phone numbers phone number  contact id  VALUES  8963333333   1   INSERT INTO table phone numbers phone number  contact id  VALUES  8964444444   1     Now when a row in the contacts table is deleted  all its associated phone numbers rows will automatically be deleted   DELETE TABLE contacts as c WHERE c id 1     delete cascades to phone numbers      To achieve the same thing in Doctrine  to get the same DB-level  ON DELETE CASCADE  behavoir  you configure the  JoinColumn with the onDelete  CASCADE  option     lt  php namespace Entities   use Doctrine Common Collections ArrayCollection           Entity     Table name  contacts       class Contact                      Id          Column type  integer   name  contact id             GeneratedValue             protected  id                      Column type  string   length  75   unique  true                 protected  name                     OneToMany targetEntity  Phonenumber   mappedBy  contact                protected  phonenumbers        public function   construct  name null                 this- gt phonenumbers   new ArrayCollection             if   is null  name                   this- gt name    name                       public function getId                 return  this- gt id             public function setName  name                 this- gt name    name             public function addPhonenumber Phonenumber  p                if    this- gt phonenumbers- gt contains  p                   this- gt phonenumbers      p               p- gt setContact  this                        public function removePhonenumber Phonenumber  p                 this- gt phonenumbers- gt remove  p             lt  php namespace Entities           Entity     Table name  phonenumbers       class Phonenumber                    Id        Column type  integer   name  phone id           GeneratedValue            protected  id                    Column type  string   length  10   unique  true                  protected  number                    ManyToOne targetEntity  Contact   inversedBy  phonenumbers           JoinColumn name  contact id   referencedColumnName  contact id   onDelete  CASCADE                protected  contact        public function   construct  number null                if   is null  number                   this- gt number    number                       public function setPhonenumber  number                 this- gt number    number             public function setContact Contact  c                 this- gt contact    c             gt    lt  php   em    Doctrine ORM EntityManager  create  connectionOptions   config     contact   new Contact  John Doe       phone1   new Phonenumber  8173333333     phone2   new Phonenumber  8174444444     em- gt persist  phone1    em- gt persist  phone2    contact- gt addPhonenumber  phone1     contact- gt addPhonenumber  phone2      em- gt persist  contact   try         em- gt flush      catch Exception  e          m    e- gt getMessage        echo  m     lt br   gt  n       If you now do     doctrine orm schema-tool create --dump-sql   you will see that the same SQL will be generated as in the first  raw-SQL example

[php] On delete cascade with doctrine2

Examples related to php

Examples related to doctrine-orm

Examples related to symfony

Examples related to cascading-deletes