#!/bin/sh
# Simple script to manage the nuxeo h2 Visible Sql Storage
#
H2PATH=$(cd $(dirname $0)/../server/default/lib/; pwd -P)
H2JAR=h2-$(cd $H2PATH; echo `ls h2-*|cut -d"-" -f2- `)
DBPATH=$(cd $(dirname $0)/../server/default/data/h2; pwd -P)

main() {
    case $1 in
        backup)
            zip_file=nuxeo-h2-$(date +"%Y%m%d-%H%M%S").zip
            echo "### Backuping h2 visible sql storage to $zip_file ... \c"
            java -cp "$H2PATH/$H2JAR" org.h2.tools.Script -url jdbc:h2:$DBPATH/nuxeo -user sa -script $zip_file  -options compression zip || exit 1
            echo "Done."
            ;;

        shell)
            java -cp "$H2PATH/$H2JAR" org.h2.tools.Shell -url jdbc:h2:$DBPATH/nuxeo -user sa || exit 1
            ;;

        restore)
            shift;
            zip_file=$1; shift
            echo "### Restoring h2 visible sql storage $zip_file"
            if [ -e $DBPATH ]; then
                backupdb=$DBPATH-$(date +"%Y%m%d-%H%M%S")-bak
                echo "### Moving existing db to $backupdb"
                mv $DBPATH $backupdb || exit 1
            fi
            mkdir -p $DBPATH
            java -cp "$H2PATH/$H2JAR" org.h2.tools.RunScript -url jdbc:h2:$DBPATH/nuxeo -user sa -script $zip_file  -options compression zip || exit 1
            ;;

        analyze)
            echo "### Optimizing h2 visible sql storage"
            java -cp "$H2PATH/$H2JAR" org.h2.tools.Shell -url jdbc:h2:$DBPATH/nuxeo -user sa <<EOF
ANALYZE;
quit
EOF
            ;;
        help|-help|-h|\?|--help)
            echo "### Nuxeo h2 utility command"
            echo "h2 (backup|restore DUMP.ZIP|analyze|shell)"
            ;;
        *)
            echo "Abort, invalid options $0 --help."
            exit 1
        ;;
    esac
}

main $@

