Matthew Mckenzie Azerothian

♾️

Over thinking, over analyzing separates the body from the mind

Azerothian / tmpl.sh

Created December 31, 2015 03:48

	#!/usr/bin/env sh
	TEMPLATE_FILE=$1
	ENV_PREFIX=$2

	env \| grep "^$ENV_PREFIX" \| while IFS="=" read -r name value; do
	printf "s/%s/%q/\n" "${name}" "$value"
	done > sed-script.txt

	cat sed-script.txt # Optional
	sed -f sed-script.txt "$TEMPLATE_FILE"

Azerothian / duplicates.sql

Created September 16, 2015 01:58

How to delete rows that are duplicates over a set of columns, keeping only the one with the lowest ID.

	DELETE FROM tablename
	WHERE id IN (SELECT id
	FROM (SELECT id,
	ROW_NUMBER() OVER (partition BY column1, column2, column3 ORDER BY id) AS rnum
	FROM tablename) t
	WHERE t.rnum > 1);

Azerothian / logger.coffee

Created September 14, 2015 03:36

	debug = require "debug"
	debug.enable('mrc:*')

	module.exports = (prefix="", suffix=":") ->
	return {
	log: debug "#{prefix}log#{suffix}"
	debug: debug "#{prefix}debug#{suffix}"
	sql: debug "#{prefix}debug:sql#{suffix}"
	info: debug "#{prefix}info#{suffix}"
	error: debug "#{prefix}error#{suffix}"

Azerothian / launcher.coffee

Last active September 14, 2015 07:55

Expects target file to export a Promise. use stdin and stdout for comms between new instance of node

	log = require("./logger")("mrc:launcher:")
	if require.main == module
	file = process.argv[2]
	console.log "start", file
	target = require file
	process.on "message", (args) ->
	sendResponse = (status, data) ->
	process.send { status, data }
	process.exit(0)
	return target.apply(undefined, args).then (result) ->

Azerothian / daf.cpp

Created August 31, 2015 01:29

	char *at = strchr(ifName, '@');
	char topic = (char)"flow", *endpoint;
	if(at != NULL)
	endpoint = &at[1];
	else
	endpoint = ifName;
	iface = new CollectorInterface(endpoint, topic);

Azerothian / tablesize.sql

Created August 26, 2015 00:48


	WITH x AS (
	SELECT count(*) AS ct
	,sum(length(t::text)) AS txt_len -- length in characters
	,'TABLENAME'::regclass AS tbl
	FROM TABLENAME t
	)
	, y AS (
	SELECT ARRAY [
	pg_relation_size(tbl)

Azerothian / file.coffee

Created August 9, 2015 03:43


	save = () ->
	return new Promise (resolve, reject) ->
	# do save shit
	return resolve()


	promises = []
	for i in array
	promises.push save(i)

Azerothian / file.js

Last active August 29, 2015 14:27

	/*
	Promise = require "native-or-bluebird"

	checkDatabase = (db) ->
	return new Promise (resolve, reject) ->
	return db.exists (err, exists) ->
	if err?
	return reject(err);
	if exists
	return resolve(db)

Azerothian / gist:f2b0fdbb8a4dc9ac5d83

Created August 9, 2015 00:20


	Promise = require "native-or-bluebird"

	checkDatabase = (db) ->
	return new Promise (resolve, reject) ->
	return db.exists (err, exists) ->
	if err?
	return reject(err);
	if exists
	return resolve(db)

Azerothian / gist:d37784f1fc0cf1a5d180

Created August 8, 2015 02:43

	var ECT, app, ectRenderer, express, rc, reacta;

	express = require('express');

	reacta = require("reacta");

	app = express();

	ECT = require('ect');