Deleting a document and its referenced documents in mongoose v7.2.2

Asked Jun 04 '23 at 05:35

Active Jun 04 '23 at 14:22

Viewed 34 times

I have a User model and Post, Comment model where Post.author and Comment.author reference User._id...

How can I add a middleware to delete all posts and comments when a user is deleted...

I have seen other questions on stackoverflow with answers involving schema.pre("remove"..., but now .remove() has been deprecated...

My desired implementation:

UserSchema = new mongoose.Schema({
...
})

PostSchema = new mongoose.Schema({
    author: String // User._id
...
})

CommentSchema = new mongoose.Schema({
    author: String // User._id
    post: String // Post._id
...
})

UserSchema.post("findOneAndDelete", async (doc) => {
    await Post.deleteMany({ author: doc._id });
    await Comment.deleteMany({ author: doc._id });
})

PostSchema.post("deleteMany", async (doc) => {
    await Comment.deleteMany({ post: doc._id })
})

How can I achieve this in mongoose v7.2.2?

edited Jun 04 '23 at 14:22

asked Jun 04 '23 at 05:35

RandomCoder59

Can you check this answer? https://stackoverflow.com/a/59215422/11717458 – SuleymanSah Jun 04 '23 at 09:40
Your solution works for `findByIdAndDelete` and `findOneAndDelete` but not `deleteMany`. – RandomCoder59 Jun 04 '23 at 11:27
but you need to delete a user, where do you need deleteMany? – SuleymanSah Jun 04 '23 at 13:23
When I delete a user, the the middleware should delete all the referenced posts... and each post deletes all its referenced comments... – RandomCoder59 Jun 04 '23 at 13:30
My answer does exactly the same, it uses deleteMany – SuleymanSah Jun 04 '23 at 13:38
I have edited my questoin to better explain it... – RandomCoder59 Jun 04 '23 at 14:22

Deleting a document and its referenced documents in mongoose v7.2.2

0 Answers0