{"size": 3865, "ext": "js", "max_stars_repo_path": "getColors.js", "max_stars_repo_name": "ninjascience/colorchoice", "max_stars_repo_stars_event_min_datetime": null, "max_stars_repo_stars_event_max_datetime": null, "max_issues_repo_path": "getColors.js", "max_issues_repo_name": "ninjascience/colorchoice", "max_issues_repo_issues_event_min_datetime": "2021-05-11T07:40:54.000Z", "max_issues_repo_issues_event_max_datetime": "2022-01-22T11:09:26.000Z", "max_forks_repo_path": "getColors.js", "max_forks_repo_name": "ninjascience/colorchoice", "max_forks_repo_forks_event_min_datetime": null, "max_forks_repo_forks_event_max_datetime": null}
{"max_stars_count": null, "max_issues_count": 2, "max_forks_count": null, "avg_line_length": 35.787037037, "max_line_length": 103, "alphanum_fraction": 0.6866752911}
const fs = require('fs');
const readline = require('readline');
const {google} = require('googleapis');

// If modifying these scopes, delete token.json.
const SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly'];
// The file token.json stores the user's access and refresh tokens, and is
// created automatically when the authorization flow completes for the first
// time.
const TOKEN_PATH = 'token.json';

// Load client secrets from a local file.
fs.readFile('credentials.json', (err, content) => {
  if (err) return console.log('Error loading client secret file:', err);
  // Authorize a client with credentials, then call the Google Sheets API.
  authorize(JSON.parse(content), listMajors);
});

/**
 * Create an OAuth2 client with the given credentials, and then execute the
 * given callback function.
 * @param {Object} credentials The authorization client credentials.
 * @param {function} callback The callback to call with the authorized client.
 */
function authorize(credentials, callback) {
  const {client_secret, client_id, redirect_uris} = credentials.installed;
  const oAuth2Client = new google.auth.OAuth2(
      client_id, client_secret, redirect_uris[0]);

  // Check if we have previously stored a token.
  fs.readFile(TOKEN_PATH, (err, token) => {
    if (err) return getNewToken(oAuth2Client, callback);
    oAuth2Client.setCredentials(JSON.parse(token));
    callback(oAuth2Client);
  });
}

/**
 * Get and store new token after prompting for user authorization, and then
 * execute the given callback with the authorized OAuth2 client.
 * @param {google.auth.OAuth2} oAuth2Client The OAuth2 client to get token for.
 * @param {getEventsCallback} callback The callback for the authorized client.
 */
function getNewToken(oAuth2Client, callback) {
  const authUrl = oAuth2Client.generateAuthUrl({
    access_type: 'offline',
    scope: SCOPES,
  });
  console.log('Authorize this app by visiting this url:', authUrl);
  const rl = readline.createInterface({
    input: process.stdin,
    output: process.stdout,
  });
  rl.question('Enter the code from that page here: ', (code) => {
    rl.close();
    oAuth2Client.getToken(code, (err, token) => {
      if (err) return console.error('Error while trying to retrieve access token', err);
      oAuth2Client.setCredentials(token);
      // Store the token to disk for later program executions
      fs.writeFile(TOKEN_PATH, JSON.stringify(token), (err) => {
        if (err) return console.error(err);
        console.log('Token stored to', TOKEN_PATH);
      });
      callback(oAuth2Client);
    });
  });
}

/**
 * Grab color hex values from sheet:
 * @see https://docs.google.com/spreadsheets/d/1y4JFnARdb4_0_rNPT__OeHTdex61dCl9L3ApHXQQoFU/edit#gid=0
 * @param {google.auth.OAuth2} auth The authenticated Google OAuth client.
 */
function listMajors(auth) {
  const sheets = google.sheets({version: 'v4', auth});
  sheets.spreadsheets.get({
    spreadsheetId: '1y4JFnARdb4_0_rNPT__OeHTdex61dCl9L3ApHXQQoFU',
    ranges: "'Army Painter'!A3:B",
    includeGridData: true,

  }, (err, res) => {
    if (err) return console.log('The API returned an error: ' + err);
    const rows = res.data.sheets[0].data[0].rowData;
    if (rows.length) {
      const colorData = rows.map((row) => {
        const color = row.values[0].userEnteredFormat.backgroundColor;
        const hexColor = `#${valueToHex(color.red)}${valueToHex(color.green)}${valueToHex(color.blue)}`
        const name = row.values[1].userEnteredValue.stringValue;
        
        return {
          name,
          hexColor
        };
      });
      console.log(JSON.stringify(colorData));
    } else {
      console.log('No data found.');
    }
  });
}

function valueToHex(value) { 
  let hex = Number(Math.round(value * 255)).toString(16);
  if (hex.length < 2) {
       hex = "0" + hex;
  }
  return hex;
};