..-. .- -.. .. .-.. fadilxcoder

What's the difference between cascade="remove" and orphanRemoval=true in Doctrine 2

TLDR: The cascade={"remove"} is like a "software" onDelete="CASCADE", and will remove objects from the database only when an explicit call to $em->remove() occurs. Thus, it could result in more than one object being deleted. orphanRemoval can remove objects from the database even if there was no explicit call to ->remove().

I answered this question a few times to different people so I will try to sum things up in this Gist.

Let's take two entities A and B as an example. I will use a OneToOne relationship in this example but it works exactly the same with OneToMany relationships.

class A

People

`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`
😚 `:kissing_closed_eyes:`	😳 `:flushed:`	😌 `:relieved:`
😆 `:satisfied:`	😁 `:grin:`	😉 `:wink:`
😜 `:stuck_out_tongue_winking_eye:`	😝 `:stuck_out_tongue_closed_eyes:`	😀 `:grinning:`
😗 `:kissing:`	😙 `:kissing_smiling_eyes:`	😛 `:stuck_out_tongue:`

	Facture
	- id
	- user_id
	- client_id
	- date
	- total

	FactureItems
	- id
	- facture_id

	RUN apt update
	RUN apt upgrade -y
	RUN apt install -y apt-utils
	RUN a2enmod rewrite
	RUN apt install -y libmcrypt-dev
	RUN docker-php-ext-install mcrypt
	RUN apt install -y libicu-dev
	RUN docker-php-ext-install -j$(nproc) intl
	RUN apt-get install -y libfreetype6-dev libjpeg62-turbo-dev libpng12-dev
	RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/