Last active
December 12, 2017 17:10
-
-
Save ArvinH/a46f9af2df4316651d2056e610ba68b1 to your computer and use it in GitHub Desktop.
googleCalendar nodejs parser
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var fs = require('fs'); | |
var readline = require('readline'); | |
var google = require('googleapis'); | |
var googleAuth = require('google-auth-library'); | |
// If modifying these scopes, delete your previously saved credentials | |
// at ~/.credentials/calendar-nodejs-quickstart.json | |
var SCOPES = ['https://www.googleapis.com/auth/calendar.readonly']; | |
var TOKEN_DIR = (process.env.HOME || process.env.HOMEPATH || | |
process.env.USERPROFILE) + '/.credentials/'; | |
var TOKEN_PATH = TOKEN_DIR + 'calendar-nodejs-quickstart.json'; | |
var CalendarMapCount = {}; | |
var CalendarMapData = {}; | |
// Load client secrets from a local file. | |
fs.readFile('client_secret.json', function processClientSecrets(err, content) { | |
if (err) { | |
console.log('Error loading client secret file: ' + err); | |
return; | |
} | |
// Authorize a client with the loaded credentials, then call the | |
// Google Calendar API. | |
authorize(JSON.parse(content), listEvents); | |
}); | |
/** | |
* 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) { | |
var clientSecret = credentials.installed.client_secret; | |
var clientId = credentials.installed.client_id; | |
var redirectUrl = credentials.installed.redirect_uris[0]; | |
var auth = new googleAuth(); | |
var oauth2Client = new auth.OAuth2(clientId, clientSecret, redirectUrl); | |
// Check if we have previously stored a token. | |
fs.readFile(TOKEN_PATH, function (err, token) { | |
if (err) { | |
getNewToken(oauth2Client, callback); | |
} else { | |
oauth2Client.credentials = 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 to call with the authorized | |
* client. | |
*/ | |
function getNewToken(oauth2Client, callback) { | |
var authUrl = oauth2Client.generateAuthUrl({ | |
access_type: 'offline', | |
scope: SCOPES | |
}); | |
console.log('Authorize this app by visiting this url: ', authUrl); | |
var rl = readline.createInterface({ | |
input: process.stdin, | |
output: process.stdout | |
}); | |
rl.question('Enter the code from that page here: ', function (code) { | |
rl.close(); | |
oauth2Client.getToken(code, function (err, token) { | |
if (err) { | |
console.log('Error while trying to retrieve access token', err); | |
return; | |
} | |
oauth2Client.credentials = token; | |
storeToken(token); | |
callback(oauth2Client); | |
}); | |
}); | |
} | |
/** | |
* Store token to disk be used in later program executions. | |
* | |
* @param {Object} token The token to store to disk. | |
*/ | |
function storeToken(token) { | |
try { | |
fs.mkdirSync(TOKEN_DIR); | |
} catch (err) { | |
if (err.code != 'EEXIST') { | |
throw err; | |
} | |
} | |
fs.writeFile(TOKEN_PATH, JSON.stringify(token)); | |
console.log('Token stored to ' + TOKEN_PATH); | |
} | |
/** | |
* Lists the next 10 events on the user's primary calendar. | |
* | |
* @param {google.auth.OAuth2} auth An authorized OAuth2 client. | |
*/ | |
function listEvents(auth, pageToken) { | |
var calendar = google.calendar('v3'); | |
var queryOptions = { | |
auth: auth, | |
calendarId: 'primary', | |
timeMax: (new Date()).toISOString(), | |
singleEvents: true, | |
orderBy: 'startTime' | |
}; | |
if (pageToken) { | |
queryOptions.pageToken = pageToken; | |
} | |
calendar.events.list(queryOptions, function (err, response) { | |
if (err) { | |
console.log('The API returned an error: ' + err); | |
return; | |
} | |
var events = response.items; | |
if (events.length == 0) { | |
console.log('No upcoming events found.'); | |
} else { | |
for (var i = 0; i < events.length; i++) { | |
var event = events[i]; | |
var start = event.start.date || event.start.dateTime; | |
var dateString = start.split('T')[0]; | |
var colorId = event.colorId || 'default'; | |
CalendarMapCount[colorId] = CalendarMapCount[colorId] || {}; | |
CalendarMapData[colorId] = CalendarMapData[colorId] || {}; | |
CalendarMapCount[colorId][dateString] = (CalendarMapCount[colorId][dateString] || 0) + 1; | |
CalendarMapData[colorId][dateString] = event.summary; | |
} | |
if (!response.nextSyncToken && !!response.nextPageToken) { | |
// means we have more data, query again! | |
return listEvents(auth, response.nextPageToken); | |
} | |
var headerColors = Object.keys(CalendarMapCount); | |
headerColors.forEach((colorId) => { | |
var headerDate = Object.keys(CalendarMapCount[colorId]); | |
fs.appendFile(`calendarData-${colorId}.csv`, `date,colorIdNum\n`, 'utf8', (err) => { | |
if (err) throw err; | |
headerDate.forEach((date) => { | |
fs.appendFile(`calendarData-${colorId}.csv`, `${date},${CalendarMapCount[colorId][date]}\n`, 'utf8', (err) => { | |
if (err) throw err; | |
}); | |
}); | |
}); | |
}); | |
return; | |
} | |
}); | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment