##### Vars/functions

# Make

SHELL := /bin/bash

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

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

subPath = $(word 2,$(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 := '['

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

##### Environment

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

##### General targets

all:

.SUFFIXES: # turn off built-in suffix rules

.SECONDARY: # don't automatically delete intermediate files

.DELETE_ON_ERROR: # delete target if recipe fails

_always:

.PHONY: _always

remake: _always clean

	$(MAKE)

# re-run make so that cache of existing files is reset

%/remake: _always

	$(MAKE) $(@D)/clean

	$(MAKE) $(@D)/

# re-run make so that cache of existing files is reset

define subdirTargets

$(subdir): _always

	+$$(subMake)

$(subdir)%: _always

	+$$(subMake)

endef

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

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 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)

	@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)

##### PostgreSQL

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)

##### 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

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

##### Datasources

inputs: _always inputs/all ;

import: _always inputs/import ;

verify: _always inputs/verify

	@$(done)

test: _always inputs/test

	@$(done)

#### Maps validation

filter_join_warnings =\

$(SED) -n 's/^.*No join mapping for ([0-9A-Za-z_-]+).*$$/\1/p'\

|bin/ucase_first 0|sort|uniq

missing_joins:

	$(MAKE) inputs/remake 2>&1|$(filter_join_warnings)

##### Testing

test-all: _always remake test

	@$(done)