MongoDB DBRef ON DELETE CASCADE

Question

Is there a way in MongoDB to have a foreign key with a 'ON DELETE CASCADE' functionality?

I know you can use DBRef as a sort of foreign key but when the item in a collection where the reference points to is removed, the reference returns null. But i want that the item where the reference belongs to gets removed. How do i do this?

Or do i need every time i remove things check references to it?

finally, have you implemented CASCADE DELETE for MongoDB? – János May 21 '15 at 15:11 — János, May 21 '15 at 15:11

score 9 · Accepted Answer · answered Jun 25 '10 at 07:04

9

This feature doesn't exist now. If you want it. Add it on MongoDB Bugtracker

http://jira.mongodb.org

answered Jun 25 '10 at 07:04

shingara

46,608
11
99
105

I posted a feature request on jira, thnx for the tip ;) – VDVLeon Jun 25 '10 at 12:04
yeah, srry, i forgot because i had to leave my pc at that moment :P – VDVLeon Jun 25 '10 at 14:20
Can you provide a link to this issue? – fracz Mar 19 '16 at 14:50
https://jira.mongodb.org/browse/SERVER-1298 – sezanzeb Jun 02 '23 at 11:22
The feature request was rejected in 2015, before transactions were possible. I created a new feature request: https://feedback.mongodb.com/forums/924280-database/suggestions/46728697-cascading-delete-for-dbrefs – sezanzeb Jun 02 '23 at 11:41

score 0 · Answer 2 · answered Feb 17 '22 at 07:28

There is no builtin DELETE CASCADE but you can write your own login. Here is mine

Category.post('findOneAndDelete', async document => {
  if (document) await Stock.findOneAndDelete({ categoryId: document._id });
});

Details: I have to remove stock item if category will delete. So I use post middleware on Category delete and in that middleware i find the Stock Item which have that category and remove that too.

MongoDB DBRef ON DELETE CASCADE

2 Answers2

Linked