Eric Hayes ejhayes

22 followers · 11 following

@ModioHealth
San Francisco, CA

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

ejhayes / example.sql

Created May 7, 2013 22:03

html_decode function. From: http://forums.mysql.com/read.php?98,246527

	mysql> select html_decode('This & that!');
	+---------------------------------+
	\| html_decode('This & that!') \|
	+---------------------------------+
	\| This & that! \|
	+---------------------------------+
	1 row in set (0.00 sec)

ejhayes / background_deployment.sh

Created March 26, 2013 00:00

	#!/bin/bash
	FAIL=0
	LOG=log.txt
	ERROR_LOG=messages.txt
	GENERATORS=("FILE_1" "FILE_2")

	echo "===> Truncating logs"
	rm -f $LOG
	rm -f *_$ERROR_LOG

ejhayes / list_user_cronjobs.sh

Last active December 15, 2015 05:29

For each user listed grab a list of their cronjobs and display back to the screen.

	#!/bin/bash

	cat /etc/passwd \| sed -e "s/$[^:]\+$.*/\1/" \| xargs -I user bash -c "echo user && su user -c \"crontab -l\""

ejhayes / trac.py

Last active December 14, 2015 14:49

Basic trac api usage

	# Login and authenticate
	from xmlrpclib import ServerProxy
	p = ServerProxy('http://USERNAME:PASSWORD@trac/storm/login/rpc')

	# Query tickets and print out the results
	for i in p.ticket.query('owner=eric&status!=closed'):
	p.ticket.get(i)

	# What ticket attributes are available to pass to the attributes struct?
	p.ticket.getTicketFields()

ejhayes / qualify_fails.sh

Last active December 10, 2015 23:18

This is a pretty nasty way of finding schema.yaml files, renaming them based on directory structure, and moving them to a centralized schemas directory. The goal is to use this for future schema validation.

find beta -type f -name \*.yaml | xargs -I file echo file | sed "s/\(\([a-zA-Z\_]\+\)\/\([a-zA-Z\_]\+\).*\)/kwalify -lf \1 \3\/\2.yaml/" | sh && e=$(find beta -type f -name \*.yaml | xargs -I file echo file | sed "s/\(\([a-zA-Z\_]\+\)\/\([a-zA-Z\_]\+\).*\)/kwalify -lf \1 \3\/\2.yaml/" | sh ) && echo $e | grep -v INVALID

ejhayes / run_changescript.sql

Created December 7, 2012 23:38

SQL Server catch compile time and runtime errors

	/*
	Our runner script
	*/

	CREATE PROCEDURE inner_sp AS
	EXEC dbo.usp_RecordChangeScript '2007-01-2012 (ERIC TEST).sql', '0.1.11'

	EXEC dbo.usp_RecordChangeScript '2004-01-2012 (ERIC TEST).sql', '0.1.11'
	-- CODE GOES HERE
	GO

ejhayes / git-export-multiple-paths.sh

Created November 16, 2012 19:29

Git Export - functions just like a subversion export. Very nice!

git archive --format=zip --remote=git@git:project.git master some/path other/path -o whatever.zip

ejhayes / build1.ps1

Created November 9, 2012 16:15

Calling build2 with arguments gathered from build1

	param (
	[string]$test,
	$buildArgs
	)

	echo $buildArgs.test

	./build2.ps1 @buildArgs

ejhayes / node.rb

Created August 7, 2012 05:43

Rake API for Puppet Dashboard - includes functionality to search for nodes that contain a class

	task :hasclass => :environment do
	class_name = false

	if ENV['class']
	class_name = ENV['class']
	end

	NodeClassMembership.find(:all, :include => [:node_class],:conditions => {
	:node_classes => { :name => class_name }
	}).each do \|node\|

ejhayes / bootstrap_puppet_win.cmd

Created July 26, 2012 00:53

Bootstrap puppet install for windows

	# rename the computer (and reboot)
	runas /user:Administrator "netdom renamecomputer \"%COMPUTERNAME%\" /Newname \"EricTest\" /force /reboot 0"

	# restart computer NOW
	shutdown /r /t 0

Newer Older

	#!/bin/bash

	cat /etc/passwd \| sed -e "s/\([^:]\+\).*/\1/" \| xargs -I user bash -c "echo user && su user -c \"crontab -l\""