#!/bin/sh


sqldir="/usr/share/jobrepository/sql"
dbapwd=;

install() {
    user_dbapwd_question $1;

    query="\. $sqldir/jobrep-create-basic.sql";
    query_exec "root" "$dbapwd" "$query";
    
    query="\. jobrep-create-CE.sql";
    query_exec "root" "$dbapwd" "$query";
}

destroy() {
    user_dbapwd_question $1;

    query="\. $sqldir/jobrep-drop-total-database.sql";
    query_exec "root" "$dbapwd" "$query";
}

show() {
    user_dbapwd_question $1;

    query="show databases";
    query_exec "root" "$dbapwd" "$query" "jobrepository";

    query="show tables";
    query_exec "root" "$dbapwd" "$query" "jobrepository";
}




user_dbapwd_question () {

    if [ -r "$1" ]; then
        if [ -s "$1" ]; then
            dbapwd=`cat $1`;
        else
            read -s -p "Enter database password (root): " dbapwd;
            echo;
        fi
    else
        read -s -p "Enter database password (root): " dbapwd;
        echo;
    fi
}


query_exec () {
    # Parameter list:
    # 1: dbauser
    # 2: dbapwd
    # 3: query
    ## 4: database

    if [ "$4" != "" ]; then
        if [ "$2" != "" ];
        then
            mysql -u$1 -p$2 -D $4 -e "$3";
        else
            mysql -u$1 -D $4 -e "$3";
        fi
    else
        if [ "$2" != "" ];
        then
            mysql -u$1 -p$2 -e "$3";
        else
            mysql -u$1 -e "$3";
        fi
    fi
}


case "$1" in
    install)
        install $2;
        ;;
    destroy)
        destroy $2;
        ;;
    show)
        show $2;
        ;;
    *)
        echo $"Usage:  $0  install  [<db password file>]"
        echo $"Usage:  $0  destroy  [<db password file>]"
        echo $"Usage:  $0  show     [<db password file>]"

        exit 1
        ;;
esac
