#!/bin/bash
# by Deniss ( deniss at fuckoff.com )

SRC_BASE=/usr2/jd
MOUNT_DIR=/usr2/jd/nw
BIN_DIR=/usr/local/pgsql/bin

if [ -x $BIN_DIR/ncpmount ]; then
        echo "Now mounting Novell..."
        $BIN_DIR/ncpmount -S novell -V sys -U naisuser -P somepassword $MOUNT_DIR
        if [ -e $MOUNT_DIR/JD2/DB/DOKUMENT.DB ];then
                /bin/rm -f $SRC_BASE/*
                echo "Coping files.."
                /bin/cp $MOUNT_DIR/JD2/DB/DOKUMENT.DB $SRC_BASE/
                /bin/cp $MOUNT_DIR/JD2/DB/DOKUMENT.MB $SRC_BASE/
                echo "Flushing database"
                export PGPASSWORD=somepassword
                $BIN_DIR/../psql stuff -c "DELETE FROM jd;"
                $BIN_DIR/../psql stuff -c "DROP INDEX pien_dat_index;"
                $BIN_DIR/../psql stuff -c "DROP INDEX id_index;"
                $BIN_DIR/../psql stuff -c "VACUUM jd;"
                /usr/bin/sleep 2m
                echo "Exporting database..."
                $BIN_DIR/nais_www_import.pl | $BIN_DIR/../psql -q nais
                echo "Creating indices..."
                $BIN_DIR/../psql nais -c "CREATE INDEX pien_dat_index ON jd (pien_dat);"
                $BIN_DIR/../psql nais -c "CREATE INDEX id_index ON jd (id);"
        fi
        echo "Unmounting Novell..."
        $BIN_DIR/ncpumount $MOUNT_DIR
        echo "Removing files..."
        /bin/rm -f $SRC_BASE/DOKUMENT.DB
        /bin/rm -f $SRC_BASE/DOKUMENT.MB
fi