Update all documents within a Firestore collection

Question

Update all documents within a Firestore collection

In my firestore database, I have a collection named users. Each user has a unique ID and a corresponding score:

users 
    0e8X3VFL56rHBxxgkYOW
        score : 4
    3SeDjrgAWMmh3ranh2u
        score : 5

I am utilizing redux-firestore and I am trying to reset all the users' scores to 0. I attempted the following:

firestore.update({ collection: 'users' }, { score : 0 }

However, this did not work as the update method requires a document ID.

Do you have any suggestions on how I can achieve this?

javascript redux google-cloud-firestore

Answer 1

Answer №1

To retrieve all documents within a collection, extract their unique identifiers, and carry out updates based on these identifiers:

db.collection("cities").get().then(function(querySnapshot) {
    querySnapshot.forEach(function(doc) {
        doc.ref.update({
            capital: true
        });
    });
});

Answer 2

To retrieve all documents within a collection, extract their unique identifiers, and carry out updates based on these identifiers:

db.collection("cities").get().then(function(querySnapshot) {
    querySnapshot.forEach(function(doc) {
        doc.ref.update({
            capital: true
        });
    });
});

Answer 3

Answer №2

After encountering issues with the accepted answer provided by thehamzarocks, which failed to update any documents for me, I suspected a possible bug in AngularFire2. To work around this issue, I decided to iterate over the docs array of the QuerySnapshot and enqueue each update operation into a batch queue. This method proved to be more efficient than sending individual update requests for each document.

resetScores(): Promise<void> {
  return this.usersCollectionRef.ref.get().then(response => {
    console.log(response.docs)
    let batch = this.afs.firestore.batch();

    response.docs.forEach(userDocReference => {
      batch.update(userDocReference.ref, {'score': 0, 'leadsWithSalesWin': 0, 'leadsReported': 0});
    })
    batch.commit().catch(error => console.error(error));
  }).catch(err => console.error(err))
}

Answer 4

After encountering issues with the accepted answer provided by thehamzarocks, which failed to update any documents for me, I suspected a possible bug in AngularFire2. To work around this issue, I decided to iterate over the docs array of the QuerySnapshot and enqueue each update operation into a batch queue. This method proved to be more efficient than sending individual update requests for each document.

resetScores(): Promise<void> {
  return this.usersCollectionRef.ref.get().then(response => {
    console.log(response.docs)
    let batch = this.afs.firestore.batch();

    response.docs.forEach(userDocReference => {
      batch.update(userDocReference.ref, {'score': 0, 'leadsWithSalesWin': 0, 'leadsReported': 0});
    })
    batch.commit().catch(error => console.error(error));
  }).catch(err => console.error(err))
}

Answer 5

Answer №3

When utilizing batch updates, it's important to remember that there is a limit of 500 document updates per transaction. If this reset operation is not performed frequently, one simple approach would be:

async function resetScores() {
  const collection = await db
    .collection("users")
    .get()
  collection.forEach(doc=> {
    doc.ref
      .update({
        score: 0
      })
  })
}

Answer 6

When utilizing batch updates, it's important to remember that there is a limit of 500 document updates per transaction. If this reset operation is not performed frequently, one simple approach would be:

async function resetScores() {
  const collection = await db
    .collection("users")
    .get()
  collection.forEach(doc=> {
    doc.ref
      .update({
        score: 0
      })
  })
}

Answer 7

Answer №4

While exploring for solutions, I stumbled upon this post. Firestore has introduced batched writes now, allowing updates to multiple documents in a single operation. This feature can be beneficial when dealing with a smaller number of documents.

Expanding on @thehamzarocks's response:

A new batch is created using const batch = db.batch()

db.collection('cities').get().then(function(querySnapshot) {
    querySnapshot.forEach(function(doc) {
        const docRef = db.collection('cities').doc(doc.id)
        batch.update(docRef, { capital: true })
    });

    The changes are then committed by calling batch.commit();
});

Answer 8

While exploring for solutions, I stumbled upon this post. Firestore has introduced batched writes now, allowing updates to multiple documents in a single operation. This feature can be beneficial when dealing with a smaller number of documents.

Expanding on @thehamzarocks's response:

A new batch is created using const batch = db.batch()

db.collection('cities').get().then(function(querySnapshot) {
    querySnapshot.forEach(function(doc) {
        const docRef = db.collection('cities').doc(doc.id)
        batch.update(docRef, { capital: true })
    });

    The changes are then committed by calling batch.commit();
});

Answer 9

Answer №5

Unfortunately, Firestore lacks the capability to perform bulk updates on documents without specifying their IDs. In order to update multiple documents, you will need to have prior knowledge of each document's ID and update them individually either by querying for them or batching queries.

Answer 10

Unfortunately, Firestore lacks the capability to perform bulk updates on documents without specifying their IDs. In order to update multiple documents, you will need to have prior knowledge of each document's ID and update them individually either by querying for them or batching queries.

Update all documents within a Firestore collection

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

Include a variety of links in an unordered list, with only the initial link triggering a click event

Data-bind knockout select knockout bind data

Analyze the information presented in an HTML table and determine the correct response in a Q&A quiz application

Next.js API route is showing an error stating that the body exceeds the 1mb limit

Error Message: Error Code 2. I am encountering an issue with the bot expecting either undefined or null and receiving a string primitive instead. Any

An error occurred: Unable to access the 'indexOf' property of an undefined variable within the angularjs framework

Identifying Touch Interaction exclusively on WebGL Canvas within threejs

Grab and drop into place

Manipulating properties with JavaScript within a PHP environment

Issue with passing Redux store to the component props

What is the best way to eliminate the default hover effect using the MenuItem Mui class?

Awesome method of redirecting outdated URLs to the most recent established URL

The access-control-allow-origin header is failing to receive updates

Toggle element visibility upon clicking

Retrieve a result from a setTimeout function

SyntaxError: Identifier was not expected

Is it commonplace for redux to generate an abundance of storage?

Easy Steps to Simplify Your Code for Variable Management

Display the list of cities associated with the country chosen in the form

When using Facebook Graph API version 2.2 in conjunction with passport.js, the profile picture may not be returned