#! /bin/sh

VERSION="1.1.1"
SCRIPT_NAME="DB Create"

. /usr/src/m2/framework/bash_functions.sh

k_start
k_mysql_version

function db_create(){

    report "Starting fresh DB import" 3

    report "Initializing DB" 3
    if [[ $MYSQL_VERSION1 == 8 ]]; then
        /usr/bin/mysql -h localhost -u root --password=kolmisoft < /usr/src/m2/db/init8.sql 2>&1 | grep -v "Using a password"
    else
        /usr/bin/mysql -h localhost -u root --password=kolmisoft < /usr/src/m2/db/init.sql 2>&1 | grep -v "Using a password"
    fi

    report "Importing initial data" 3
    /usr/bin/mysql -h localhost -u m2 --password=m2 m2 < /usr/src/m2/db/m2.sql 2>&1 | grep -v "Using a password"

    # done by db_update.sh
    #report "Updating triggers" 3
    #/usr/bin/mysql -h localhost -u m2 --password=m2 m2 < /usr/src/m2/db/triggers.sql 2>&1 | grep -v "Using a password"

    # this is done in install.sh as db_update.sh LATEST
    #report "Updating DB" 3
    #/usr/src/m2/db/db_update.sh STABLE

    report "New DB created" 0
}

if [ "$1" == "NEW" ]
then
    db_create
else
    get_answer "Are you sure you really want new DB?" "n"
    if [ "$answer" == "y" ]; then
        db_create
    else
        report "New DB not created" 2
    fi
fi

k_exit $EXIT_CODE