# Generated automatically from Makefile.in by configure.
#this makefile executes SQL code from .sql files

APACHECTL=/etc/rc.d/init.d/httpd
DATABASE_NAME='nobody'
DATABASE_CONNECTION_STRING='dbname=nobody'
VACUUMDB=vacuumdb --verbose --analyze
DROPDB=dropdb
CREATEDB=createdb
CREATELANG=createlang
DUMPDB=pg_dump
PSQL=psql
top_srcdir = ..

all:
	$(MAKE) install-sql 
	$(MAKE) perl-init
	$(MAKE) analyze
##	$(MAKE) dbbackup


install-sql:
	@(rm sql_messages.log sql_errors.log || echo 'Log files not found')
	for filename in `LC_ALL=C ls *.sql *.noauto` ; do \
	  echo "executing SQL for $$filename" | tee -a sql_messages.log sql_errors.log ; \
	  ./sql_run.pl $(DATABASE_CONNECTION_STRING) $$filename >>sql_messages.log 2>>sql_errors.log ; \
	done

perl-init:
	for filename in `ls LC_ALL=C co_set*.pl` ; do \
	  echo "executing perl init in " $$filename | tee -a sql_messages.log sql_errors.log ; \
	  ./$$filename $(DATABASE_CONNECTION_STRING) >>sql_messages.log 2>>sql_errors.log ; \
	done

analyze:
	echo "analizing and cleaning"
	$(VACUUMDB) $(DATABASE_NAME)

dbclean:
	# stop all known clients
	$(APACHECTL) stop || echo ""
	##killall -vw psql
	# recreate empty database
	$(DROPDB) $(DATABASE_NAME)
	$(CREATEDB) $(DATABASE_NAME)
	$(CREATELANG) plpgsql $(DATABASE_NAME)

dbbackup:
	find_data=${top_srcdir}/scripts/find_data ; \
	  tar -cf dbbackup.tar `$$find_data`

dbdump:
	$(DUMPDB) $(DATABASE_NAME) > database.dump

dbrestore: dbclean
	$(PSQL) -d $(DATABASE_NAME) -f database.dump

psql:
	$(PSQL) -d $(DATABASE_NAME)
include ${top_srcdir}/Makefile.global
