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

# System

# Terminal

esc := '['

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

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

confirm = $(if $(shell read -p $(emph)"$(1)"$(endEmph)$$'$(if\

# File editing

# DB

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

%-remake: _always

%/reinstall: _always %/uninstall %/install ;

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

	@$(done)

rm_core: _always rm_db ;

reinstall_core: _always rm_core core ;

##### Python

python-Linux: _always

	-sudo apt-get install python

	-sudo pip install ordereddict

	-sudo pip install pp

python-Darwin: _always

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

	@echo $(emph)'Installing pip 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/deny from all/allow from all/\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

	-sudo apt-get install postgresql-plpython-"$$(env minor=1 bin/pg_version)"

	-sudo apt-get install libpq-dev

	$(editPhppgadminApacheConf)

	$(editApacheConfForPhppgadmin)

	$(if $(nonApacheOnPort80),$(editApachePortsConf))

	-sudo apache2ctl restart

	-sudo pip install psycopg2

# run pg_version inline because it needs postgresql to be installed first

# 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 -E -u postgres psql $(psqlOpts)

psqlAsAdminVegbien := $(psqlAsAdmin) vegbien

psqlAsBien := bin/psql_vegbien $(psqlOpts)

bienPassword := $(shell cat config/bien_password)

##### VegBIEN DB

#### DB and bien user

confirmRmDb = $(call confirm,WARNING: This will delete your entire VegBIEN\

DB!,This includes all archived imports and staging tables.)

confirmRmPublicSchema = $(call confirm,WARNING: This will delete the current\

rmPublicSchema := $(call rmSchemaCmd,public)

db: mk_db rm_initial_public schemas/install _always ;

	-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin)

	-echo "CREATE DATABASE vegbien WITH OWNER bien TEMPLATE template1 \

ENCODING 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';"|$(psqlAsAdmin)

	-bin/postgres_vegbien createlang plpythonu

	@$(confirmRmPublicSchema)

	echo $(rmPublicSchema)|$(psqlAsAdminVegbien)

# drop public schema *as admin* because it starts out owned by postgres

rm_db: _always

	@$(confirmRmDb)

reinstall_db: _always rm_db db ;

#### Schemas

schemas := temp functions py_functions public

schemas/install: $(schemas:%=schemas/%/install) ;

schemasReversed := public py_functions functions temp

schemas/uninstall: $(schemasReversed:%=schemas/%/uninstall) ;

	-echo $(call mkSchemaCmd,public)|$(psqlAsBien)

	<$< $(psqlAsBien)

# ignore errors if schema exists

schemas/public/uninstall: _always

	@$(confirmRmPublicSchema)

	echo $(rmPublicSchema)|$(psqlAsBien)

schemas/rotate: _always schemas/rotate-only schemas/public/install ;

schemas/rotate-only: _always

### py_functions

schemas/py_functions/install: schemas/py_functions.sql _always

	<$< $(psqlAsBien)

schemas/%/uninstall: _always

# Note: This can't be used for the current (unrotated) public schema because

schemas/%.backup:

	$(if $(wildcard $@),,"time" env data=1 bin/pg_dump_vegbien $* >$@)

restoreBien = "time" bin/postgres_vegbien pg_restore --exit-on-error --verbose\

schemas/%/rm_indexes: _always

# Needed on Ubuntu 12.04 (also other Linuxes?) because %/reinstall is ignored.

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

test-all: _always remake test missing_mappings

	@$(done)