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?

Answer 1

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.