# Make

SHELL := /bin/bash

subMake = $(MAKE) $(@F) --directory=$(@D)

# OS

os := $(shell uname)

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

# Terminal

esc := '['

reset := $(esc)'0m'

emph := $(esc)'7m '

endEmph := ' '$(reset)

# User interaction

confirm = $(shell read -p $(emph)"$(1) (y/n)"$(endEmph) REPLY; \

test "$REPLY" = y && echo t)

getPassword = $(shell read -s -p $(emph)"Enter your $(1) password:"$(endEmph) \

REPLY; echo >&2; echo -n "$REPLY")

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

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

# File editing

sudoAppend = echo $$'$(2)'|sudo tee -a $(1) >/dev/null

# Env

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

subdirs := schemas/ mappings/

#####

all: _always $(subdirs) inputs

.SUFFIXES:

_always:

.PHONY: _always

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

define subdirTargets

$(subdir): _always

	+$$(subMake)

$(subdir)%: _always

	+$$(subMake)

endef

$(foreach subdir,$(wildcard */),$(eval $(subdirTargets)))

#####

install: _always core mysql inputs/install test

	@$(done)

uninstall: _always inputs/uninstall 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)

	@echo 'Download it: http://labix.org/download/python-dateutil/python-dateutil-1.5.tar.gz'

	@echo 'Extract the archive'

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

	@echo 'Run python setup.py build'

	@echo 'Run sudo python setup.py install'

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

	@$(wait)

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

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

apacheConf := /etc/apache2/apache2.conf

apacheConfPhppgadminLine := Include /etc/phppgadmin/apache.conf

editApacheConfForPhppgadmin =\

$(if $(shell grep -F "$(apacheConfPhppgadminLine)" $(apacheConf)),,\

$(call sudoAppend,$(apacheConf),\n$(apacheConfPhppgadminLine)))

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

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

sudo ed --loose-exit-status --verbose /etc/apache2/ports.conf

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)

	@echo 'Download it using the topmost "Mac OS X" link at http://http://www.enterprisedb.com/products-services-training/pgdownload'

	@echo 'Open the disk image'

	@echo 'Run the installer in it'

	@$(wait)

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

	$(psqlAsBien) <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 'Extract the archive'

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

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

	@echo 'Run 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 python setup.py clean'

	@echo 'Run python setup.py build'

	@echo 'Run sudo python setup.py install'

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

	@$(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: _always inputs/all

import: _always inputs/import

verify: _always inputs/verify

test2: _always inputs/test

	@$(done)

#####

test: _always test-map

	@$(done)

test-%: _always

	./test/$(*F)