将Firestore查询结果保存到ArrayList中，并将每个结果添加到CSV文件中。

huangapple
go评论111阅读模式
英文:

Saving results of Firestore query to ArrayList and adding each result to CSV file

问题

Sure, here's the translation of the code portion you provided:

我想将Firestore查询文档快照的结果保存到CSV文件中，每个新结果都添加到CSV文件的新行。

我目前使用for循环来遍历结果，并为每个String赋值，然后将它们添加到CSV数据列表中。然而，我的CSV文件显示的是最后一个结果的重复，而不是查询的两个当前结果。

我的代码如下：

  1. query.get().addOnCompleteListener(new OnCompleteListener<QuerySnapshot>() {
  2.     @Override
  3.     public void onComplete(@NonNull Task<QuerySnapshot> task) {
  4.         if(task.isSuccessful()){
  5.             for (QueryDocumentSnapshot document : task.getResult()){
  7.                 //Log.d("TAG", document.getId() + " => " + document.getData());
  9.                 //CSVWRITER库用于创建CSV文件
  10.                 try {
  11.                     CSVWriter writer = new CSVWriter((new FileWriter(csv)));
  13.                     List<String[]> data = new ArrayList<String[]>();
  14.                     data.add(new String[]{"Profession", "CPD_Number", "Summary_Text", "Personal_Statement"});
  15.                     data.add(new String[]{fProfession, fCpd_Number, fSummary_Text, fPersonal_Statement});
  16.                     data.add(new String[]{"Activity_Name", "Activity_Date", "Activity_Hours", "Activity_Mins", "Activity_Type", "Activity_Description", "Activity_Ref1", "Activity_Ref2", "Activity_Ref3", "Activity_Ref4", "Image_Url"});
  18.                     for (int i = 0; i < task.getResult().size(); i++) {
  20.                         fActivity_Name = document.getString("Activity_Name");
  21.                         fActivity_Date = document.getString("Activity_Date");
  22.                         fActivity_Hours = document.getString("Activity_Hours");
  23.                         fActivity_Mins = document.getString("Activity_Mins");
  24.                         fActivity_Type = document.getString("Activity_Type");
  25.                         fActivity_Description = document.getString("Activity_Description");
  26.                         fActivity_Ref1 = document.getString("Activity_Ref1");
  27.                         fActivity_Ref2 = document.getString("Activity_Ref2");
  28.                         fActivity_Ref3 = document.getString("Activity_Ref3");
  29.                         fActivity_Ref4 = document.getString("Activity_Ref4");
  30.                         fImage_Url = document.getString("Image_URL");
  32.                         Log.d("TAG", "activity name is: " + fActivity_Name);
  33.                         data.add(new String[]{fActivity_Name, fActivity_Date, fActivity_Hours, fActivity_Mins, fActivity_Type, fActivity_Description, fActivity_Ref1, fActivity_Ref2, fActivity_Ref3, fActivity_Ref4, fImage_Url});
  35.                     }
  37.                     writer.writeAll(data);
  38.                     writer.close();
  40.                 } catch (IOException e) {
  41.                     e.printStackTrace();
  42.                 }
  43.             }
  44.         } else {
  45.             Log.d("TAG", "Error getting documents: " + task.getException());
  46.         }
  47.     }
  48. });

请问是否还有其他需要翻译的部分？

英文:

I want to save the results of my Firestore query document snapshot to a CSV file with each new result being added to a new line of the CSV file.

I am currently using a for loop to iterate over the results and assign a value to each String from the task result and then add these to the CSV data list. However, my CSV file is showing a duplicate of the last result rather than the two current results of my query.

