#!/bin/sh
set -e

. /usr/share/debconf/confmodule

db_get yms/db-name
DB_NAME="$RET"

db_get yms/db-user
DB_USER="$RET"

db_get yms/db-password
DB_PASSWORD="$RET"

echo "Configuring YMS..."
echo "Checking MariaDB database '${DB_NAME}'..."

if mariadb -N -B -e "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '${DB_NAME}'" | grep -Fxq "${DB_NAME}"; then
    echo "Database '${DB_NAME}' already exists."
else
    echo "Database '${DB_NAME}' does not exist."
    echo "Creating database '${DB_NAME}'..."
    mariadb -e "CREATE DATABASE \`${DB_NAME}\`"
    echo "Database '${DB_NAME}' created."
    echo "Initializing database schema..."
    mariadb "${DB_NAME}" < /usr/share/yms/db/mariadb.sql
    mariadb "${DB_NAME}" < /usr/share/yms/db/minimal.sql
    echo "Database schema initialized."
fi
exit 0
