Project

General

Profile

« Previous | Next » 

Revision 212

Generate vegbien db create SQL from vegbank.sql using repl

View differences:

Makefile
1
all: FORCE VegX-VegBIEN.organisms.csv
1
all: FORCE VegBank-VegBIEN
2 2
	$(MAKE) plots
3 3
	./join VegX VegBank
4 4
	./join VegX VegBIEN
......
9 9
all =\
10 10
$(wildcard for_review/*.csv) \
11 11
$(filter-out VegX-% VegBank-%,$(wildcard *-VegBank.*.csv)) \
12
VegX-*.plots.csv VegX-VegBIEN.organisms.csv
12
VegX-*.plots.csv VegX-VegBIEN.organisms.csv schemas/vegbien.sql
13 13

  
14 14
clean: FORCE
15 15
	$(RM) $(all)
16 16

  
17 17

  
18
VegX-VegBIEN.organisms.csv: VegX-VegBank.organisms.csv VegBank-VegBIEN.csv
19
	../scripts/util/repl <$+ 1 >$@
18
VegBank-VegBIEN: schemas/vegbien.sql VegX-VegBIEN.organisms.csv
20 19

  
20
repl = ../scripts/util/repl <$< VegBank-VegBIEN.csv$(if $(filter %.csv,$<), 1) \
21
>$@
21 22

  
23
schemas/vegbien.sql: schemas/vegbank.sql
24
	$(repl)
25

  
26
VegX-VegBIEN.organisms.csv: VegX-VegBank.organisms.csv
27
	$(repl)
28

  
29

  
22 30
plots: $(subst .organisms.,.plots.,$(wildcard VegX-*.organisms.csv))
23 31

  
24 32
chRoot = ../scripts/util/ch_root <$< >$@

Also available in: Unified diff