I have a database in which the user is a parent and it has some child documents child document has image data too and those images are stored in the AWS s3 bucket. I used MongoDB middleware remove to perform cascade delete. If I delete parents then the data from the child table is also deleted but the image data remains in the s3 bucket. How can I implement the logic that image data should also be deleted from the server on deleting the parent? I also wrote AWS SDK delete APIs but how can I connect them to the parent document?
// This is the parent delete API
function user_delete(req, res, next) {
User.findOne({ _id: req.params.id })
.then(user => {
if (!user) {
return next('The user you requested could not be found.')
}
Child.remove({ userId: user._id }).exec();
user.remove();
return res.status(200).send('User deleted');
}).catch(err => {
console.log(err)
if (err.kind === 'ObjectId') {
return next(res.status(404).send({
success: false,
message: "User not found with id "
}));
}
return next(res.status(500).send({
success: false,
message: "Error retrieving User with id "
}));
});
};
router.delete('/delete/:id', user_delete);
// Delete function for aws SDK delete a file from s3
function deleteFileStream(fileKey, next) {
const deleteParams = {
Key: fileKey,
Bucket: bucket_name,
}
s3.deleteObject(deleteParams, (error, data) => {
next(error, data)
})
}
exports.deleteFileStream = deleteFileStream;
// Child delete document API
function delete_child(req, res, next) {
Child.findById(req.params.id)
.then(child => {
if (!child) {
return next(res.status(404).send({
success: false,
message: "child not found with id " + req.params.id
}));
}
// deleting the images of questions also if it has image
if(question.file !== '') {
const url_parts = url.parse(question.file, true);
const datas = url_parts.pathname.split('getImage/')
const filekey = datas.pop();
console.log(filekey);
deleteFileStream(filekey); // calling the delete function
}
child.remove()
return res.send({
success: true,
message: "child successfully deleted!"
});
}).catch(err => {
if (err.kind === 'ObjectId' || err.name === 'NotFound') {
return res.status(404).send({
success: false,
message: "child not found with id " + req.params.id
});
}
return res.status(500).send({
success: false,
message: "Could not delete question with id " + req.params.id
});
});
}
router.delete('/delete/:id', delete_child);
If I call the child API the image is also deleted from the server as I am deleting it but if I delete the parent the child is deleted but not the image. Can anybody tell me, please? I am struggling with this use case.
