Rich richfergus

intro

As of 2020-07-27 The default google calendar api response does not include the user visible names:

.

Below is a json map for all the default colors. Please note:

colorId empty for event with default color
different colorId for the same color in Calendar and Event (ex. Tomato: 11 and 3)
there is no consistent logic in the enumeration of the colors

	MIT License

	Copyright (c) 2015 Kaleb Fulgham

	Permission is hereby granted, free of charge, to any person obtaining a copy
	of this software and associated documentation files (the "Software"), to deal
	in the Software without restriction, including without limitation the rights
	to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
	copies of the Software, and to permit persons to whom the Software is
	furnished to do so, subject to the following conditions:

	# npm using https for git
	git config --global url."https://github.com/".insteadOf [email protected]:
	git config --global url."https://".insteadOf git://

	# npm using git for https
	git config --global url."[email protected]:".insteadOf https://github.com/
	git config --global url."git://".insteadOf https://

	<cfcomponent output="false" displayname="Spreadsheet Service">
	<cffunction name="init" access="public" output="false" returntype="SpreadsheetService">
	<cfreturn this />
	</cffunction>

	<cffunction name="createFromQuery" access="public" output="false" returntype="void">
	<cfargument name="data" type="query" required="true" />
	<cfargument name="xlsx" type="boolean" required="false" default="false" hint="File extension is xlsx (true) or xls (false)." />
	<cfargument name="fileName" type="string" required="false" default="" hint="Final file name sent to the browser." />
	<cfset var config = {

	/*
	references:
	- https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
	- https://stackoverflow.com/questions/32777081/bulk-insert-and-update-in-mysql
	- https://thewebfellas.com/blog/conditional-duplicate-key-updates-with-mysql
	*/

	/* create a new database and use it */
	drop database if exists test_upsert;
	create database test_upsert;

	<!DOCTYPE html>
	<html ng-app="risevision.apps" itemscope itemtype="http://schema.org/WebApplication" prefix="og: http://ogp.me/ns# fb: http://ogp.me/ns/fb#">
	<head lang="en">
	<base href="/">
	<meta name="fragment" content="!">
	<meta charset="UTF-8">
	<meta name="viewport" content="initial-scale=1, maximum-scale=1, user-scalable=no, width=device-width">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">

	<link rel="icon" href="https://s3.amazonaws.com/Rise-Images/favicons/rv_favicon.ico" type="image/x-icon">