|
1
|
selfDir_3d1bc249 := $(dir $(lastword $(MAKEFILE_LIST)))
|
|
2
|
|
|
3
|
# Make
|
|
4
|
addBeforeExt = $(basename $(2))$(1)$(suffix $(2))
|
|
5
|
|
|
6
|
# Commands
|
|
7
|
DIFF = diff --unified=2 $(+:_%=)
|
|
8
|
|
|
9
|
table = $(shell s="$(*F)"; echo "$${s\#\#*.}")# remove sort order prefix
|
|
10
|
|
|
11
|
vegxMaps := $(wildcard map.VegX.*.csv)
|
|
12
|
vegbienMaps := $(subst .VegX.,.VegBIEN.,$(vegxMaps))
|
|
13
|
tables := $(vegbienMaps:map.VegBIEN.%.csv=%)
|
|
14
|
|
|
15
|
root := $(selfDir_3d1bc249)..
|
|
16
|
psqlAsBien := $(root)/bin/psql_vegbien
|
|
17
|
|
|
18
|
#####
|
|
19
|
|
|
20
|
all: _not_file maps import verify
|
|
21
|
|
|
22
|
.SUFFIXES:
|
|
23
|
|
|
24
|
_not_file:
|
|
25
|
.PHONY: _not_file
|
|
26
|
|
|
27
|
clean: _not_file
|
|
28
|
$(RM) $(all)
|
|
29
|
|
|
30
|
rm-%: _not_file
|
|
31
|
$(RM) $*
|
|
32
|
|
|
33
|
%.out: % _not_file
|
|
34
|
./$* >$@
|
|
35
|
.PRECIOUS: %.out
|
|
36
|
|
|
37
|
#####
|
|
38
|
|
|
39
|
reinstall: _not_file uninstall install
|
|
40
|
|
|
41
|
#####
|
|
42
|
|
|
43
|
maps: $(vegbienMaps) _not_file
|
|
44
|
|
|
45
|
all += $(vegbienMaps)
|
|
46
|
|
|
47
|
map.VegBIEN.%.csv: map.VegX.%.csv
|
|
48
|
$(root)/bin/join_sort <$< $(root)/mappings/VegX-VegBIEN.$(table).csv >$@
|
|
49
|
.PRECIOUS: map.VegBIEN.%.csv
|
|
50
|
|
|
51
|
#####
|
|
52
|
|
|
53
|
import: _not_file $(addprefix import-,$(tables))
|
|
54
|
|
|
55
|
log = $*$(if $(n),.n=$(n),).log
|
|
56
|
|
|
57
|
logs := $(wildcard *.log)
|
|
58
|
|
|
59
|
all += $(logs)
|
|
60
|
|
|
61
|
rm_logs: _not_file
|
|
62
|
$(RM) $(logs)
|
|
63
|
|
|
64
|
#####
|
|
65
|
|
|
66
|
verify: _not_file $(addprefix verify-,$(tables))
|
|
67
|
|
|
68
|
verify-%: verify.%.ref verify.%.out _not_file
|
|
69
|
$(DIFF)
|
|
70
|
|
|
71
|
%.out: %.sql _not_file
|
|
72
|
$(psqlAsBien) --no-align --field-separator=' ' --pset=footer=off <$< >$@
|
|
73
|
.PRECIOUS: %.out
|
|
74
|
|
|
75
|
all += $(wildcard *.out)
|
|
76
|
|
|
77
|
#####
|
|
78
|
|
|
79
|
test: _not_file $(addprefix test-,$(tables))
|
|
80
|
|
|
81
|
test-%: test.%.ref test.%.out _not_file
|
|
82
|
$(DIFF)
|
|
83
|
|
|
84
|
all += $(filter-out %.ref,$(wildcard test.*.out))
|
|
85
|
|
|
86
|
#####
|
|
87
|
|
|
88
|
ifdef db
|
|
89
|
|
|
90
|
mapEnv := in_engine=$(dbEngine) in_database=$(db)
|
|
91
|
|
|
92
|
####
|
|
93
|
|
|
94
|
ifeq ($(dbEngine),MySQL)
|
|
95
|
|
|
96
|
bienPassword := $(shell cat $(root)/config/bien_password)
|
|
97
|
mysqlAs = mysql --user=$(1) --password='$(bienPassword)'
|
|
98
|
mysqlAsRoot := $(call mysqlAs,root)
|
|
99
|
mysqlAsBien := $(call mysqlAs,bien)
|
|
100
|
|
|
101
|
import-%: map.VegBIEN.%.csv _not_file
|
|
102
|
$(importCmd)
|
|
103
|
importCmd = (set -x; "time" env commit=1 $(map) $<) \
|
|
104
|
$(if $(n),,>>$(log)) 2>&1$(if $(n),|tee -a $(log))
|
|
105
|
|
|
106
|
%.ref: %.ref.sql
|
|
107
|
$(mysqlAsBien) $(db) <$< >$@
|
|
108
|
.PRECIOUS: %.ref
|
|
109
|
|
|
110
|
###
|
|
111
|
|
|
112
|
install: _not_file db
|
|
113
|
|
|
114
|
uninstall: _not_file rm_db
|
|
115
|
|
|
116
|
db: src.$(db).sql _not_file
|
|
117
|
-$(mysqlAsRoot) <$<
|
|
118
|
echo "GRANT SELECT ON $(db).* TO 'bien'@'localhost';"|$(mysqlAsRoot)
|
|
119
|
# ignore errors in db import so that GRANT will still be run
|
|
120
|
|
|
121
|
rm_db: _not_file
|
|
122
|
-echo "REVOKE ALL ON $(db).* FROM 'bien'@'localhost';"|$(mysqlAsRoot)
|
|
123
|
echo "DROP DATABASE IF EXISTS $(db);"|$(mysqlAsRoot)
|
|
124
|
# ignore errors if grant not defined
|
|
125
|
|
|
126
|
###
|
|
127
|
|
|
128
|
else
|
|
129
|
$(error dbEngine variable must be one of the following: MySQL, PostgreSQL)
|
|
130
|
endif
|
|
131
|
|
|
132
|
####
|
|
133
|
|
|
134
|
test.%.out: map.VegBIEN.%.csv _not_file
|
|
135
|
env n=2 $(map) $< >$@ 2>&1
|
|
136
|
.PRECIOUS: test.%.out
|
|
137
|
|
|
138
|
#####
|
|
139
|
|
|
140
|
else
|
|
141
|
$(error db variable must be set)
|
|
142
|
endif
|
|
143
|
|
|
144
|
#####
|
|
145
|
|
|
146
|
# Must come after mapEnv is set
|
|
147
|
map := env $(mapEnv) out_database=vegbien $(root)/map
|
