Project

General

Profile

1 244 aaronmk
# Make
2 247 aaronmk
SHELL := /bin/bash
3 259 aaronmk
subMake = $(if $(wildcard $(@D)/Makefile*),$(MAKE) $(@F) --directory=$(@D),)
4 244 aaronmk
5 245 aaronmk
# OS
6 247 aaronmk
os := $(shell uname)
7 245 aaronmk
forOs = $(patsubst %,%-$(filter Linux Darwin,$(os)),$(1))
8
9 241 aaronmk
# Terminal
10 247 aaronmk
esc := '['
11
reset := $(esc)'0m'
12
emph := $(esc)'7m '
13
endEmph := ' '$(reset)
14 245 aaronmk
15
# User interaction
16
17
confirm = $(shell read -p $(emph)"$(1) (y/n)"$(endEmph) REPLY; \
18
test "$REPLY" = y && echo t)
19
20
getPassword = $(shell read -s -p $(emph)"Enter your $(1) password:"$(endEmph) \
21
REPLY; echo >&2; echo -n "$REPLY")
22
23 247 aaronmk
wait := read -p $(emph)'Press ENTER to continue:'$(endEmph) REPLY
24 245 aaronmk
25 249 aaronmk
done = echo; echo $(emph)"Finished $@"$(endEmph); echo
26 235 aaronmk
27 335 aaronmk
# File editing
28
sudoAppend = echo $$'$(2)'|sudo tee -a $(1) >/dev/null
29
30 241 aaronmk
# Env
31 225 aaronmk
export PGOPTIONS = --client-min-messages=WARNING
32
33 388 aaronmk
subdirs := schemas/ mappings/
34
35 241 aaronmk
#####
36 225 aaronmk
37 388 aaronmk
all: _always $(subdirs)
38 228 aaronmk
39 225 aaronmk
.SUFFIXES:
40
41 383 aaronmk
_always:
42
.PHONY: _always
43 202 aaronmk
44 388 aaronmk
clean: $(addsuffix clean,$(subdirs))
45
46
*/%: _always
47
	$(subMake)
48
.PRECIOUS: */%
49
50
%/: _always
51
	$(subMake)
52
.PRECIOUS: %/
53
54 241 aaronmk
#####
55
56 383 aaronmk
install: _always core mysql inputs test
57 241 aaronmk
	@$(done)
58 202 aaronmk
59 383 aaronmk
uninstall: _always rm_inputs rm_mysql rm_core
60 241 aaronmk
61 383 aaronmk
reinstall: _always uninstall install
62 225 aaronmk
63 241 aaronmk
#####
64 202 aaronmk
65 383 aaronmk
core: _always $(call forOs,python postgres) postgres_user db
66 241 aaronmk
	@$(done)
67 235 aaronmk
68 383 aaronmk
rm_core: _always rm_db rm_postgres_user
69 241 aaronmk
70 383 aaronmk
reinstall_core: _always rm_core core
71 241 aaronmk
72 383 aaronmk
python-Linux: _always
73 334 aaronmk
	-sudo apt-get install python python-dev python-dateutil python-pip
74 284 aaronmk
75 383 aaronmk
python-Darwin: _always
76 284 aaronmk
	@echo $(emph)'Installing python-dateutil on Mac OS X:'$(endEmph)
77
	@echo 'Download it: http://labix.org/download/python-dateutil/python-dateutil-1.5.tar.gz'
78
	@echo 'Extract the archive'
79
	@echo 'Change to the directory of the extracted files'
80
	@echo 'Run python setup.py build'
81
	@echo 'Run sudo python setup.py install'
82
	@echo "Run python -c 'import dateutil'"
83
	@$(wait)
84
85 337 aaronmk
editPhppgadminApacheConf = echo $$'1\n,s/\# \(allow from all\)/\1/\nwq'|\
86 336 aaronmk
sudo ed --loose-exit-status --verbose /etc/phppgadmin/apache.conf
87 334 aaronmk
88
apacheConf := /etc/apache2/apache2.conf
89
apacheConfPhppgadminLine := Include /etc/phppgadmin/apache.conf
90
editApacheConfForPhppgadmin =\
91
$(if $(shell grep -F "$(apacheConfPhppgadminLine)" $(apacheConf)),,\
92
$(call sudoAppend,$(apacheConf),\n$(apacheConfPhppgadminLine)))
93
94 335 aaronmk
nonApacheOnPort80 = $(shell sudo lsof -i :80|tail -n +2|grep -v -F apache2)
95 336 aaronmk
editApachePortsConf = echo $$'1\n,s/\\b80\\b/8080/g\nwq'|\
96
sudo ed --loose-exit-status --verbose /etc/apache2/ports.conf
97 334 aaronmk
98 383 aaronmk
postgres-Linux: _always
99 329 aaronmk
	-sudo apt-get install postgresql libpq-dev phppgadmin
100 336 aaronmk
	$(editPhppgadminApacheConf)
101 334 aaronmk
	$(editApacheConfForPhppgadmin)
102 336 aaronmk
	$(if $(nonApacheOnPort80),$(editApachePortsConf))
103 334 aaronmk
	-sudo apache2ctl restart
104 284 aaronmk
	-sudo pip install psycopg2
105 334 aaronmk
# ignore errors if conf files already edited
106 235 aaronmk
107 383 aaronmk
postgres-Darwin: _always
108 254 aaronmk
	@echo $(emph)'Installing PostgreSQL on Mac OS X:'$(endEmph)
109
	@echo 'Download it using the topmost "Mac OS X" link at http://http://www.enterprisedb.com/products-services-training/pgdownload'
