Project

General

Profile

1
##### Vars/functions
2

    
3
# Make
4
SHELL := /bin/bash
5
pathParts = $(shell path="$(1)"; echo "$${path%%/*}" "$${path\#*/}")
6
topDir = $(word 1,$(pathParts))
7
subPath = $(word 2,$(pathParts))
8
subMake = $(MAKE) $(call subPath,$@) --directory=$(call topDir,$@)
9

    
10
# OS
11
os := $(shell uname)
12
forOs = $(patsubst %,%-$(filter Linux Darwin,$(os)),$(1))
13

    
14
# Terminal
15
esc := '['
16
reset := $(esc)'0m'
17
emph := $(esc)'7m '
18
endEmph := ' '$(reset)
19

    
20
# User interaction
21

    
22
confirm = $(shell read -p $(emph)"$(1) (y/n)"$(endEmph) REPLY; \
23
test "$REPLY" = y && echo t)
24

    
25
getPassword = $(shell read -s -p $(emph)"Enter your $(1) password:"$(endEmph) \
26
REPLY; echo >&2; echo -n "$REPLY")
27

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

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

    
32
# File editing
33
sudoAppend = echo $$'$(2)'|sudo tee -a $(1) >/dev/null
34

    
35
##### Environment
36

    
37
export PGOPTIONS = --client-min-messages=WARNING
38

    
39
##### General targets
40

    
41
all:
42

    
43
.SUFFIXES:
44

    
45
_always:
46
.PHONY: _always
47

    
48
define subdirTargets
49
$(subdir): _always
50
	+$$(subMake)
51

    
52
$(subdir)%: _always
53
	+$$(subMake)
54
endef
55
$(foreach subdir,$(wildcard */),$(eval $(subdirTargets)))
56

    
57
Makefile: ;
58

    
59
%: $(addsuffix %,$(dir $(shell echo */Makefile))) _always ;
60

    
61
##### Installation
62

    
63
install: _always core mysql inputs/install test
64
	@$(done)
65

    
66
uninstall: _always inputs/uninstall rm_mysql rm_core ;
67

    
68
reinstall: _always uninstall install ;
69

    
70
##### Core: VegBIEN DB and dependencies
71

    
72
core: _always $(call forOs,python postgres) postgres_user db
73
	@$(done)
74

    
75
rm_core: _always rm_db rm_postgres_user ;
76

    
77
reinstall_core: _always rm_core core ;
78

    
79
##### Python
80

    
81
python-Linux: _always
82
	-sudo apt-get install python python-dev python-dateutil python-pip
83

    
84
python-Darwin: _always
85
	@echo $(emph)'Installing python-dateutil on Mac OS X:'$(endEmph)
86
	@echo 'Download it: http://labix.org/download/python-dateutil/python-dateutil-1.5.tar.gz'
87
	@echo 'Extract the archive'
88
	@echo 'Change to the directory of the extracted files'
89
	@echo 'Run python setup.py build'
90
	@echo 'Run sudo python setup.py install'
91
	@echo "Run python -c 'import dateutil'"
92
	@$(wait)
93

    
94
##### PostgreSQL
95

    
96
editPhppgadminApacheConf = echo $$'1\n,s/\# \(allow from all\)/\1/\nwq'|\
97
sudo ed --loose-exit-status --verbose /etc/phppgadmin/apache.conf
98

    
99
apacheConf := /etc/apache2/apache2.conf
100
apacheConfPhppgadminLine := Include /etc/phppgadmin/apache.conf
101
editApacheConfForPhppgadmin =\
102
$(if $(shell grep -F "$(apacheConfPhppgadminLine)" $(apacheConf)),,\
103
$(call sudoAppend,$(apacheConf),\n$(apacheConfPhppgadminLine)))
104

    
105
nonApacheOnPort80 = $(shell sudo lsof -i :80|tail -n +2|grep -v -F apache2)
106
editApachePortsConf = echo $$'1\n,s/\\b80\\b/8080/g\nwq'|\
107
sudo ed --loose-exit-status --verbose /etc/apache2/ports.conf
108

    
109
postgres-Linux: _always
110
	-sudo apt-get install postgresql libpq-dev phppgadmin
111
	$(editPhppgadminApacheConf)
112
	$(editApacheConfForPhppgadmin)
113
	$(if $(nonApacheOnPort80),$(editApachePortsConf))
114
	-sudo apache2ctl restart