My code looks like this

  1. query.get().addOnCompleteListener(new OnCompleteListener&lt;QuerySnapshot&gt;() {
  2.                     @Override
  3.                     public void onComplete(@NonNull Task&lt;QuerySnapshot&gt; task) {
  4.                         if(task.isSuccessful()){
  5.                             for (QueryDocumentSnapshot document : task.getResult()){
  7.                                 //Log.d(&quot;TAG&quot;, document.getId() + &quot; =&gt; &quot; + document.getData());
  9.                                 //CSVWRITER LIBRARY USED TO CREATED CSV FILE
  10.                                 try {
  11.                                     CSVWriter writer = new CSVWriter((new FileWriter(csv)));
  13.                                     List&lt;String[]&gt; data = new ArrayList&lt;String[]&gt;();
  14.                                     data.add(new String[]{&quot;Profession&quot;, &quot;CPD_Number&quot;, &quot;Summary_Text&quot;, &quot;Personal_Statement&quot;});
  15.                                     data.add(new String[]{fProfession, fCpd_Number, fSummary_Text, fPersonal_Statement});
  16.                                     data.add(new String[]{&quot;Activity_Name&quot;, &quot;Activity_Date&quot;, &quot;Activity_Hours&quot;, &quot;Activity_Mins&quot;, &quot;Activity_Type&quot;, &quot;Activity_Description&quot;, &quot;Activity_Ref1&quot;, &quot;Activity_Ref2&quot;, &quot;Activity_Ref3&quot;, &quot;Activity_Ref4&quot;, &quot;Image_Url&quot;});
  18.                                         for (int i = 0; i &lt; task.getResult().size(); i++) {
  20.                                             fActivity_Name = document.getString(&quot;Activity_Name&quot;);
  21.                                             fActivity_Date = document.getString(&quot;Activity_Date&quot;);
  22.                                             fActivity_Hours = document.getString(&quot;Activity_Hours&quot;);
  23.                                             fActivity_Mins = document.getString(&quot;Activity_Mins&quot;);
  24.                                             fActivity_Type = document.getString(&quot;Activity_Type&quot;);
  25.                                             fActivity_Description = document.getString(&quot;Activity_Description&quot;);
  26.                                             fActivity_Ref1 = document.getString(&quot;Activity_Ref1&quot;);
  27.                                             fActivity_Ref2 = document.getString(&quot;Activity_Ref2&quot;);
  28.                                             fActivity_Ref3 = document.getString(&quot;Activity_Ref3&quot;);
  29.                                             fActivity_Ref4 = document.getString(&quot;Activity_Ref4&quot;);
  30.                                             fImage_Url = document.getString(&quot;Image_URL&quot;);
  32.                                             Log.d(&quot;TAG&quot;, &quot;activity name is: &quot; + fActivity_Name);
  33.                                             data.add(new String[]{fActivity_Name, fActivity_Date, fActivity_Hours, fActivity_Mins, fActivity_Type, fActivity_Description, fActivity_Ref1, fActivity_Ref2, fActivity_Ref3, fActivity_Ref4, fImage_Url});
  35.                                         }
  37.                                     writer.writeAll(data);
  38.                                     writer.close();
  40.                                 } catch (IOException e) {
  41.                                     e.printStackTrace();
  42.                                 }
  43.                             }
  44.                         } else {
  45.                             Log.d(&quot;TAG&quot;, &quot;Error getting documents: &quot; + task.getException());
  46.                         }
  47.                     }
  48.                 });

Can anyone spot what might be going on here? Also according to my log, Log.d(&quot;TAG&quot;, &quot;activity name is: &quot; + fActivity_Name); this line prints twice and I'm not sure why it's doing this either.

Log results:

  1. 2020-07-31 15:25:35.201 6741-6741/com.example.cpd D/TAG: activity name is: hoir CHANGE AGAIN NEW
  2. 2020-07-31 15:25:35.201 6741-6741/com.example.cpd D/TAG: activity name is: hoir CHANGE AGAIN NEW
  3. 2020-07-31 15:25:35.203 6741-6741/com.example.cpd D/TAG: activity name is: other CHANGE
  4. 2020-07-31 15:25:35.204 6741-6741/com.example.cpd D/TAG: activity name is: other CHANGE

答案1

得分: 2

我终于成功解决了这个问题！解决方法如下：

  1. query.get().addOnCompleteListener(new OnCompleteListener<QuerySnapshot>() {
  2.     @Override
  3.     public void onComplete(@NonNull Task<QuerySnapshot> task) {
  4.         if(task.isSuccessful()){
  5.             // 使用CSVWRITER库创建CSV文件
  6.             try {
  7.                 CSVWriter writer = new CSVWriter(new FileWriter(csv));
  8.     
  9.                 List<String[]> data = new ArrayList<String[]>();
  10.                 data.add(new String[]{"职业", "CPD编号", "摘要文本", "个人陈述"});
  11.                 data.add(new String[]{fProfession, fCpd_Number, fSummary_Text, fPersonal_Statement});
  12.                 data.add(new String[]{"活动名称", "活动日期", "活动小时", "活动分钟", "活动类型", "活动描述", "活动引用1", "活动引用2", "活动引用3", "活动引用4", "图片URL"});
  13.     
  14.                 for (QueryDocumentSnapshot document : task.getResult()){
  15.     
  16.                     fActivity_Name = document.getString("Activity_Name");
  17.                     fActivity_Date = document.getString("Activity_Date");
  18.                     fActivity_Hours = document.getString("Activity_Hours");
  19.                     fActivity_Mins = document.getString("Activity_Mins");
  20.                     fActivity_Type = document.getString("Activity_Type");
  21.                     fActivity_Description = document.getString("Activity_Description");
  22.                     fActivity_Ref1 = document.getString("Activity_Ref1");
  23.                     fActivity_Ref2 = document.getString("Activity_Ref2");
  24.                     fActivity_Ref3 = document.getString("Activity_Ref3");
  25.                     fActivity_Ref4 = document.getString("Activity_Ref4");
  26.                     fImage_Url = document.getString("Image_URL");
  27.                     //Log.d("TAG", document.getId() + " => " + document.getData());
  28.                     data.add(new String[]{fActivity_Name, fActivity_Date, fActivity_Hours, fActivity_Mins, fActivity_Type, fActivity_Description, fActivity_Ref1, fActivity_Ref2, fActivity_Ref3, fActivity_Ref4, fImage_Url});
  29.                 }
  30.     
  31.                 writer.writeAll(data);
  32.                 writer.close();
  33.     
  34.             } catch (IOException e) {
  35.                 e.printStackTrace();
  36.             }
  37.     
  38.         } else {
  39.             //Log.d("TAG", "获取文档出错: " + task.getException());
  40.         }
  41.     }
  42. });

