On delete cascade with doctrine2

by

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.

More Related Contents:

  1. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  2. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  3. How to set up entity (doctrine) for database view in Symfony 2
  4. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  5. How to setup table prefix in symfony2
  6. Symfony 2.0 getting service inside entity
  7. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  8. How to force Doctrine to update array type fields?
  9. Query on a many-to-many relationship using Doctrine with Symfony2
  10. How can I use DATE() in Doctrine 2 DQL?
  11. How to get the value from and save to Database in php
  12. How to get current route in Symfony 2?
  13. Disable deprecated warning in Symfony 2(.7)
  14. Get service via class name from iterable – injected tagged services
  15. Symfony2 and date_default_timezone_get() – It is not safe to rely on the system’s timezone settings
  16. How to set default value for form field in Symfony2?
  17. Select entries between dates in doctrine 2
  18. Subquery in doctrine2 notIN Function
  19. Generating a single Entity from existing database using symfony2 and doctrine
  20. Running Composer returns: “Could not open input file: composer.phar”
  21. How to disable redirection after login_check in Symfony 2
  22. How to use a findBy method with comparative criteria
  23. Symfony 2 – how to pass data to formBuilder?
  24. How to inject a repository into a service in Symfony?
  25. Token was deauthenticated after trying to refresh it
  26. Why does PHP 7.4 on Windows aborts all command line actions that require user input?
  27. Set value of single object in multidimensional array in twig template
  28. Doctrine2 association mapping with conditions
  29. Extending Sonata User Bundle and adding new fields [closed]
  30. How to give container as argument to services

Leave a Comment