# Terminal

esc = '['

reset = $(esc)'0m'

emph = $(esc)'7m '

end_emph = ' '$(reset)

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

done = echo; echo $(emph)"Finished $@"$(end_emph); 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=$@,)

#####

with_db = $(MAKE) _with_db_$@

#####

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

	$(with_db)

# sub-make will include vegbien_dest

_with_db_postgres_user: _not_file

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

	@sudo -v

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

	-$($@_cmd)

# ignore errors about user existing

_with_db_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

#####

inputs: _not_file $(call forOs,mysql) mysql_user $(wildcard ../../inputs/*/)

	@$(done)

rm_inputs: _not_file rm_mysql_user

mysql-Linux: _not_file

	$(with_db)

# sub-make will include vegbien_dest

_with_db_mysql-Linux: _not_file

	@echo $(emph)"At prompt for MySQL root password, enter $(bienPassword)"$(end_emph)

	@$(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):'$(end_emph)

	@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=root --password='$(bienPassword)'

mysql_user: _not_file

	$(with_db)

# sub-make will include vegbien_dest

_with_db_mysql_user: _not_file

	-$($@_cmd)

# ignore errors about user existing

_with_db_mysql_user_cmd = echo "CREATE USER 'bien'@'localhost' \

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

rm_mysql_user: _not_file

	$(with_db)

# sub-make will include vegbien_dest

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