Project

General

Profile

1 785 aaronmk
##### Vars/functions
2
3 387 aaronmk
# OS
4
os = $(shell uname)
5
6
SED = sed -$(if $(filter Darwin,$(os)),E,r)
7
8 785 aaronmk
##### General targets
9 387 aaronmk
10 692 aaronmk
all = vegbien.sql vegbien_empty.sql vegbien.my.sql
11 387 aaronmk
12 418 aaronmk
all: _always $(all) ;
13 387 aaronmk
14 1260 aaronmk
.SUFFIXES: # turn off built-in suffix rules
15
.SECONDARY: # don't automatically delete intermediate files
16 1354 aaronmk
.DELETE_ON_ERROR: # delete target if recipe fails
17 387 aaronmk
18
_always:
19
.PHONY: _always
20
21
clean: _always
22
	$(RM) $(all)
23
24
%:: %.make
25
	./$< >$@
26
27 785 aaronmk
##### VegBIEN DB
28 387 aaronmk
29
empty = $(SED) -n \
30
's/^CREATE TABLE ([0-9A-Za-z_]+) \($$/TRUNCATE \1 CASCADE;/p' <$< >$@
31
32
%_empty.sql: %.sql
33
	$(empty)
34 533 aaronmk
35 785 aaronmk
##### MySQL schema for ERD
36 533 aaronmk
37 809 aaronmk
repl = ../bin/repl
38 541 aaronmk
39 809 aaronmk
%.my.sql: %.sql ../lib/PostgreSQL-MySQL.csv filter_ERD.csv
40
	$(repl) <$(wordlist 1,2,$+)|$(repl) $(word 3,$+) >$@