110
	@echo 'Open the disk image'
111
	@echo 'Run the installer in it'
112
	@$(wait)
113 235 aaronmk
114 383 aaronmk
postgres-: _always # other OSes
115 241 aaronmk
116 247 aaronmk
psqlOpts := --set ON_ERROR_STOP=1 --quiet
117 249 aaronmk
psqlAsAdmin := sudo -u postgres psql $(psqlOpts)
118 274 aaronmk
psqlAsBien := ./bin/psql_vegbien $(psqlOpts)
119 272 aaronmk
bienPassword := $(shell cat config/bien_password)
120 241 aaronmk
121 383 aaronmk
postgres_user: _always
122 249 aaronmk
	-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin)
123 364 aaronmk
# ignore errors if user exists
124 241 aaronmk
125 383 aaronmk
rm_postgres_user: _always
126 241 aaronmk
	echo "DROP USER IF EXISTS bien;"|$(psqlAsAdmin)
127
128
#####
129
130 383 aaronmk
db: _always
131
	-$($@_create_cmd)
132 364 aaronmk
	$(psqlAsBien) <mappings/schemas/vegbien.sql
133
# ignore errors if database exists
134 383 aaronmk
db_create_cmd = echo "CREATE DATABASE vegbien OWNER bien ENCODING 'UTF8' \
135 381 aaronmk
TEMPLATE template1;"|$(psqlAsAdmin)
136 241 aaronmk
137 383 aaronmk
rm_db: _always
138 241 aaronmk
	echo "DROP DATABASE IF EXISTS vegbien;"|$(psqlAsAdmin)
139
140 383 aaronmk
reinstall_db: _always rm_db db
141 241 aaronmk
142 383 aaronmk
empty_db: _always
143 275 aaronmk
	$(psqlAsBien) <mappings/schemas/vegbien_empty.sql
144 241 aaronmk
145
#####
146
147 383 aaronmk
mysql: _always $(call forOs,mysql) mysql_user
148 241 aaronmk
	@$(done)
149
150 383 aaronmk
rm_mysql: _always rm_mysql_user
151 241 aaronmk
152 383 aaronmk
mysql-Linux: _always
153 244 aaronmk
	@echo $(emph)"If asked for MySQL root password, enter $(bienPassword)"$(endEmph)
154 238 aaronmk
	@$(wait)
155 237 aaronmk
	-sudo apt-get install mysql-server mysql-client python-mysqldb
156 235 aaronmk
157 383 aaronmk
mysql-Darwin: _always
158 244 aaronmk
	@echo $(emph)'Installing MySQLdb Python driver on Mac OS X 10.7 (may work on other versions):'$(endEmph)
159 235 aaronmk
	@echo 'Download it using "latest version" link at http://sourceforge.net/projects/mysql-python/files/'
160
	@echo 'Extract the archive'
161
	@echo '(From http://www.rustyrazorblade.com/2011/11/installing-mysqldb-on-macos-lion/:)'
162 284 aaronmk
	@echo 'Run ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib'
163
	@echo 'Run ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql'
164 235 aaronmk
	@echo '(From http://blog.infoentropy.com/MySQL-python_EnvironmentError_mysql_config_not_found:)'
165
	@echo 'Edit site.cfg and change the line like "mysql_config = " to "mysql_config = /usr/local/mysql/bin/mysql_config"'
166
	@echo '(From http://www.mangoorange.com/2008/08/01/installing-python-mysqldb-122-on-mac-os-x/:)'
167
	@echo 'Change to the directory of the extracted files'
168 284 aaronmk
	@echo 'Run python setup.py clean'
169
	@echo 'Run python setup.py build'
170 235 aaronmk
	@echo 'Run sudo python setup.py install'
171
	@echo "Run python -c 'import MySQLdb'"
172 238 aaronmk
	@$(wait)
173 235 aaronmk
174 383 aaronmk
mysql-: _always # other OSes
175 235 aaronmk
176 247 aaronmk
mysqlAsRoot := mysql --user=root --password='$(bienPassword)'
177 235 aaronmk
178 383 aaronmk
mysql_user: _always
179 241 aaronmk
	-$($@_cmd)
180 364 aaronmk
# ignore errors if user exists
181 244 aaronmk
mysql_user_cmd = echo "CREATE USER 'bien'@'localhost' IDENTIFIED BY \
182 245 aaronmk
'$(bienPassword)';"|$(mysqlAsRoot)
183 202 aaronmk
184 383 aaronmk
rm_mysql_user: _always
185 245 aaronmk
	-echo "DROP USER 'bien'@'localhost';"|$(mysqlAsRoot)
186 364 aaronmk
# ignore errors if user exists
187 202 aaronmk
188 241 aaronmk
#####
189 202 aaronmk
190 268 aaronmk
inputs := $(wildcard inputs/*/)
191 245 aaronmk
192 383 aaronmk
inputs: _always $(addsuffix install,$(inputs))
193 250 aaronmk
194 383 aaronmk
rm_inputs: _always $(addsuffix uninstall,$(inputs))
195 250 aaronmk
196 386 aaronmk
import: _always $(addsuffix import,$(inputs))
197
198 383 aaronmk
verify: _always $(addsuffix verify,$(inputs))
199 375 aaronmk
200 383 aaronmk
test2: _always $(addsuffix test,$(inputs))
201 375 aaronmk
202 245 aaronmk
#####
203
204 383 aaronmk
test: _always test-map
205 241 aaronmk
	@$(done)
206 202 aaronmk
207 383 aaronmk
test-%: _always
208 176 aaronmk
	./test/$(*F)