How to cascade delete document in mongodb?

Question

I have user and photo documents in Mongodb. Each photo belongs to user and a photo maybe shared among users. Lets say user1 has p1,p2,p3 photos and user2 has p3,p4,p5 photos. If I delete user1 (manually using tools like Compass), p1 and p2 should also be deleted but not p3. How to achieve this and what kind of database structure I need to define?

Currently if I delete user1, no photos are deleted and remain in databse which now makes the database corrupted from the point of view of the application using the database.

Its Spring Boot app and User and Photo are declared as:

import lombok.Builder;
import lombok.Data;
import org.springframework.data.annotation.Id;
import org.springframework.data.mongodb.core.mapping.DBRef;
import org.springframework.data.mongodb.core.mapping.Document;
@Document
@Data
@Builder
public class User {

    @Id
    private String id;


    @DBRef
    private Set<Photo> photos;


    private String name;
}

@Document
@Data
@Builder
public class Photo {

    @Id
    private String id;


    private String fileName;

}

You have to do it [manually](https://stackoverflow.com/questions/14280189/mongodb-alternatives-for-foreign-key-constraints) there is no support for it. Similar answer is [here](https://stackoverflow.com/questions/20370791/what-is-the-recommended-equivalent-of-cascaded-delete-in-mongodb-for-nm-relatio) — m4gic, Sep 09 '18 at 19:38

Mindcraft · Accepted Answer · 2018-09-16T23:04:12.897

13

As mentioned by m4gic and in the questions he linked (here and here), MongoDB doesn't support cascading deletes. In your situation you should probably create an array in the User object, and put the complete child documents into that array instead of keeping them in their own collection. That way they will be deleted together with the parent, because they are a part of it.

edited Sep 16 '18 at 23:04

answered Sep 11 '18 at 00:04

Mindcraft

457
3
8

2

keep in mind that the maximum BSON document size is 16 megabytes – khocef Feb 06 '21 at 16:36

score 3 · Answer 2 · answered Sep 11 '18 at 05:29

MongoDB doesn't support for cascade delete as of now. As you are already storing the ref photos in the User model, you can get the photo ids from the reference list and delete the photos together. Or instead of storing the photos in the separate collection you can have the array of Photos embedded into the user object.

You can refer to this link as well: What is the recommended equivalent of cascaded delete in MongoDB for N:M relationships?

score 0 · Answer 3 · answered Mar 02 '22 at 09:52

@mindcraft is right, but if you wanted to keep photos in separate collection then you can add access property to the photo document like

{
  ref: 'https://....',
  access:[user1._id, user2._id]
}

You can then query like -

db.photos.find({access:{$in:[user1._id]}})

Although separate collection specifically for photos will not help a lot. Instead try putting photo urls in array

How to cascade delete document in mongodb?

3 Answers3

Linked