Fly Chang leo424y

Copying Data from a Google Sheet into Firebase Realtime Database in real time via Apps Script

If you're trying to do this, you came to the right place!

Watch this code work in real time: https://twitter.com/CodingDoug/status/942576182276497409

See also this gist for copying in the other direction: https://gist.github.com/CodingDoug/ffc4f050cc489a0280eb7f4cbe36af07

Setup

$ convert -version

Version: ImageMagick 7.0.7-8 Q16 x86_64 2017-10-24 http://www.imagemagick.org
Copyright: © 1999-2017 ImageMagick Studio LLC
License: http://www.imagemagick.org/script/license.php
Features: Cipher DPC HDRI Modules
Delegates (built-in): bzlib freetype jng jpeg ltdl lzma png tiff xml zlib

Auto-Deploying via Travis CI

Because Travis CI can automatically execute scripts after successfully (or unsuccessfully!) executing tests, it is an obvious choice for a deployment tool. In order to deploy to a Git repository on a remote server, the process generally is as follows:

Set up SSH keys
Add the server's copy of the repository as a Git remote
Push to the remote
SSH into the server and execute any installation/compilation/miscellaneous commands

Before even touching `.travis.yml`...

Users

$ echo 'gem "webpacker"' >> Gemfile
$ bundle install
$ rails webpacker:install
$ yarn add [email protected] jquery popper.js

diff --git a/config/webpack/environment.js b/config/webpack/environment.js
index d16d9af..86bf1a7 100644

	{
	"emojis": [
	{"emoji": "👩‍👩‍👧‍👧", "name": "family: woman, woman, girl, girl", "shortname": ":woman_woman_girl_girl:", "unicode": "1F469 200D 1F469 200D 1F467 200D 1F467", "html": "👩&zwj;👩&zwj;👧&zwj;👧", "category": "People & Body (family)", "order": ""},
	{"emoji": "👩‍👩‍👧‍👦", "name": "family: woman, woman, girl, boy", "shortname": ":woman_woman_girl_boy:", "unicode": "1F469 200D 1F469 200D 1F467 200D 1F466", "html": "👩&zwj;👩&zwj;👧&zwj;👦", "category": "People & Body (family)", "order": ""},
	{"emoji": "👩‍👩‍👦‍👦", "name": "family: woman, woman, boy, boy", "shortname": ":woman_woman_boy_boy:", "unicode": "1F469 200D 1F469 200D 1F466 200D 1F466", "html": "👩&zwj;👩&zwj;👦&zwj;👦", "category": "People & Body (family)", "order": ""},
	{"emoji": "👨‍👩‍👧‍👧", "name": "family: man, woman, girl, girl", "shortname": ":man_woman_girl_girl:", "unicode": "1F468 200D 1F469 200D 1F467 200D 1F467", "html": "👨&zwj;👩&z

	try
	{
	//取得 http Post RawData(should be JSON)
	string postData = Request.Content.ReadAsStringAsync().Result;
	//剖析JSON
	var ReceivedMessage = isRock.LineBot.Utility.Parsing(postData);
	var item = ReceivedMessage.events.FirstOrDefault();
	string Message = "";

	switch (item.type)

	#Tomtom rhythms found on wikipedia https://en.wikipedia.org/wiki/Rhythm_in_Sub-Saharan_Africa#/media/File:Standard_pattern,_six_beats.png
	#form the basis of this piece coded for Sonic PI by Robin Newman, December 2017

	l1=(ring 1,0,1,0,1,0,1,0,1,0,1,0)
	l2=(ring 0,1,0,1,0,1,0,1,0,1,0,1)
	l3=(ring 0,1,0,0,1,1,0,1,0,1,0,1)
	l4=(ring 1,0,1,0,1,1,0,1,0,1,0,1)
	l=(ring l1,l2,l3,l4)
	set :kill,0 #initialise kill flag


	FILE SPACING:

	# double space a file
	sed G

	# double space a file which already has blank lines in it. Output file
	# should contain no more than one blank line between lines of text.
	sed '/^$/d;G'

	#DRUM SEQUENCER
	use_bpm 125

	#PATTERNS (1=on, 0=off, 8 steps but add more if needed)
	kickpattern = (bools 1,0,0,0,1,0,0,0)
	snarepattern = (bools 0,0,0,1,0,0,1,0)
	hatpattern = (bools 1,0,1,0,1,0,1,1)

	#RESOLUTION (set step resolution in 0.25s)
	seqres = 0.25