DB_USER=username
DB_PASSWORD=password
ROOT_DB_PASSWORD=rootdbpassword
SVN=http://url/of/repository
SVN_USER=svnuser
SVN_PASSWORD=svnpassword
DRUSH=drush
DB_PREFIX=
DB_DATA=list of tables to include in a partial database dump

-include *.mk

backup:
	mysqldump -u ${DB_USER} --password=${DB_PASSWORD} ${DB} --opt --complete-insert --max_allowed_packet=1M ${SQLOPTS} > dump.sql

restore: dump.sql
	mysql -u root --password="${ROOT_DB_PASSWORD}" --execute="DROP DATABASE IF EXISTS ${DB}; CREATE DATABASE ${DB}; GRANT ALL ON ${DB}.* TO '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASSWORD}'"
	mysql -u root --password="${ROOT_DB_PASSWORD}" ${DB} -e 'source dump.sql'

dev-restore: devel-modules.sql
	make restore
	mysql -u root --password="${ROOT_DB_PASSWORD}" ${DB} -e 'source devel-modules.sql'

clean:
	mysql -u root --password="${ROOT_DB_PASSWORD}" --execute="DROP DATABASE IF EXISTS ${DB}; CREATE DATABASE ${DB}; GRANT ALL ON ${DB}.* TO '${DB_USER}'@'localhost' IDENTIFIED BY '${DB_PASSWORD}'"

export:
	svn export ${SVN} temp --force

clearcache:
	mysql -u ${DB_USER} --password="${DB_PASSWORD}" ${DB} --execute="DELETE FROM ${DB_PREFIX}cache; DELETE FROM ${DB_PREFIX}cache_menu; DELETE FROM ${DB_PREFIX}cache_views; DELETE FROM ${DB_PREFIX}cache_content; DELETE FROM ${DB_PREFIX}cache_filter; DELETE ${DB_PREFIX}FROM cache_page";

clearmail:
	mysql -u ${DB_USER} --password="${DB_PASSWORD}" ${DB} --execute="UPDATE users SET mail=CONCAT(REPLACE(name, '@', ''), '@example.com');"

mysql:
	mysql -u ${DB_USER} --password="${DB_PASSWORD}" ${DB}

stamp:
	svn info > version-info

tags:
	find -name \*.test -o -name \*.module -o -name \*.php -o -name \*.inc -o -name \*.engine | etags -l php -

nl:
	find -name \*.test -name \*.module -o -name \*.php -o -name \*.inc -o -name \*.engine | xargs dos2unix 
	find -name \*.test -name \*.module -o -name \*.php -o -name \*.inc -o -name \*.engine | xargs svn propset svn:eol-style native


backup_partial:
	mysqldump -u ${DB_USER} --password=${DB_PASSWORD} ${DB} --no-data > partial.sql  # Dump all the schema
	mysqldump -u ${DB_USER} --password=${DB_PASSWORD} ${DB} --opt --complete-insert --max_allowed_packet=1M ${DB_DATA} >> partial.sql # Dump some of the data
	mysqldump -u ${DB_USER} --password=${DB_PASSWORD} ${DB} --opt --complete-insert --max_allowed_packet=1M --where='uid<=1' users users_roles >> partial.sql # Dump the admin and anonymous users
	echo "UPDATE node SET uid=1;" >> partial.sql

doc:
	doxygen docs/doxygen.cfg

cycle:	
	make dev-restore
	${DRUSH} update force