Simon Ho simonho288

🏠

Working from home

I love programming. From first game in 6502 Assembly language on 1982, to now serverless edge programming. Over 40 years still loving it 💕 💻

simonho288 / CreateAndInitNodeJs.sh

Last active March 2, 2021 06:28

	mkdir dynamic-js-site-seo && cd dynamic-js-site-seo
	init -y
	npm install express
	mkdir public

simonho288 / Code.gs

Created July 14, 2020 22:44

	const gSheetUrl = 'Copy & paste your Google Sheet URL here';
	const gFormUrl = 'Copy & paste your Google Form URL here';

	function updateFormBySheetData() {
	// Open the Google Sheet
	let gSheet = SpreadsheetApp.openByUrl(gSheetUrl).getSheetByName('Products');

	// Get the product cells data
	let products = gSheet.getRange(2, 1, gSheet.getLastRow() - 1, 2).getValues();

simonho288 / app.rive

Created July 4, 2020 04:27

	! version = 2.0
	// Substitution
	! sub users = user
	! sub registered = register
	// Triggers
	+ how many user register today
	- <call>subUserRegisterToday</call>
	+ block user #
	- <call>subBlockUser <star></call>
	+ *

simonho288 / rivescripthandlers.js

Created July 4, 2020 04:26

	const assert = require('assert');
	const MongoClient = require('mongodb').MongoClient;
	const mongoUrl = 'mongodb://localhost:27017/mydb';
	const RiveScript = require('rivescript');

	class RsHandler {
	constructor() {
	this._rs = new RiveScript({ utf8: true });
	}

simonho288 / initdb.js

Created July 4, 2020 04:25

	const MongoClient = require('mongodb').MongoClient;
	const mongoUrl = 'mongodb://localhost:27017/demo';

	async function main() {
	let dbc = await MongoClient.connect(mongoUrl, { useNewUrlParser: true });
	let db = dbc.db('demo'); // Create a demo database

	let colUsers = await db.createCollection('users');

	// Delete all records at the beginning

simonho288 / app.js

Created July 4, 2020 04:25

	const express = require('express');
	const bodyParser = require('body-parser');
	const app = express();
	const port = 3000;
	const { WebClient } = require('@slack/web-api');
	const MongoClient = require('mongodb').MongoClient;
	const mongoUrl = 'mongodb://localhost:27017/mydb';

	const CONFIG = require('./config.json')
	const RsHandler = require('./rivescripthandlers');

simonho288 / package.json

Created July 4, 2020 04:24

	{
	"name": "slack-app-backend-admin",
	"version": "1.0.0",
	"description": "An intelligent Slack bot to simplify website administration",
	"main": "app.js",
	"scripts": {
	"start": "node app",
	"initdb": "node initdb.js"
	},
	"repository": {

simonho288 / ServerScripts.js

Created July 4, 2020 02:44

	function unlockWalletRestApi() {
	// Make a POST request with a JSON payload.
	var options = {
	'method': 'post',
	'payload': ''
	};
	UrlFetchApp.fetch('http://demo.simonho.net:5000/api/unlock_wallet', options);
	}

	function createAccountRestApi() {

simonho288 / ClientScripts.js

Created July 4, 2020 02:42

	var _account;

	/////////////////////////////////////////////
	// Internal Functions
	/////////////////////////////////////////////

	// Call server-side script unlockWalletRestApi()
	function callServerUnlockWallet_(callback) {
	var status = app.pages.ElectionPage.descendants.ConnectionStatus; // the status label
	google.script.run.withFailureHandler(function(error) {

simonho288 / server.py

Created July 4, 2020 02:32

	import subprocess
	from flask import Flask
	from flask import render_template
	...
	def cleos(args):
	if isinstance(args, list):
	command = ['cleos', '--wallet-url=http://localhost:8899']
	command.extend(args)
	command = ' '.join(command)
	else: