# Make

SHELL = /bin/bash

# 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

# 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 mysql inputs test

	@$(done)

uninstall: _not_file rm_mysql 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)

psqlAsBien = ./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

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

#####

mysql: _not_file $(call forOs,mysql) mysql_user

	@$(done)

rm_mysql: _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

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

mysql_user: _not_file

	-$($@_cmd)

# ignore errors about user existing

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

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

rm_mysql_user: _not_file

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

# ignore errors about user not existing

#####

mysqlAsBien = mysql --user=bien --password='$(bienPassword)'

#####

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

#####

test: _not_file test-map

	@$(done)

test-%: _not_file

	./test/$(*F)