beginning_of_fortnight gem is out

As promised I've cleaned up my beginning of fortnight hack and turned it into a proper ruby gem.

Install in the usual way:

sudo gem install beginning_of_fortnight

It requires ActiveSupport and adds {next,end_of,beginning_of}_fortnight methods to the Date and Time class. They work the same as the *_week methods defined by ActiveSupport. You can set where you want fortnight boundaries to be (or just use the default).

For more info see:

• Code (github)
• Docs (rubydoc.info)
• Gem page (rubygems.org)

I carefully made sure the docs look good in RDoc but, rubydoc.info uses YARD. So they don't look so great and actually the main usage examples which I put at the top of the file aren't showing at all...

I guess I will convert to using YARD. Is RDoc fading away? The website looks pretty musty.

(Just for fun, here are tweets where it all began).

Bash functions to dump and load a mysql database

Everyone probably has one of these, but here is mine. It's a bit rough but works for me. If I was going to make it better I'd probably use getopt instead of $1 and $2 and then add options for changing the mysql user. (Currently it hard codes the user as root). Put it in your .bash_aliases or .bashrc or wherever you keep these types of things.

	# Dump a mysql database to a gzipped sql file
	dbdump() {
	# (adjust defaults as required)
	GZ_FILE=$1; [ ! -n "$GZ_FILE" ] && GZ_FILE="$HOME/.dbdump.gz"
	DB_NAME=$2; [ ! -n "$DB_NAME" ] && DB_NAME='fms'
	echo -n "Dumping database $DB_NAME to $GZ_FILE..."
	# Add --extended-insert=FALSE to mysql command for more readable but MUCH slower sql
	mysqldump -u root $DB_NAME | gzip - > "$GZ_FILE"
	echo ' Done'
	}
	# Load a mysql database from a gzipped sql file
	dbload() {
	# (adjust defaults as required)
	GZ_FILE=$1; [ ! -n "$GZ_FILE" ] && GZ_FILE="$HOME/.dbdump.gz"
	DB_NAME=$2; [ ! -n "$DB_NAME" ] && DB_NAME='fms'
	echo -n "Loading database $DB_NAME from $GZ_FILE..."
	echo "DROP DATABASE $DB_NAME; CREATE DATABASE $DB_NAME;" | mysql -u root
	zcat $GZ_FILE | mysql -u root -D $DB_NAME
	echo ' Done'
	}

view raw dbdump.sh hosted with ❤ by GitHub

Update: I made a set of rake tasks for doing this kind of thing, so I'm not actually using this any more.