# Make

SHELL = /bin/bash

# Terminal

esc = '['

reset = $(esc)'0m'

emph = $(esc)'7m '

endEmph = ' '$(reset)

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

echo >&2; echo "$REPLY")

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

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

# OS

os = $(shell uname)

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

# Env

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

#####

all: _not_file install

.SUFFIXES:

_not_file:

.PHONY: _not_file

%/: _not_file

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

#####

install: _not_file core inputs test

	@$(done)

uninstall: _not_file rm_inputs rm_core

reinstall: _not_file uninstall install

#####

core: _not_file $(call forOs,postgres) postgres_user db

	@$(done)

rm_core: _not_file rm_db rm_postgres_user

reinstall_core: _not_file rm_core core

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 # TODO: implement this

postgres-: _not_file # other OSes

psqlOpts = --set ON_ERROR_STOP=1 --quiet

asPostgresAdmin = sudo -u postgres

psqlAsAdmin = $(asPostgresAdmin) psql $(psqlOpts)

psqlAsDbUser = ./util/psql_vegbien $(psqlOpts)

bienPassword = $(shell cat util/bien_password)

postgres_user: _not_file

	@echo $(emph)"At sudo password prompt, enter *your* password"$(endEmph)

	@sudo -v

	@echo $(emph)"At \"Enter password for new role:\", enter $(bienPassword)"$(endEmph)

	-$($@_cmd)

# ignore errors about user existing

postgres_user_cmd = $(asPostgresAdmin) createuser --no-superuser \

--no-createdb --no-createrole --pwprompt "bien"

rm_postgres_user: _not_file

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

#####

db: _not_file

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

rm_db: _not_file

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

reinstall_db: _not_file rm_db db

empty_db: _not_file

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

#####

ifneq ($(filter %_with_mysql_password,$(MAKECMDGOALS)),)

mysqlAdminPassword ?= $(call getPassword,MySQL)

endif

with_mysql_password = $(MAKE) $@_with_mysql_password

#####

inputs: _not_file

	$(with_mysql_password)

# use sub-make

inputs_with_mysql_password: _not_file $(call forOs,mysql) mysql_user \

$(wildcard ../../inputs/*/)

	@$(done)

rm_inputs: _not_file

	$(with_mysql_password)

# use sub-make

rm_inputs_with_mysql_password: _not_file rm_mysql_user

mysql-Linux: _not_file

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

	@$(wait)

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

mysql-Darwin: _not_file

	@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 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'"

	@$(wait)

mysql-: _not_file # other OSes

mysqlAsAdmin = mysql --user='$(USER)' --password='$(mysqlAdminPassword)'

mysql_user: _not_file

	-$($@_cmd)

# ignore errors about user existing

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

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

rm_mysql_user: _not_file

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

# ignore errors about user not existing

#####

test: _not_file test-map

	@$(done)

test-%: _not_file

	./test/$(*F)