# 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'
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 -1 *.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 `LC_ALL=C ls -1 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 --verbose --analyze $(DATABASE_NAME)

dbclean:
	# stop all known clients
	$(APACHECTL) stop || echo "Cannot stop httpd"
	##killall -vw psql
	# recreate empty database
	dropdb $(DATABASE_NAME)
	createdb $(DATABASE_NAME)

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

dbdump:
	pg_dump $(DATABASE_NAME) > database.dump

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

include ${top_srcdir}/Makefile.global
