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 |
241
|
aaronmk
|
#####
|
34 |
225
|
aaronmk
|
|
35 |
235
|
aaronmk
|
all: _not_file install
|
36 |
228
|
aaronmk
|
|
37 |
225
|
aaronmk
|
.SUFFIXES:
|
38 |
|
|
|
39 |
235
|
aaronmk
|
_not_file:
|
40 |
|
|
.PHONY: _not_file
|
41 |
202
|
aaronmk
|
|
42 |
241
|
aaronmk
|
#####
|
43 |
|
|
|
44 |
245
|
aaronmk
|
install: _not_file core mysql inputs test
|
45 |
241
|
aaronmk
|
@$(done)
|
46 |
202
|
aaronmk
|
|
47 |
250
|
aaronmk
|
uninstall: _not_file rm_inputs rm_mysql rm_core
|
48 |
241
|
aaronmk
|
|
49 |
235
|
aaronmk
|
reinstall: _not_file uninstall install
|
50 |
225
|
aaronmk
|
|
51 |
241
|
aaronmk
|
#####
|
52 |
202
|
aaronmk
|
|
53 |
284
|
aaronmk
|
core: _not_file $(call forOs,python postgres) postgres_user db
|
54 |
241
|
aaronmk
|
@$(done)
|
55 |
235
|
aaronmk
|
|
56 |
241
|
aaronmk
|
rm_core: _not_file rm_db rm_postgres_user
|
57 |
|
|
|
58 |
|
|
reinstall_core: _not_file rm_core core
|
59 |
|
|
|
60 |
284
|
aaronmk
|
python-Linux: _not_file
|
61 |
334
|
aaronmk
|
-sudo apt-get install python python-dev python-dateutil python-pip
|
62 |
284
|
aaronmk
|
|
63 |
|
|
python-Darwin: _not_file
|
64 |
|
|
@echo $(emph)'Installing python-dateutil on Mac OS X:'$(endEmph)
|
65 |
|
|
@echo 'Download it: http://labix.org/download/python-dateutil/python-dateutil-1.5.tar.gz'
|
66 |
|
|
@echo 'Extract the archive'
|
67 |
|
|
@echo 'Change to the directory of the extracted files'
|
68 |
|
|
@echo 'Run python setup.py build'
|
69 |
|
|
@echo 'Run sudo python setup.py install'
|
70 |
|
|
@echo "Run python -c 'import dateutil'"
|
71 |
|
|
@$(wait)
|
72 |
|
|
|
73 |
337
|
aaronmk
|
editPhppgadminApacheConf = echo $$'1\n,s/\# \(allow from all\)/\1/\nwq'|\
|
74 |
336
|
aaronmk
|
sudo ed --loose-exit-status --verbose /etc/phppgadmin/apache.conf
|
75 |
334
|
aaronmk
|
|
76 |
|
|
apacheConf := /etc/apache2/apache2.conf
|
77 |
|
|
apacheConfPhppgadminLine := Include /etc/phppgadmin/apache.conf
|
78 |
|
|
editApacheConfForPhppgadmin =\
|
79 |
|
|
$(if $(shell grep -F "$(apacheConfPhppgadminLine)" $(apacheConf)),,\
|
80 |
|
|
$(call sudoAppend,$(apacheConf),\n$(apacheConfPhppgadminLine)))
|
81 |
|
|
|
82 |
335
|
aaronmk
|
nonApacheOnPort80 = $(shell sudo lsof -i :80|tail -n +2|grep -v -F apache2)
|
83 |
336
|
aaronmk
|
editApachePortsConf = echo $$'1\n,s/\\b80\\b/8080/g\nwq'|\
|
84 |
|
|
sudo ed --loose-exit-status --verbose /etc/apache2/ports.conf
|
85 |
334
|
aaronmk
|
|
86 |
235
|
aaronmk
|
postgres-Linux: _not_file
|
87 |
329
|
aaronmk
|
-sudo apt-get install postgresql libpq-dev phppgadmin
|
88 |
336
|
aaronmk
|
$(editPhppgadminApacheConf)
|
89 |
334
|
aaronmk
|
$(editApacheConfForPhppgadmin)
|
90 |
336
|
aaronmk
|
$(if $(nonApacheOnPort80),$(editApachePortsConf))
|
91 |
334
|
aaronmk
|
-sudo apache2ctl restart
|
92 |
284
|
aaronmk
|
-sudo pip install psycopg2
|
93 |
334
|
aaronmk
|
# ignore errors if conf files already edited
|
94 |
235
|
aaronmk
|
|
95 |
254
|
aaronmk
|
postgres-Darwin: _not_file
|
96 |
|
|
@echo $(emph)'Installing PostgreSQL on Mac OS X:'$(endEmph)
|
97 |
|
|
@echo 'Download it using the topmost "Mac OS X" link at http://http://www.enterprisedb.com/products-services-training/pgdownload'
|
98 |
|
|
@echo 'Open the disk image'
|
99 |
|
|
@echo 'Run the installer in it'
|
100 |
|
|
@$(wait)
|
101 |
235
|
aaronmk
|
|
102 |
241
|
aaronmk
|
postgres-: _not_file # other OSes
|
103 |
|
|
|
104 |
247
|
aaronmk
|
psqlOpts := --set ON_ERROR_STOP=1 --quiet
|
105 |
249
|
aaronmk
|
psqlAsAdmin := sudo -u postgres psql $(psqlOpts)
|
106 |
274
|
aaronmk
|
psqlAsBien := ./bin/psql_vegbien $(psqlOpts)
|
107 |
272
|
aaronmk
|
bienPassword := $(shell cat config/bien_password)
|
108 |
241
|
aaronmk
|
|
109 |
|
|
postgres_user: _not_file
|
110 |
249
|
aaronmk
|
-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin)
|
111 |
241
|
aaronmk
|
# ignore errors about user existing
|
112 |
|
|
|
113 |
|
|
rm_postgres_user: _not_file
|
114 |
|
|
echo "DROP USER IF EXISTS bien;"|$(psqlAsAdmin)
|
115 |
|
|
|
116 |
|
|
#####
|
117 |
|
|
|
118 |
|
|
db: _not_file
|
119 |
275
|
aaronmk
|
$(psqlAsAdmin) <mappings/schemas/vegbien.sql
|
120 |
241
|
aaronmk
|
|
121 |
|
|
rm_db: _not_file
|
122 |
|
|
echo "DROP DATABASE IF EXISTS vegbien;"|$(psqlAsAdmin)
|
123 |
|
|
|
124 |
|
|
reinstall_db: _not_file rm_db db
|
125 |
|
|
|
126 |
|
|
empty_db: _not_file
|
127 |
275
|
aaronmk
|
$(psqlAsBien) <mappings/schemas/vegbien_empty.sql
|
128 |
241
|
aaronmk
|
|
129 |
|
|
#####
|
130 |
|
|
|
131 |
245
|
aaronmk
|
mysql: _not_file $(call forOs,mysql) mysql_user
|
132 |
241
|
aaronmk
|
@$(done)
|
133 |
|
|
|
134 |
245
|
aaronmk
|
rm_mysql: _not_file rm_mysql_user
|
135 |
241
|
aaronmk
|
|
136 |
235
|
aaronmk
|
mysql-Linux: _not_file
|
137 |
244
|
aaronmk
|
@echo $(emph)"If asked for MySQL root password, enter $(bienPassword)"$(endEmph)
|
138 |
238
|
aaronmk
|
@$(wait)
|
139 |
237
|
aaronmk
|
-sudo apt-get install mysql-server mysql-client python-mysqldb
|
140 |
235
|
aaronmk
|
|
141 |
|
|
mysql-Darwin: _not_file
|
142 |
244
|
aaronmk
|
@echo $(emph)'Installing MySQLdb Python driver on Mac OS X 10.7 (may work on other versions):'$(endEmph)
|
143 |
235
|
aaronmk
|
@echo 'Download it using "latest version" link at http://sourceforge.net/projects/mysql-python/files/'
|
144 |
|
|
@echo 'Extract the archive'
|
145 |
|
|
@echo '(From http://www.rustyrazorblade.com/2011/11/installing-mysqldb-on-macos-lion/:)'
|
146 |
284
|
aaronmk
|
@echo 'Run ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib'
|
147 |
|
|
@echo 'Run ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql'
|
148 |
235
|
aaronmk
|
@echo '(From http://blog.infoentropy.com/MySQL-python_EnvironmentError_mysql_config_not_found:)'
|
149 |
|
|
@echo 'Edit site.cfg and change the line like "mysql_config = " to "mysql_config = /usr/local/mysql/bin/mysql_config"'
|
150 |
|
|
@echo '(From http://www.mangoorange.com/2008/08/01/installing-python-mysqldb-122-on-mac-os-x/:)'
|
151 |
|
|
@echo 'Change to the directory of the extracted files'
|
152 |
284
|
aaronmk
|
@echo 'Run python setup.py clean'
|
153 |
|
|
@echo 'Run python setup.py build'
|
154 |
235
|
aaronmk
|
@echo 'Run sudo python setup.py install'
|
155 |
|
|
@echo "Run python -c 'import MySQLdb'"
|
156 |
238
|
aaronmk
|
@$(wait)
|
157 |
235
|
aaronmk
|
|
158 |
241
|
aaronmk
|
mysql-: _not_file # other OSes
|
159 |
235
|
aaronmk
|
|
160 |
247
|
aaronmk
|
mysqlAsRoot := mysql --user=root --password='$(bienPassword)'
|
161 |
235
|
aaronmk
|
|
162 |
241
|
aaronmk
|
mysql_user: _not_file
|
163 |
|
|
-$($@_cmd)
|
164 |
|
|
# ignore errors about user existing
|
165 |
244
|
aaronmk
|
mysql_user_cmd = echo "CREATE USER 'bien'@'localhost' IDENTIFIED BY \
|
166 |
245
|
aaronmk
|
'$(bienPassword)';"|$(mysqlAsRoot)
|
167 |
202
|
aaronmk
|
|
168 |
241
|
aaronmk
|
rm_mysql_user: _not_file
|
169 |
245
|
aaronmk
|
-echo "DROP USER 'bien'@'localhost';"|$(mysqlAsRoot)
|
170 |
241
|
aaronmk
|
# ignore errors about user not existing
|
171 |
202
|
aaronmk
|
|
172 |
241
|
aaronmk
|
#####
|
173 |
202
|
aaronmk
|
|
174 |
268
|
aaronmk
|
inputs := $(wildcard inputs/*/)
|
175 |
245
|
aaronmk
|
|
176 |
259
|
aaronmk
|
inputs: _not_file $(inputs:%=%install)
|
177 |
250
|
aaronmk
|
|
178 |
259
|
aaronmk
|
rm_inputs: _not_file $(inputs:%=%uninstall)
|
179 |
250
|
aaronmk
|
|
180 |
268
|
aaronmk
|
inputs/%: _not_file
|
181 |
250
|
aaronmk
|
-$(subMake)
|
182 |
|
|
# ignore errors in sub-makes
|
183 |
|
|
|
184 |
245
|
aaronmk
|
#####
|
185 |
|
|
|
186 |
241
|
aaronmk
|
test: _not_file test-map
|
187 |
|
|
@$(done)
|
188 |
202
|
aaronmk
|
|
189 |
235
|
aaronmk
|
test-%: _not_file
|
190 |
176
|
aaronmk
|
./test/$(*F)
|