/*
Docs on the google-spreadsheet package:
https://www.npmjs.com/package/google-spreadsheet
*/

const GoogleSpreadsheet = require('google-spreadsheet');
const {
    promisify
} = require('util');

// These are creds for a Service Account Key specifically, should be a json file in same directory as script
const creds = require('./test_creds');

const SPREADSHEET_ID = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'


var doc = new GoogleSpreadsheet(SPREADSHEET_ID);
var sheet;

async function accessSpreadsheet() {
    await promisify(doc.useServiceAccountAuth)(creds)
    const info = await promisify(doc.getInfo)()
    console.log(`Loaded doc: ` + info.title + ` by ` + info.author.email)
    sheet = info.worksheets[0]
    console.log(
        `sheet 1: ` + sheet.title
    )
}

var getData = async function() {
    await accessSpreadsheet();
    let rows = await promisify(sheet.getRows)({
        offset: 1,
        // limit: 3,
        // orderby: 'col2'
    });
    return rows;
}

module.exports = getData;


/* How to use externally:

const getData = require('./[this_script]')

async function useSpreadsheetData() {
    var data = await getData();

    ...

}

*/