#this bash script executes SQL code from .sql files

DATABASE_NAME="nobody"
SQL_PATH="/usr/local/pgsql/bin"
SQL_FILES=$(ls *.sql *.noauto)

rm -f sql_input.sql


# OPTIONAL !!
#/etc/rc.d/init.d/httpd stop
#$SQL_PATH/dropdb nobody
#$SQL_PATH/createdb nobody
#/etc/rc.d/init.d/httpd start 

rm sql_messages.log sql_errors.log

touch sql.total

for filename in $SQL_FILES ; do
cat $filename >> sql.total
printf "\n" >> sql.total
#echo "executing SQL for" $filename | tee -a sql_messages.log sql_errors.log
#./sql_run.pl $filename >>sql_messages.log 2>>sql_errors.log
done

./sql_run.pl sql.total >>sql_messages.log 2>>sql_errors.log

rm -f sql.total

PERLINIT=$(ls co_set*.pl | sort)
for filename in $PERLINIT ; do
echo "executing perl init in " $filename | tee -a sql_messages.log sql_errors.log
./$filename >>sql_messages.log 2>>sql_errors.log
done

echo "analizing and cleaning"
vacuumdb --verbose --analyze  nobody
