Jason Dsouza jasonrdsouza

## sqliteSchemaDiagram.sql
-- Generates a diagram of table schema relationships in
-- GraphViz DOT format (https://graphviz.org/doc/info/lang.html)
-- via a SQLite query

-- To run:
-- > sqlite3 path/to/database.db -init sqlite-schema-diagram.sql "" > schema.dot
-- > dot -Tsvg schema.dot > schema.svg

-- Fork of: https://gitlab.com/Screwtapello/sqlite-schema-diagram/

## declarative_migrator.py
# coding: utf-8

"""Simple declarative schema migration for SQLite.

See <https://david.rothlis.net/declarative-schema-migration-for-sqlite>.

Author: William Manley <will@stb-tester.com>.
Copyright Â© 2019-2022 Stb-tester.com Ltd.
License: MIT.
"""

## expenses_appscript.js
/*
 * Script to automate sending the monthly debt emails.
 */

var EMAIL_RECEPIENT = "example@gmail.com"

var COLUMNS = {
  "date": 0,
  "paid": 1,
  "total": 2,

## compressFolder.go
// Original source: https://github.com/mimoo/eureka/blob/master/folders.go
package main

import (
	"archive/tar"
	"bytes"
	"compress/gzip"
	"fmt"
	"io"
	"os"

## smart_connect.go
// Small exploration into the ease of implementing an interface (and server) to abstract
// away the complexities of dealing with cumbersome and non-standardized network
// protocols.
//
// The resulting server exposes a simple HTTP API to clients, routing and forwarding
// their requests behind the scenes to a collection of raw network streams. The goal
// is to hide the underlying communication protocol and network multiplexing from
// clients, instead exposing a simple request/response API spoken in the lingua franca
// of the web.
//

## island_counter.py
from collections import namedtuple

Node = namedtuple('Node', 'row col')

class IslandCounter:
  def __init__(self, ocean_map):
    self.map = ocean_map
    self.max_row = len(ocean_map)
    self.max_col = len(ocean_map[0])

## choose_winner.dart
import 'dart:math';

List<String> contestants = [
  'Jason',
  'Matt',
  'Gabe',
  'Ishan',
  'Luis',
  'Katie',
  'Andrew',

## nest_thermostat_info.py
import nest # https://pypi.org/project/python-nest/
import configparser

config = configparser.ConfigParser()
config.read('config.ini')

napi = nest.Nest(client_id=config['NEST']['client_id'], client_secret=config['NEST']['client_secret'], access_token_cache_file='token_cache')

if napi.authorization_required:
    print('Go to ' + napi.authorize_url + ' to authorize, then enter PIN below')

## GroceryLogic.dart
/*
 * The basic idea is to make a Grocery List progressive web app in Dartlang,
 * using Firestore (https://firebase.google.com/docs/firestore/) as the backend.
 * This pad is a quick sketch of the logic necessary to get the app working.
 */

enum Categories {
  produce,
  dairy,
  household,

## aws-restarter.py
'''
Helper script to quickly restart all of the instances of a specific app
Assumes lots of things about the setup of the app (load balancer, ssh access, supervisor, etc.)
'''
import boto3
import subprocess
import argparse


def load_balancer_instances(name):
	-- Generates a diagram of table schema relationships in
	-- GraphViz DOT format (https://graphviz.org/doc/info/lang.html)
	-- via a SQLite query

	-- To run:
	-- > sqlite3 path/to/database.db -init sqlite-schema-diagram.sql "" > schema.dot
	-- > dot -Tsvg schema.dot > schema.svg

	-- Fork of: https://gitlab.com/Screwtapello/sqlite-schema-diagram/
	# coding: utf-8

	"""Simple declarative schema migration for SQLite.

	See <https://david.rothlis.net/declarative-schema-migration-for-sqlite>.

	Author: William Manley <will@stb-tester.com>.
	Copyright Â© 2019-2022 Stb-tester.com Ltd.
	License: MIT.
	"""
	/*
	* Script to automate sending the monthly debt emails.
	*/

	var EMAIL_RECEPIENT = "example@gmail.com"

	var COLUMNS = {
	"date": 0,
	"paid": 1,
	"total": 2,
	// Original source: https://github.com/mimoo/eureka/blob/master/folders.go
	package main

	import (
	"archive/tar"
	"bytes"
	"compress/gzip"
	"fmt"
	"io"
	"os"
	// Small exploration into the ease of implementing an interface (and server) to abstract
	// away the complexities of dealing with cumbersome and non-standardized network
	// protocols.
	//
	// The resulting server exposes a simple HTTP API to clients, routing and forwarding
	// their requests behind the scenes to a collection of raw network streams. The goal
	// is to hide the underlying communication protocol and network multiplexing from
	// clients, instead exposing a simple request/response API spoken in the lingua franca
	// of the web.
	//
	from collections import namedtuple

	Node = namedtuple('Node', 'row col')

	class IslandCounter:
	def __init__(self, ocean_map):
	self.map = ocean_map
	self.max_row = len(ocean_map)
	self.max_col = len(ocean_map[0])
	import 'dart:math';

	List<String> contestants = [
	'Jason',
	'Matt',
	'Gabe',
	'Ishan',
	'Luis',
	'Katie',
	'Andrew',
	import nest # https://pypi.org/project/python-nest/
	import configparser

	config = configparser.ConfigParser()
	config.read('config.ini')

	napi = nest.Nest(client_id=config['NEST']['client_id'], client_secret=config['NEST']['client_secret'], access_token_cache_file='token_cache')

	if napi.authorization_required:
	print('Go to ' + napi.authorize_url + ' to authorize, then enter PIN below')
	/*
	* The basic idea is to make a Grocery List progressive web app in Dartlang,
	* using Firestore (https://firebase.google.com/docs/firestore/) as the backend.
	* This pad is a quick sketch of the logic necessary to get the app working.
	*/

	enum Categories {
	produce,
	dairy,
	household,
	'''
	Helper script to quickly restart all of the instances of a specific app
	Assumes lots of things about the setup of the app (load balancer, ssh access, supervisor, etc.)
	'''
	import boto3
	import subprocess
	import argparse


	def load_balancer_instances(name):