Currently, I am in the process of developing a forum application using Vue, which is essentially a replica of this platform. In this app, users can post questions, receive answers to those questions, and leave comments on those answers. Each question, answer, and comment has a corresponding document in a top-level collection, with a field called photoURL where the profile image URL of the author is stored.
I have implemented code to update the photoURL field in each document belonging to the same author across all three collections when that user updates their profile picture:
const QUESTIONS = db.collection("questions");
QUESTIONS.where("authorId", "==", this.user.data.id)
.get()
.then(snapshots => {
if (snapshots.size > 0) {
snapshots.forEach(questionItem => {
QUESTIONS.doc(questionItem.id).update({
photoURL: imgUrl
});
});
}
});
const ANSWERS = db.collection("answers");
ANSWERS.where("authorId", "==", this.user.data.id)
.get()
.then(snapshots => {
if (snapshots.size > 0) {
snapshots.forEach(answerItem => {
ANSWERS.doc(answerItem.id).update({
photoURL: imgUrl
});
});
}
});
const COMMENTS = db.collection("comments");
COMMENTS.where("authorId", "==", this.user.data.id)
.get()
.then(snapshots => {
if (snapshots.size > 0) {
snapshots.forEach(commentItem => {
COMMENTS.doc(commentItem.id).update({
photoURL: imgUrl
});
});
}
});
The current implementation is functional, but I am exploring more efficient ways to execute these operations simultaneously or discover an improved method for handling these updates. One thought was to first store all retrieved IDs from the three collections in an array and then perform the updates, but it seems that the number of write operations would remain constant, thus not providing a significant enhancement.