#!/bin/bash
# Pre-commit hook to make a mysql dump right before committing and add it to the commit.
#
## Change the following values to suit your local setup.
# The name of a database user with read access to the database.
DBUSER=root
# The password associated with the above user. Leave commented if none.
#DBPASS=seekrit
# The database associated with this repository.
DBNAME=dplay
# The path relative to the repository root in which to store the sql dump.
DBPATH=schema

[[ -d schema ]] || mkdir schema
if [ -t $DBPASS ]; then
	mysqldump -u $DBUSER -p$DBPASS $DBNAME > $DBPATH/$DBNAME.sql
else
	mysqldump -u $DBUSER $DBNAME > $DBPATH/$DBNAME.sql
fi

git add $DBPATH/$DBNAME.sql
exit 0