Damien B IcyMidnight

## Show All Foreign Keys in MySQL
SELECT constraint_schema AS `database`, constraint_name, concat(table_name, '.', column_name) AS 'foreign key', concat(referenced_table_name, '.', referenced_column_name) AS 'references' FROM information_schema.key_column_usage WHERE referenced_table_name IS NOT NULL;

## MySQL functions to convert between binary and string uuids
DELIMITER |

CREATE FUNCTION uuid_from_bin(b BINARY(16))
RETURNS CHAR(36) DETERMINISTIC
BEGIN
  DECLARE hex CHAR(32);
  SET hex = HEX(b);
  RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12));
END
|

## gem uninstall with glob-like-iness
sudo gem uninstall `gem list | grep merb | awk '{ print $1 }'`

## rename extension example
for f in *.yml.example; do cp "$f" "`basename "$f" .yml.example`".yml; done;

## Size in current directory
du -h|egrep "^[^/]*(/[^/]*){0,1}$"

## Log Sequel Queries.rb
Merb.logger.info.auto_flush = true; ::Sequel::DATABASES.each { |db| db.logger = Merb.logger.info}

## Git Committed Changes
gitdiff HEAD FETCH_HEAD

## Change transient hostname
sysctl kernel.hostname
sysctl kernel.hostname=new_hostname

## gist:254670
for i in $(seq 0 1 9); do cmd $i args; done

## gist:277643
#!/bin/bash
function git-create-branch() {
    if [ $# -ne 1 ]; then
         echo 1>&2 Usage: $0 branch_name
         exit 127
    fi

    branch_name=$1
    # Create the remote branch
    echo "git push origin master:refs/heads/$branch_name"
	DELIMITER \|

	CREATE FUNCTION uuid_from_bin(b BINARY(16))
	RETURNS CHAR(36) DETERMINISTIC
	BEGIN
	DECLARE hex CHAR(32);
	SET hex = HEX(b);
	RETURN CONCAT(LEFT(hex, 8), '-', MID(hex, 9,4), '-', MID(hex, 13,4), '-', MID(hex, 17,4), '-', RIGHT(hex, 12));
	END
	\|
	#!/bin/bash
	function git-create-branch() {
	if [ $# -ne 1 ]; then
	echo 1>&2 Usage: $0 branch_name
	exit 127
	fi

	branch_name=$1
	# Create the remote branch
	echo "git push origin master:refs/heads/$branch_name"