# Make

SHELL := /bin/bash

pathParts = $(shell path="$(1)"; echo "$${path%%/*}" "$${path\#*/}")

topDir = $(word 1,$(pathParts))

subMake = $(MAKE) $(call subPath,$@) --directory=$(call topDir,$@)

# OS

os := $(shell uname)

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

SED = sed -$(if $(filter Darwin,$(os)),E,r)

# Terminal

esc := '['

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

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

# File editing

##### Environment

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

##### General targets

all:

.SUFFIXES: # turn off built-in suffix rules

.DELETE_ON_ERROR: # delete target if recipe fails

_always:

remake: _always clean

%/remake: _always

##### Subdir forwarding

define subdirTargets

$(subdir)%: _always

.PRECIOUS: $(subdir)% # let subdir's Makefile decide whether to delete on error

endef

Makefile: ;

%: $(addsuffix %,$(dir $(shell echo */Makefile))) _always ;

##### Installation

install: _always core mysql inputs/install test

	@$(done)

uninstall: _always inputs/uninstall rm_mysql rm_core ;

reinstall: _always uninstall install ;

##### Core: VegBIEN DB and dependencies

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

	@$(done)

rm_core: _always rm_db rm_postgres_user ;

reinstall_core: _always rm_core core ;

##### Python

python-Linux: _always

	-sudo apt-get install python python-dev python-dateutil python-profiler\

python-pip pymetrics

python-Darwin: _always

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

##### PHP

	@echo $(emph)'Installing PHP PEAR and HTTP_Request on Mac OS X:'$(endEmph)

	@echo 'If needed, set $$PHPRC to your php.ini'

	@echo "Run pear install HTTP_Request"

	@$(wait)

##### PostgreSQL

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)

##### VegBIEN DB

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

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

##### Datasources

inputs: _always inputs/all ;

import: _always import-msg inputs/import ;

	@echo $(emph)"To import all inputs at once:"$(endEmph) . bin/import_all

	@echo

verify: _always inputs/verify

	@$(done)

test: _always inputs/test

	@$(done)

#### Maps validation

missing_mappings: _always missing_join_mappings missing_input_mappings ;

missing_%_mappings: _always # stem is one of join|input

##### Testing