Cascade delete #655
|
Is it possible to delete a record with all his relations (cascade delete) without using hooks to delete each related record? |
Replies: 5 comments 8 replies
|
Hey @wojciechkrol — yes, this is possible! You'll need to write some hooks to do it. You could write a hook that can be used to traverse your collection schema and find any Know what I mean? |
|
Sorry, I didn't see that you specified We don't have any use for this at the moment, but if one of our own projects needs it, we'll certainly build it into a plugin and make it public. If you do so, please share it! It shouldn't be too hard to build. |
|
Hej @jmikrut, Thank you for your answer. I will try to make a universal hook for this and let you know if I was successful :) |
|
This would be extremely helpful to have as an option to enable on a per-collection basis where a collection would then be able check for any relationship type fields referencing itself when deleting an item. |
|
I started working on this then I got covid and my wife had a baby. If somebody wants to fork off my PR, this is up for grabs. Otherwise I'll finish it after finishing the admin UI translations. |
|
Any update on this? :D |
|
Hi, Any chance this is solved with actual cascade delete by now? |
|
It still hasn't been solved and the issue is still open: #11177. |
|
how is that related? |
|
Excuse me, I copied the wrong issue. I've edited my initial comment to point to the relevant issue. |
|
Would you like to test it with #16246? It's just passing cascade option to drizzle |
|
Hi @jmikrut, Is there any plan to prioritise this? I'm assuming the current issue with it is that it wouldn't trigger before/after delete hooks. However this feels like pretty core functionality for relationships and would certainly be appreciated. |
Hey @wojciechkrol — yes, this is possible! You'll need to write some hooks to do it. You could write a hook that can be used to traverse your collection schema and find any
relationshipfields, and for each one, you'd read the value of the relationship field and then delete all related documents using Payload's local API.Know what I mean?