-
Notifications
You must be signed in to change notification settings - Fork 0
/
process-csv.js
49 lines (40 loc) · 1.14 KB
/
process-csv.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
require("dotenv").config();
const fs = require("fs-extra");
const { Parser } = require("json2csv");
const supabase = require("./db/init");
let data = [];
const processCSVFromDB = async (start) => {
const { data: Demands, error } = await supabase
.from("Demands")
.select("*")
.range(start, start + 999);
data = data.concat(Demands);
if (Demands.length >= 999) {
processCSVFromDB(start + 999);
} else {
const json2csvParser = new Parser();
const csv = json2csvParser.parse(data);
fs.writeFileSync("data.csv", csv, "utf8");
}
// const data = resp["data"];
// new_data = data.map((item) => {
// return [
// item["id"],
// item["content"],
// item["name"],
// item["patient_age"],
// item["contact_number"],
// item["location"],
// item["oxygen_level"],
// item["source_id"],
// item["status"],
// item["source"],
// item["hospital"],
// item["datetime"],
// item["help_needed"],
// ];
// });
// console.log(new_data);
// sheets.updateSheet(sheets.jwt, new_data);
};
processCSVFromDB(0);