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

SRCSQLDIR = ../../src/sql
SRCXMLDIR = ../../src/xml
SRCLOG = generation.log

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

SQLFILES = crm.sql vital_generation.sql #plpgsql.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 $@

all : ${SQLFILES}

clean :
	@echo "doing $@"
	@rm -f *~ *.temp *.sql *.ok *.sdot *.dot *.pdf *.eps *.ssql *.spgml *.log
	@echo "For creating user, do 'rm createuser.ok'"
	@touch createuser.ok

install : all ${LOADFILES}

drop: 
	@echo "doing $@"
	@${DROPDB} -u ${DBUSER} -p ${DBPWD} -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG}
	@rm -f create.ok

create.ok: createuser.ok
	@echo "doing $@"
	@${CREATEDB} -u ${DBUSER} -p ${DBPWD} -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG} -E UTF8
	@touch $@

crm.ok: create.ok

vital_generation.ok: crm.ok

createuser.ok:
	@echo "doing $@"
	@read -sp 'password (postgres) : ' ; \
	${CREATEUSER} -H ${DBHOST} -u ${DBUSER} -p ${DBPWD} -U postgres -P $${REPLY} -l ${SRCLOG} -d
	@touch $@

dropuser.ok:
	@echo "doing $@"
	@read -sp 'password (postgres) : ' ; \
	${DROPUSER} -H ${DBHOST} -u ${DBUSER} -U postgres -P $${REPLY} -l ${SRCLOG}
	@touch $@

plpgsql.ok: ${SRCSQLDIR}/plpgsql.sql vital_generation.ok
	@echo "doing $@"
	@ if [ `whoami` != "root" ] then
	@read -sp 'password (postgres) : '; \
	${EXECSQL} -u postgres -p "$${REPLY}" -f ${SRCSQLDIR}/plpgsql.sql -d ${DBNAME} -H ${DBHOST} -l ${SRCLOG}
	@touch $@