通过将QueryDocumentSnapshot任务结果移动到写入CSV文件的try/catch块中来完成这个操作。

英文:

I finally managed to solve this! The solution is as follows:

  1. query.get().addOnCompleteListener(new OnCompleteListener&lt;QuerySnapshot&gt;() {
  2. @Override
  3. public void onComplete(@NonNull Task&lt;QuerySnapshot&gt; task) {
  4. if(task.isSuccessful()){
  5. //CSVWRITER LIBRARY USED TO CREATED CSV FILE
  6. try {
  7. CSVWriter writer = new CSVWriter((new FileWriter(csv)));
  8. List&lt;String[]&gt; data = new ArrayList&lt;String[]&gt;();
  9. data.add(new String[]{&quot;Profession&quot;, &quot;CPD_Number&quot;, &quot;Summary_Text&quot;, &quot;Personal_Statement&quot;});
  10. data.add(new String[]{fProfession, fCpd_Number, fSummary_Text, fPersonal_Statement});
  11. data.add(new String[]{&quot;Activity_Name&quot;, &quot;Activity_Date&quot;, &quot;Activity_Hours&quot;, &quot;Activity_Mins&quot;, &quot;Activity_Type&quot;, &quot;Activity_Description&quot;, &quot;Activity_Ref1&quot;, &quot;Activity_Ref2&quot;, &quot;Activity_Ref3&quot;, &quot;Activity_Ref4&quot;, &quot;Image_Url&quot;});
  12. for (QueryDocumentSnapshot document : task.getResult()){
  13. fActivity_Name = document.getString(&quot;Activity_Name&quot;);
  14. fActivity_Date = document.getString(&quot;Activity_Date&quot;);
  15. fActivity_Hours = document.getString(&quot;Activity_Hours&quot;);
  16. fActivity_Mins = document.getString(&quot;Activity_Mins&quot;);
  17. fActivity_Type = document.getString(&quot;Activity_Type&quot;);
  18. fActivity_Description = document.getString(&quot;Activity_Description&quot;);
  19. fActivity_Ref1 = document.getString(&quot;Activity_Ref1&quot;);
  20. fActivity_Ref2 = document.getString(&quot;Activity_Ref2&quot;);
  21. fActivity_Ref3 = document.getString(&quot;Activity_Ref3&quot;);
  22. fActivity_Ref4 = document.getString(&quot;Activity_Ref4&quot;);
  23. fImage_Url = document.getString(&quot;Image_URL&quot;);
  24. //Log.d(&quot;TAG&quot;, document.getId() + &quot; =&gt; &quot; + document.getData());
  25. data.add(new String[]{fActivity_Name, fActivity_Date, fActivity_Hours, fActivity_Mins, fActivity_Type, fActivity_Description, fActivity_Ref1, fActivity_Ref2, fActivity_Ref3, fActivity_Ref4, fImage_Url});
  26. }
  27. writer.writeAll(data);
  28. writer.close();
  29. } catch (IOException e) {
  30. e.printStackTrace();
  31. }
  32. } else {
  33. //Log.d(&quot;TAG&quot;, &quot;Error getting documents: &quot; + task.getException());
  34. }
  35. }
  36. });

Did this by moving QueryDocumentSnapshot task result inside of my try/catch when writing the CSV file.

huangapple
  • 本文由 发表于 2020年7月31日 22:31:53
  • 转载请务必保留本文链接：https://go.coder-hub.com/63193833.html
  • firebase
  • google-cloud-firestore
  • java
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定