Aaron Culich aculich

Cost in USD (from "asia-southeast1")	Cloud SQL (PostgreSQL)	AlloyDB

Mermaid on Github Examples

All of these diagrams are dynamically rendered during html display by Github, the images generated from text inside the Github-Flavored Markdown. None are static images. Mermaid support was released for Github on 2022-02-14

Pros & Cons:

Pro: You don't need to care about the layout.
Con: You cannot control the layout.

Notes:

Not all the features of Mermaid (in particular symbols B-->C[fa:fa-ban forbidden], hyperlink and tooltips) are supported by Github.

Pretty much all queries start off as: SpreadsheetApp.getActiveSheet()

Class: Sheet

getRange(row, column, numRows, numColumns)

Class: Range

Google Documentation

Sorting Cells on Google Spreadsheet with Background colors using Google Apps Script

This is a sample script for sorting the cells on Google Spreadsheet with the background colors using Google Apps Script.

Unfortunately, in the current stage, it seems that sort(sortSpecObj) of Class Range cannot directly sort by the background colors of cells. But when Sheets API is used, this goal can be achieved. Here, "SortRangeRequest" of the method of "spreadsheets.batchUpdate" in Sheets API is used.

Flow

How to use `<details>` `<summary>` expandable content on GitHub with Markdown

Firstly, what is <details> <summary>?

The HTML Details Element (<details>) creates a disclosure widget in which information is visible only when the widget is toggled into an "open" state. A summary or label can be provided using the <summary> element. https://developer.mozilla.org/en-US/docs/Web/HTML/Element/details.

Example

An Ansible summary

Jon Warbrick, July 2014, V3.2 (for Ansible 1.7)

Configuration file

intro_configuration.html

First one found from of

How to use Mac KeyChain to store GitHub repos credentials?

You know the pain, you cloned a repo over HTTPS, and now Git asks you for your password each time you want to push or pull.

Chances are you already have the git credential-osxkeychain command installed. If not, just install Git with brew: brew install git.

Once installed, just tell Git to use the KeyChain to store your credentials:

git config --global credential.helper osxkeychain

	#!/usr/bin/env python3
	"""
	Very simple HTTP server in python for logging requests
	Usage::
	./server.py [<port>]
	"""
	from http.server import BaseHTTPRequestHandler, HTTPServer
	import logging

	class S(BaseHTTPRequestHandler):

	#!/usr/bin/env python3

	import os
	import requests
	import itertools
	from dateutil.parser import parse


	API_KEY = ''
	API_SECRET = ''

	function sync() {

	var id="XXXXXXXXXX"; // CHANGE - id of the secondary calendar to pull events from

	var today=new Date();
	var enddate=new Date();
	enddate.setDate(today.getDate()+7); // how many days in advance to monitor and block off time

	var secondaryCal=CalendarApp.getCalendarById(id);
	var secondaryEvents=secondaryCal.getEvents(today,enddate);