时间戳

首页 > 解决方案 > 我的 firebase 云函数不执行插入表格行的嵌套 foreach 中的代码

javascript - 我的 firebase 云函数不执行插入表格行的嵌套 foreach 中的代码

问题描述

“索引”表已创建并包含其所有数据，标题为“产品代码”的表已创建但完全空白。内部 foreach 循环内的控制台日志函数会在每次迭代时打印数据，但 insertRow 函数不会用数据填充工作表。有人可以告诉我我做错了什么。

index.js

const functions = require('firebase-functions');

const admin = require('firebase-admin');
admin.initializeApp(functions.config().firebase);

const fs = require('fs-extra')
const gcs = require('@google-cloud/storage')();

const path = require('path');
const os = require('os');

const ExcelJS = require('exceljs');



exports.createCSV = functions.firestore
  .document('reports/{reportId}')
  .onCreate(async (snap, context) => {

    // Step 1. Set main variables
    console.log("Began");
    const reportId = context.params.reportId;
    const fileName = `reports/${reportId}.xlsx`;
    console.log(fileName);
    const tempFilePath = path.join(os.tmpdir(), fileName);

    // Reference report in Firestore
    const db = admin.firestore();
    const reportRef = db.collection('reports').doc(reportId);

    // Reference Storage Bucket
    const storage = gcs.bucket('gs://stock-check-48f78.appspot.com');
    const workbook = new ExcelJS.Workbook();

    // Step 2. Query collection
    try {
      const querySnapshot = await db.collection('stores')
        .get();
      // create array of order data
      const indexWorksheet = workbook.addWorksheet("INDEX");

      querySnapshot.forEach(async doc => {
        //stores.push(doc.data());
        const rowValues = [];
        rowValues[1] = doc.data().code.toString();
        rowValues[2] = doc.data().name;
        rowValues[3] = doc.data().address;
        indexWorksheet.addRow(rowValues);
        const worksheet = workbook.addWorksheet(doc.data().code.toString());
        const storeId = doc.id;
        console.log("Store id is: " + storeId);

        const querySnap = await db.collection('stores').doc(storeId).collection('products').get();

        querySnap.forEach(async a => {
          //console.log(a.data());
          const productValues = [];
          productValues[1] = a.data().name;
          productValues[2] = a.data().packaging;
          productValues[3] = a.data().category;
          productValues[4] = a.data().stock.toString();
          productValues[5] = a.data().order.toString();
          productValues[6] = a.data().last_updated;
          worksheet.insertRow(1, productValues);

        });
      });

      // Step 4. Write the file to cloud function tmp storage
      console.log("Filename is: ");
      console.log(fileName);
      console.log(tempFilePath);
      const buffer = await workbook.xlsx.writeBuffer();
      await fs.outputFile(tempFilePath, buffer);
      console.log("Uploaded");

      // Step 5. Upload the file to Firebase cloud storage
      const file = await storage.upload(tempFilePath, {
        destination: fileName
      });
      console.log("Uploaded to bucket");

      return reportRef.update({
        status: 'complete'
      });

    } catch (err) {
      return console.log(err);
    }

  })

更新 我做了这些改变，仍然得到相同的结果......（见上面的编辑代码）

标签： javascriptgoogle-cloud-firestoregoogle-cloud-functionsexceljs

解决方案

尝试使用 promise.all

await Promise.all(querySnap.map(async a => {
      //console.log(a.data());
      const productValues = [];
      productValues[1] = a.data().name;
      productValues[2] = a.data().packaging;
      productValues[3] = a.data().category;
      productValues[4] = a.data().stock.toString();
      productValues[5] = a.data().order.toString();
      productValues[6] = a.data().last_updated;
      worksheet.insertRow(1, productValues);

    }));

推荐阅读