include ../rules/make.rules

ARCHIVE=../archive/dumpBaseClients
ARCHIVEIMGCHQDIR=../archive/img_chq
IMGCHQDIR=/var/www/pimengest/gestion/admin/img_chq/
DATAARCHIVE=dumpData.psql
STRUCTARCHIVE=dumpStruct.psql

PSQLFILES=${wildcard *.psql}

all:

install: load_postinstall.ok

load_schema.ok: load_functions.ok cleanStruct.psql
	@echo "doing $@"
	@exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f cleanStruct.psql -o ${LOG} -l ${LOG}
	@date > $@

load_functions.ok: load_preinstall.ok functions.psql
	@echo "doing $@"
	@exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f functions.psql -o ${LOG} -l ${LOG}
	@date > $@

load_postinstall.ok: load_schema.ok postInstall.psql
	@echo "doing $@"
	@exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f postInstall.psql -o ${LOG} -l ${LOG}
	@date > $@

load_preinstall.ok: create-db.ok preInstall.psql
	@echo "doing $@"
	@exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f preInstall.psql -o ${LOG} -l ${LOG}
	@date > $@

cleanStruct.psql: ${STRUCTARCHIVE}
	@echo "doing $@"
	@grep -v "Username: Password:" $< | grep -v "\\connect - pimentech" > $@ 

clean:
	@echo "doing $@"
	@rm -f *~ *.ok

createuser.ok:
	@echo "doing $@"
	@su - postgres -c "(echo ${DBPWD};echo ${DBPWD};echo n) | createuser  -h ${DBHOST} -P -d ${DBUSER}"
	@date > $@

dropuser:
	@echo "doing $@"
	@su - postgres -c "dropuser -h ${DBHOST} ${DBUSER}"

destroy-db: 
	@echo "doing $@"
	@destroy-db.sh -u ${DBUSER} -p "${DBPWD}" -d ${DBNAME} -H ${DBHOST} -l ${LOG}

create-db.ok: createuser.ok
	@echo "doing $@"
	create-db.sh -u ${DBUSER} -p "${DBPWD}" -d ${DBNAME} -H ${DBHOST} -l ${LOG}
	@date > $@

remove-data:
	@echo "Removing datas"
	@while true ; do \
		OUTPUT=`${PURGE} ${DBNAME} ${DBUSER}` ; \
		if [ -z "$${OUTPUT}" ] ; \
		then break ; \
		fi ; \
	done
	@echo "DB purged."

install-data:
	@echo "Installing datas..."
	@exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f ${ARCHIVE} -o ${LOG} -l ${LOG}
	@echo "New DB installed."

install-db:
	@echo "Installing DB..."
	@for i in ${PSQLFILES} ; do \
		exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f $${i} -o ${LOG} -l ${LOG} ; \
	done

mig-db:
	@echo "Installing DB..."
	exec-sql.sh -H ${DBHOST} -d ${DBNAME} -u ${DBUSER} -p "${DBPWD}" -f mig1-0_1-1.sql -o ${LOG} -l ${LOG} ; \

dump-all:
	@echo 'Archivage de la base...'
	@(echo ${DBUSER}; echo ${DBPWD})| pg_dump -u -D ${DBNAME} > ${ARCHIVE}
	@echo 'Archivage des images cheques...'
	cp -uf ${IMGCHQDIR}/* ${ARCHIVEIMGCHQDIR}
	@echo Done.

dump-data:
	@echo 'Sauvegarde des données...'
	@${DUMPDATA} -o ${DATAARCHIVE}
	@echo Done.

dump-structdata:
	@echo 'Sauvegarde de la structure de la base...'
	@${DUMPSTRUCT} -o ${STRUCTARCHIVE}
	@echo Done.