What is the process for transferring an existing collection or data in Firestore to a subcollection?

Question

What is the process for transferring an existing collection or data in Firestore to a subcollection?

My firestore database currently has the following structure with documents:

root
|
|---transactions/...

I am looking to transfer all transactions to a new subcollection as shown below:

root
|
|---users/user/transactions/...

Any suggestions on how I can achieve this?

javascript angular typescript firebase google-cloud-firestore

Answer 1

Answer №1

After experimenting with different methods (outlined below), I found a solution that worked for me:

1. Transfer data using a custom function utilizing the @angular/fire SDK:

// firebase.service.ts
import { Injectable } from '@angular/core';
import { AngularFirestore } from '@angular/fire/firestore';
import { first, map } from 'rxjs/operators';

@Injectable({
  providedIn: 'root',
})
export class FirebaseService {
  fromCollection = '<name-of-collection>';
  toCollection = '<other-root-level-collection>/<document-id>/<subcollection>';
  constructor(private firestore: AngularFirestore) {}

  migrateTransactions() {
    this.getAllDocuments<YourType>(this.fromCollection).subscribe((documents) => {
      documents.forEach(async (document) => {
        await this.createDocument(this.toCollection, document);
      });
    });
  }

  getAllDocuments<T>(path: string) {
    return this.firestore
      .collection(path)
      .get()
      .pipe(
        first(),
        map((collection) => collection.docs.map((doc) => doc.data() as T))
      );
  }

  createDocument(path: string, document: unknown) {
    return this.firestore.collection(path).add(document);
  }
}

Note: This method only ADDS all documents from the original collection to the specified collection - it does NOT delete the original documents or overwrite existing ones, ensuring safety. You can subsequently remove the original collection in the Firebase console.

Keep in mind you can concatenate nested collections and documents when passing them as arguments to

AngularFirestore.collection(path)

(as demonstrated in the property toCollection). This simplifies navigation through nested collections. Other SDKs may not support this feature.

2. Utilize firestore-migrator by Jeff Delaney:

This approach did not work for me due to issues with converting firebase's timestamps. However, if your schema does not contain complex data types, it might be suitable. The library itself is useful and can be adjusted locally with some tinkering.

3. Use the Cloud Firestore managed export and import service:

This is ideal for complete backups of either the entire database or a root level collection. It may not meet every requirement, so evaluate if it aligns with your needs.

Answer 2

After experimenting with different methods (outlined below), I found a solution that worked for me:

1. Transfer data using a custom function utilizing the @angular/fire SDK:

// firebase.service.ts
import { Injectable } from '@angular/core';
import { AngularFirestore } from '@angular/fire/firestore';
import { first, map } from 'rxjs/operators';

@Injectable({
  providedIn: 'root',
})
export class FirebaseService {
  fromCollection = '<name-of-collection>';
  toCollection = '<other-root-level-collection>/<document-id>/<subcollection>';
  constructor(private firestore: AngularFirestore) {}

  migrateTransactions() {
    this.getAllDocuments<YourType>(this.fromCollection).subscribe((documents) => {
      documents.forEach(async (document) => {
        await this.createDocument(this.toCollection, document);
      });
    });
  }

  getAllDocuments<T>(path: string) {
    return this.firestore
      .collection(path)
      .get()
      .pipe(
        first(),
        map((collection) => collection.docs.map((doc) => doc.data() as T))
      );
  }

  createDocument(path: string, document: unknown) {
    return this.firestore.collection(path).add(document);
  }
}

Note: This method only ADDS all documents from the original collection to the specified collection - it does NOT delete the original documents or overwrite existing ones, ensuring safety. You can subsequently remove the original collection in the Firebase console.

Keep in mind you can concatenate nested collections and documents when passing them as arguments to

AngularFirestore.collection(path)

(as demonstrated in the property toCollection). This simplifies navigation through nested collections. Other SDKs may not support this feature.

2. Utilize firestore-migrator by Jeff Delaney:

This approach did not work for me due to issues with converting firebase's timestamps. However, if your schema does not contain complex data types, it might be suitable. The library itself is useful and can be adjusted locally with some tinkering.

3. Use the Cloud Firestore managed export and import service:

This is ideal for complete backups of either the entire database or a root level collection. It may not meet every requirement, so evaluate if it aligns with your needs.

What is the process for transferring an existing collection or data in Firestore to a subcollection?

Answer №1

Similar questions

Can two writable stores in Svelte be set up to subscribe to each other simultaneously?

Encountering Problem with Jmeter Script Playback - Kindly Activate JavaScript to Access Page Information

What are the best practices for running node in VSCode?

Identifying modifications within the @Input property in Angular 4

What is the process for uploading a single file and an array of files with varying names using multer?

Transmitting multiple parameters, including a file, from Angular to Spring framework

Implementing Axios interceptor is a common practice in Vue.js applications to central

What is the best approach for developing an npm package containing multiple Vue directives? Should each directive have its own separate package, or should they

Two separate menus for each root file in Ionic 2

Receiving an error stating "module not found" when attempting to retrieve the NextAuth session using EmailProvider in getServerSideProps

"Trying to refresh your chart.js chart with updated data?”

Having trouble getting Vue.js hello world to display on the page

Is there a way to dynamically change the helperText of a Material UI TextField using its current value through code?

Troubleshooting the integration of Text Mask Library with Vue - issue: no export named 'default' available

Unable to send POST request (including data) using event trigger from an external component

Exploring the significance of a super in Object-Oriented Programming within JavaScript

Looking for a way to locate any elements in jQuery that do not contain a certain CSS class?

"Encountering difficulties while setting up an Angular project

Displaying Material UI Styles: A Challenge

Enhance the <div> with interactive content through dynamic updates on click within the same element