Subversion Repositories eFlore/Applications.del

Rev

Rev 1377 | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

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