| 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
|