celdb = tb_cel_test
deldb = tb_del_test

# helper
do_subst = sed -e "1i--\n-- fichier d'origine: \"${1}\"\n" \
		   -e 's/`BASECEL`/`$(celdb)`/g' \
		   -e 's/`BASEDEL`/`$(deldb)`/g' \
		   $(1)

# default target
help:
	@echo "make o_maj1 [celdb=<$(celdb)>] [deldb=<$(deldb)>]"

clean:
	rm -f *.comp.sql

# maj1 contient: 201309-index-views.sql
o_maj1: fichiers_generes = $(addsuffix .comp.sql,$(filter-out clean,$?))
o_maj1: clean o_201309-index-views
	cat $(fichiers_generes) > maj1.comp.sql


# maj1 contient: 201310-propret.sql
o_maj2: fichiers_generes = $(addsuffix .comp.sql,$(filter-out clean,$?))
o_maj2: clean o_201310-propret
	cat $(fichiers_generes) > maj2.comp.sql


# SHOW INDEX FROM cel_obs WHERE Key_name = 'transmission';
# SHOW INDEX FROM cel_obs WHERE Key_name = 'date_transmission';
o_201309-index-views:
	$(call do_subst,201309-index-views.sql) > $@.comp.sql

# SHOW COLUMNS FROM del_commentaire LIKE 'proposition_retenu';
o_201310-propret:
	$(call do_subst,201310-propret.sql) > $@.comp.sql