Subversion Repositories eFlore/Applications.del

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1377 raphael 1
celdb = tb_cel_test
2
deldb = tb_del_test
3
 
4
# helper
5
do_subst = sed -e "1i--\n-- fichier d'origine: \"${1}\"\n" \
6
		   -e 's/`BASECEL`/`$(celdb)`/g' \
7
		   -e 's/`BASEDEL`/`$(deldb)`/g' \
8
		   $(1)
9
 
10
# default target
11
help:
12
	@echo "make o_maj1 [celdb=<$(celdb)>] [deldb=<$(deldb)>]"
13
 
14
clean:
15
	rm -f *.comp.sql
16
 
17
# maj1 contient: 201309-index-views.sql
18
o_maj1: fichiers_generes = $(addsuffix .comp.sql,$(filter-out clean,$?))
19
o_maj1: clean o_201309-index-views
20
	cat $(fichiers_generes) > maj1.comp.sql
21
 
1444 raphael 22
 
23
# maj1 contient: 201310-propret.sql
24
o_maj2: fichiers_generes = $(addsuffix .comp.sql,$(filter-out clean,$?))
25
o_maj2: clean o_201310-propret
26
	cat $(fichiers_generes) > maj2.comp.sql
27
 
28
 
1377 raphael 29
# SHOW INDEX FROM cel_obs WHERE Key_name = 'transmission';
30
# SHOW INDEX FROM cel_obs WHERE Key_name = 'date_transmission';
31
o_201309-index-views:
32
	$(call do_subst,201309-index-views.sql) > $@.comp.sql
1444 raphael 33
 
34
# SHOW COLUMNS FROM del_commentaire LIKE 'proposition_retenu';
35
o_201310-propret:
36
	$(call do_subst,201310-propret.sql) > $@.comp.sql