include ../../rules/make.rules
GLOBALFILE=globals.mak
include ../../config/${GLOBALFILE}

SRCSQLDIR = ../../src/sql
SRCLSTDIR = ../../src/lst
SRCXMLDIR = ../../src/xml
SRCLOG = chargement.log

VPATH=.:${SRCLSTDIR}:${SRCSQLDIR}:${SRCXMLDIR}

LSTFILES = profil.lst statut.lst type_template.lst profil_societe.lst fonction.lst type_action.lst activite_societe.lst type_origine.lst type_cible.lst type_contact.lst type_reduction.lst mode_paiement.lst delai_paiement.lst hobby.lst
SQLFILES = tables.sql ${LSTFILES:.lst=.sql} vital_chargement.sql 
LOADFILES = ${SQLFILES:.sql=.ok}

.sql.ok:
	@echo "loading $@"
	@exec-sql.sh -u ${DBUSER} -p ${DBPWD} -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG} -f $< -o /dev/null
	@touch $@

.lst.sql:
	@echo "doing `basename $@`"
	@echo "delete from `basename $< .lst` where uid <> 0;" > $@
	@export table=`basename $< .lst`; sed '/^$$/d' $< | \
	awk -F'|' "BEGIN { OFS=\"','\" } { print \"insert into $${table} (uid, zid, ztitle, codecrea) \
	values ('\"\$$1, \$$2, \$$3, \"Makefile');\" }" >> $@

all: ${SQLFILES}

clean:
	@echo "doing $@"
	@rm -rf *.ok *.lst *.sql *~ *.log *.tmp*

install: all ${LOADFILES}

tables.lst: crm.sql
	@echo "doing $@"
	@grep "CREATE TABLE" $< | sed -e 's/CREATE TABLE //' -e 's/ (//' > $@

tables.sql: tables.lst
	@echo "doing $@"
	@for table in `awk -F'|' '{ print $$1 }' $<` ; \
	do \
		echo "delete from only $${table} where uid=0;" >> $@ ; \
		echo "insert into $${table} (uid, codecrea) values (0, 'Makefile');" >> $@ ; \
	done

vital_chargement.ok: setval.ok tables.ok

setval.ok:
	@echo "doing $@"
	@exec-sql.sh -u ${DBUSER} -p ${DBPWD} -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG} -c "select setval('object_uid_seq',max(uid)+1) from object*" -o /dev/null
	@touch $@

exemple.ok: exemple.sql
	@echo "doing $@"
	@exec-sql.sh -u ${DBUSER} -p ${DBPWD} -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG} -f $< -o /dev/null
	@touch $@

indicateur.ok: indicateur.sql
	@echo "doing $@"
	@exec-sql.sh -u ${DBUSER} -p ${DBPWD} -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG} -f $< -o /dev/null
	@touch $@