Simon Kelly snopoke

Full stack engineer and team lead based in beautiful Cape Town with 20+ years experience in the development sector.

snopoke / index.html

Created February 21, 2013 07:02 — forked from darwin/index.html

	<!DOCTYPE html>
	<meta charset="utf-8">
	<link rel="stylesheet" href="http://cmx.io/v/0.1/cmx.css"/>
	<script src="http://cmx.io/v/0.1/cmx.js"></script>
	<body>
	<scene id="scene1">
	<label t="translate(0,346)">
	<tspan x="0" y="0em">A Comix Sample</tspan>
	</label>
	<actor t="translate(131,49)" pose="-11,9\|-5,117\|-11,99\|-11,89\|-11,79\|-11,59\|-16,34\|-21,9\|-6,34\|-1,9\|-18,79\|-18,59\|-6,79\|-1,59">

snopoke / find_view_references.sh

Last active December 21, 2015 01:38

Find usage count of CouchDB views

	#!/bin/bash
	# Basic script to find all references to CouchDB views in code.
	# 1. Find all 'map.js' files
	# 2. Based on some assumptions about the structure they are in
	# generate the CouchDB view name.
	# 3. Look for all references of that name in all ".py" files.
	#
	# Output saved to 'view_usage.csv'

	OUTPUT=view_usage.csv

snopoke / gitconfig

Last active December 29, 2015 08:39

gitconfig

snopoke / excel-query.png

Last active August 29, 2015 14:03

commcare-export demo

snopoke / creole_md.py

Created February 5, 2015 15:31

Creole to Markdown

	import functools
	import re
	import sys


	def header_repl(matchobj):
	return "{} {}".format(len(matchobj.group(1)) * '#', matchobj.group(2))


	def list_repl(matchobj, ordered=True):

snopoke / gist:cc62366f9856e3f301f3

Last active August 29, 2015 14:18 — forked from glynnbird/gist:7e36d1c92d5136dec714

	#!/bin/bash
	# Simple script for simulating document conflicts in Cloudant / CouchDB

	DEST="conflict_test"
	DOC="doc_with_conflicts"

	USERNAME="my-username"
	read -s -p "Enter Password: " PASSWORD

	HOST="$USERNAME.cloudant.com"

snopoke / errand_boy_test.py

Created September 1, 2015 15:09

	from errand_boy.transports.unixsocket import UNIXSocketTransport
	from subprocess import PIPE

	form = """<h:html xmlns:h="http://www.w3.org/1999/xhtml" xmlns:orx="http://openrosa.org/jr/xforms" xmlns="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:jr="http://openrosa.org/javarosa" xmlns:vellum="http://commcarehq.org/xforms/vellum">\n\t<h:head>\n\t\t<h:title>Newborn Treatment</h:title>\n\t\t<model>\n\t\t\t<instance>\n\t\t\t\t<data xmlns:jrm="http://dev.commcarehq.org/jr/xforms" xmlns="http://openrosa.org/formdesigner/1904f15bf570b2e0169690416432f6103621b155" uiVersion="1" version="1" name="Newborn Treatment">\n\t\t\t\t\t<debug>\n\t\t\t\t\t\t<classification_infection_debug/>\n\t\t\t\t\t\t<classification_poids_debug/>\n\t\t\t\t\t\t<classification_occular_debug/>\n\t\t\t\t\t\t<classification_vih_debug/>\n\t\t\t\t\t\t<classification_malnutrition_debug/>\n\t\t\t\t\t\t<alimentation_qc_debug/>\n\t\t\t\t\t\t<alimentation_qd_debug/>\n\t\t\t\t\t\t<alimentation_qf_debug/>\n\t\t\t\t\t\t<a

snopoke / create_functions.sql

Created June 22, 2016 18:10

Bash and SQL scripts for testing plproxy server configuration

	drop function if exists make_new_user(TEXT);

	create function make_new_user(p_username TEXT, user_id OUT INTEGER ) as $$
	begin
	INSERT INTO users (username, shard, last_updated) VALUES (p_username, (hashtext(p_username)&15), now())
	RETURNING users.user_id INTO user_id;
	end;
	$$ language plpgsql;

	drop function if exists get_all_users_with_db();

snopoke / report.py

Last active August 24, 2017 11:21 — forked from javierwilson/report.py

Generates CSV for last week cpu, mem and disk utilization

	#!/usr/bin/env python

	import datetime
	import os

	from datadog import initialize, api
	from collections import defaultdict


	options = {

snopoke / first_form_from_location.py

Created June 26, 2017 13:11

Min Form Date from Location

	from dimagi.utils.chunked import chunked
	from corehq.apps.locations.dbaccessors import user_ids_at_locations
	from corehq.apps.es.aggregations import *
	from corehq.apps.es import FormES
	from corehq.apps.locations.models import *
	from elasticsearch.exceptions import *
	from iso8601 import iso8601


	domain = 'domain'