115
	-sudo pip install psycopg2
116
# ignore errors if conf files already edited
117

    
118
postgres-Darwin: _always
119
	@echo $(emph)'Installing PostgreSQL on Mac OS X:'$(endEmph)
120
	@echo 'Download it using the topmost "Mac OS X" link at http://http://www.enterprisedb.com/products-services-training/pgdownload'
121
	@echo 'Open the disk image'
122
	@echo 'Run the installer in it'
123
	@$(wait)
124

    
125
postgres-: _always ; # other OSes
126

    
127
psqlOpts := --set ON_ERROR_STOP=1 --quiet
128
psqlAsAdmin := sudo -u postgres psql $(psqlOpts)
129
psqlAsBien := ./bin/psql_vegbien $(psqlOpts)
130
bienPassword := $(shell cat config/bien_password)
131

    
132
postgres_user: _always
133
	-echo "CREATE USER bien PASSWORD '$(bienPassword)';"|$(psqlAsAdmin)
134
# ignore errors if user exists
135

    
136
rm_postgres_user: _always
137
	echo "DROP USER IF EXISTS bien;"|$(psqlAsAdmin)
138

    
139
##### VegBIEN DB
140

    
141
db: _always schemas/vegbien.sql
142
	-$($@_create_cmd)
143
	$(psqlAsBien) <schemas/vegbien.sql
144
# ignore errors if database exists
145
db_create_cmd = echo "CREATE DATABASE vegbien OWNER bien ENCODING 'UTF8' \
146
TEMPLATE template1;"|$(psqlAsAdmin)
147

    
148
rm_db: _always
149
	echo "DROP DATABASE IF EXISTS vegbien;"|$(psqlAsAdmin)
150

    
151
reinstall_db: _always rm_db db ;
152

    
153
empty_db: _always schemas/vegbien_empty.sql
154
	$(psqlAsBien) <schemas/vegbien_empty.sql
155

    
156
##### MySQL
157

    
158
mysql: _always $(call forOs,mysql) mysql_user
159
	@$(done)
160

    
161
rm_mysql: _always rm_mysql_user ;
162

    
163
mysql-Linux: _always
164
	@echo $(emph)"If asked for MySQL root password, enter $(bienPassword)"$(endEmph)
165
	@$(wait)
166
	-sudo apt-get install mysql-server mysql-client python-mysqldb
167

    
168
mysql-Darwin: _always
169
	@echo $(emph)'Installing MySQLdb Python driver on Mac OS X 10.7 (may work on other versions):'$(endEmph)
170
	@echo 'Download it using "latest version" link at http://sourceforge.net/projects/mysql-python/files/'
171
	@echo 'Extract the archive'
172
	@echo '(From http://www.rustyrazorblade.com/2011/11/installing-mysqldb-on-macos-lion/:)'
173
	@echo 'Run ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib'
174
	@echo 'Run ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql'
175
	@echo '(From http://blog.infoentropy.com/MySQL-python_EnvironmentError_mysql_config_not_found:)'
176
	@echo 'Edit site.cfg and change the line like "mysql_config = " to "mysql_config = /usr/local/mysql/bin/mysql_config"'
177
	@echo '(From http://www.mangoorange.com/2008/08/01/installing-python-mysqldb-122-on-mac-os-x/:)'
178
	@echo 'Change to the directory of the extracted files'
179
	@echo 'Run python setup.py clean'
180
	@echo 'Run python setup.py build'
181
	@echo 'Run sudo python setup.py install'
182
	@echo "Run python -c 'import MySQLdb'"
183
	@$(wait)
184

    
185
mysql-: _always # other OSes
186

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

    
189
mysql_user: _always
190
	-$($@_cmd)
191
# ignore errors if user exists
192
mysql_user_cmd = echo "CREATE USER 'bien'@'localhost' IDENTIFIED BY \
193
'$(bienPassword)';"|$(mysqlAsRoot)
194

    
195
rm_mysql_user: _always
196
	-echo "DROP USER 'bien'@'localhost';"|$(mysqlAsRoot)
197
# ignore errors if user exists
198

    
199
##### Datasources
200

    
201
inputs: _always inputs/all ;
202

    
203
import: _always inputs/import ;
204

    
205
verify: _always inputs/verify ;
206
	@$(done)
207

    
208
test: _always inputs/test ;
209
	@$(done)
(1-1/3)