SHELL := /bin/bash

subMake = $(if $(wildcard $(@D)/Makefile*),$(MAKE) $(@F) --directory=$(@D),)

# OS

os := $(shell uname)

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

# Terminal

esc := '['

wait := read -p $(emph)'Press ENTER to continue:'$(endEmph) REPLY

done = echo; echo $(emph)"Finished $@"$(endEmph); echo

# File editing

# Env

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

subdirs := schemas/ mappings/

#####

all: _always $(subdirs)

.SUFFIXES:

_always:

clean: _always $(addsuffix clean,$(subdirs))

$(foreach subdir,$(wildcard */),$(eval $(subdir)%: _always; $$(subMake)))

*/: _always

	$(subMake)

#####

install: _always core mysql inputs test

	@$(done)

uninstall: _always rm_inputs rm_mysql rm_core

reinstall: _always uninstall install

#####

core: _always $(call forOs,python postgres) postgres_user db

	@$(done)

rm_core: _always rm_db rm_postgres_user

reinstall_core: _always rm_core core

python-Linux: _always

	-sudo apt-get install python python-dev python-dateutil python-pip

python-Darwin: _always

	@echo $(emph)'Installing python-dateutil on Mac OS X:'$(endEmph)

editPhppgadminApacheConf = echo $$'1\n,s/\# \(allow from all\)/\1/\nwq'|\

sudo ed --loose-exit-status --verbose /etc/phppgadmin/apache.conf

nonApacheOnPort80 = $(shell sudo lsof -i :80|tail -n +2|grep -v -F apache2)

editApachePortsConf = echo $$'1\n,s/\\b80\\b/8080/g\nwq'|\

postgres-Linux: _always

	-sudo apt-get install postgresql libpq-dev phppgadmin

	$(editPhppgadminApacheConf)

	$(editApacheConfForPhppgadmin)

	$(if $(nonApacheOnPort80),$(editApachePortsConf))

	-sudo apache2ctl restart

	-sudo pip install psycopg2

# ignore errors if conf files already edited

postgres-Darwin: _always

	@echo $(emph)'Installing PostgreSQL on Mac OS X:'$(endEmph)

postgres-: _always # other OSes

psqlOpts := --set ON_ERROR_STOP=1 --quiet

psqlAsAdmin := sudo -u postgres psql $(psqlOpts)

psqlAsBien := ./bin/psql_vegbien $(psqlOpts)

bienPassword := $(shell cat config/bien_password)

postgres_user: _always

	-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin)

# ignore errors if user exists

rm_postgres_user: _always

	echo "DROP USER IF EXISTS bien;"|$(psqlAsAdmin)

db: _always schemas/vegbien.sql

	-$($@_create_cmd)

	$(psqlAsBien) <schemas/vegbien.sql

# ignore errors if database exists

db_create_cmd = echo "CREATE DATABASE vegbien OWNER bien ENCODING 'UTF8' \

TEMPLATE template1;"|$(psqlAsAdmin)

rm_db: _always

	echo "DROP DATABASE IF EXISTS vegbien;"|$(psqlAsAdmin)

reinstall_db: _always rm_db db

empty_db: _always schemas/vegbien_empty.sql

mysql: _always $(call forOs,mysql) mysql_user

	@$(done)

rm_mysql: _always rm_mysql_user

mysql-Linux: _always

	@echo $(emph)"If asked for MySQL root password, enter $(bienPassword)"$(endEmph)

	@$(wait)

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

mysql-Darwin: _always

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

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

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

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

	@echo 'Run python setup.py clean'

	@echo 'Run sudo python setup.py install'

	@$(wait)

mysql-: _always # other OSes

mysqlAsRoot := mysql --user=root --password='$(bienPassword)'

mysql_user: _always

	-$($@_cmd)

# ignore errors if user exists

mysql_user_cmd = echo "CREATE USER 'bien'@'localhost' IDENTIFIED BY \

'$(bienPassword)';"|$(mysqlAsRoot)

rm_mysql_user: _always

	-echo "DROP USER 'bien'@'localhost';"|$(mysqlAsRoot)

# ignore errors if user exists

#####

inputs-%: $(addsuffix %,$(shell echo inputs/*/)) _always ;

inputs: _always inputs-install

rm_inputs: _always inputs-uninstall

import: _always inputs-import

verify: _always inputs-verify

test2: _always inputs-test

#####

test: _always test-map

	@$(done)

test-%: _always

	./test/$(*F)