COVID-19 Czech Reproduction number

1const Apify = require('apify');
2const { google } = require('googleapis');
3const { apifyGoogleAuth } = require('apify-google-auth');
4 
5Apify.main(async () => {
6    const input = await Apify.getInput();
7    //console.log('My input:');
8    //console.dir(input);
9
10    const {client_secret, client_id} = input.googleCredentials;
11    const {APIFY_CONTAINER_PORT, APIFY_CONTAINER_URL, APIFY_DEFAULT_KEY_VALUE_STORE_ID,} = process.env;
12    const redirect_uri = APIFY_CONTAINER_URL;
13
14    const authOptions = {
15        scope: 'spreadsheets',
16        tokensStore: 'covid-spreadsheet-token',
17        credentials: {
18            client_id: client_id,
19            client_secret: client_secret,
20            redirect_uri: redirect_uri,
21        },
22    };
23 
24    // Checks your tokensStore for token first. If not found, prompts you to authorize.
25    const authClient = await apifyGoogleAuth(authOptions);
26 
27    const sheets = google.sheets({ version: 'v4', auth: authClient });
28
29    const params = {
30        // The ID of the spreadsheet to retrieve data from.
31        spreadsheetId: '1cCCECunGrLmcxp5RwTRvHPLPi2Uh2J8b4NIoyFDcu7c',  // TODO: Update placeholder value.
32
33        // The A1 notation of the values to retrieve.
34        range: 'A2:D1000',  // TODO: Update placeholder value.
35
36        // How values should be represented in the output.
37        // The default render option is ValueRenderOption.FORMATTED_VALUE.
38        //valueRenderOption: '',  // TODO: Update placeholder value.
39
40        // How dates, times, and durations should be represented in the output.
41        // This is ignored if value_render_option is
42        // FORMATTED_VALUE.
43        // The default dateTime render option is [DateTimeRenderOption.SERIAL_NUMBER].
44        //dateTimeRenderOption: '',  // TODO: Update placeholder value.
45    };
46
47    //console.log("testing spreasheets");
48    const request = await sheets.spreadsheets.values.get(params);
49    //console.log(request.data);
50
51    let data = request.data.values;
52    let ordered = [];
53
54    for (var i = 0; i < request.data.values.length; i++) {
55        const row = request.data.values[i];
56        const date = row[0];
57        const mid = parseFloat(row[1]);
58        const low = parseFloat(row[2]);
59        const max = parseFloat(row[3]);
60        ordered[i] = [];
61        ordered[i][0] = date;
62        ordered[i][1] = low;
63        ordered[i][2] = mid;
64        ordered[i][3] = max;
65    }
66
67    data = ordered;
68
69    // And then save output
70    let output = {
71        data,
72        "lastUpdatedAtSource": new Date(),
73        "lastUpdatedAtApify": new Date(),
74        "readMe": "https://www.sablatura.info/covid/api",
75        //crawledAt: new Date(),
76    };
77
78    const { keyValueStores } = Apify.client;
79
80    const { id: storeId } = await keyValueStores.getOrCreateStore({
81        storeName: 'COVID-CZ-R0'
82    });
83
84    Apify.client.setOptions({ storeId });
85
86    //output = JSON.stringify(output);
87    //console.log('My output:');
88    //console.dir(output);
89    await Apify.setValue('OUTPUT', output);
90  
91    // Just pass the 'key' as the 'keyValueStores' already knows
92    // in what 'storeId' to look at.
93    const record = await keyValueStores.getRecord({ key: 'LATEST' });
94    
95    // Check for empty 'STATE' records
96    const storeRecord = record && record.body ? record.body : {};
97    
98    const previousState = typeof storeRecord === 'string' ?
99        JSON.parse(storeRecord) : storeRecord; 
100
101    // It is a good practice to copy objects instead of
102    // overwriting them. Weird things can happen otherwise.
103    const nextState = Object.assign({}, previousState, output);
104    
105    await keyValueStores.putRecord({
106        key: 'LATEST',      
107        body: JSON.stringify(nextState),    
108    }); 
109    
110});