esc = '['

reset = $(esc)'0m'

highlight = $(esc)'7m'

os = $(shell uname)

forOs = $(patsubst %,%-$(filter Linux Darwin,$(os)),$(1))

export PGOPTIONS = --client-min-messages=WARNING

psqlOpts = --set ON_ERROR_STOP=1 --quiet

asAdmin = sudo -u postgres

psqlAdmin = $(asAdmin) psql $(psqlOpts)

psqlDbUser = ./util/psql_vegbien $(psqlOpts)

all: _not_file install

.SUFFIXES:

_not_file:

.PHONY: _not_file

install: _not_file deps user db

uninstall: _not_file rm_db rm_user

reinstall: _not_file uninstall install

deps: _not_file $(call forOs,postgres mysql)

postgres-Linux: _not_file

	-sudo apt-get install python-dev libpq-dev

	-sudo apt-get install python-pip && sudo pip install psycopg2

postgres-Darwin: _not_file

mysql-Linux: _not_file

	-sudo apt-get install mysql-server mysql-client python-mysqldb

mysql-Darwin: _not_file

	@echo $(highlight)'Installing MySQLdb Python driver on Mac OS X 10.7 (may work on other versions):'$(reset)

	@echo 'Download it using "latest version" link at http://sourceforge.net/projects/mysql-python/files/'

	@echo 'Extract the archive'

	@echo '(From http://www.rustyrazorblade.com/2011/11/installing-mysqldb-on-macos-lion/:)'

	@echo 'Run sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib'

	@echo 'Run sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql'

	@echo '(From http://blog.infoentropy.com/MySQL-python_EnvironmentError_mysql_config_not_found:)'

	@echo 'Edit site.cfg and change the line like "mysql_config = " to "mysql_config = /usr/local/mysql/bin/mysql_config"'

	@echo '(From http://www.mangoorange.com/2008/08/01/installing-python-mysqldb-122-on-mac-os-x/:)'

	@echo 'Change to the directory of the extracted files'

	@echo 'Run sudo python setup.py clean'

	@echo 'Run sudo python setup.py build'

	@echo 'Run sudo python setup.py install'

	@echo "Run python -c 'import MySQLdb'"

	@read -p $(highlight)'Press ENTER to continue: '$(reset)

# Catch-alls for other OSes

mysql-:

postgres-:

reinstall_db: _not_file rm_db db

empty_db: _not_file

	$(psqlDbUser) <../mappings/schemas/vegbien_empty.sql

user: _not_file

	$(MAKE) _$@

ifeq ($(MAKECMDGOALS),_user)

include util/vegbien_dest

endif

_user: _not_file

	@echo $(highlight)"At sudo password prompt, enter *your* password"$(reset)

	@sudo -v

	@echo $(highlight)"At prompt \"Enter password for new role:\", enter $(out_password)"$(reset)

	-$(_user_cmd)

# ignore errors about existing user

_user_cmd = $(asAdmin) createuser --no-superuser --no-createdb --no-createrole \

--pwprompt "$(out_user)"

rm_user: _not_file

	echo "DROP USER bien;"|$(psqlAdmin)

db: _not_file

	$(psqlAdmin) <../mappings/schemas/vegbien.sql

rm_db: _not_file

	echo "DROP DATABASE vegbien;"|$(psqlAdmin)

test: test-map

test-%: _not_file

	./test/$(*F)