#!/bin/sh
set -eu

case "${MARIADB_USER:-}" in
    ''|*[!A-Za-z0-9_]* )
        echo 'MARIADB_USER contains unsupported characters' >&2
        exit 1
        ;;
esac

BUSINESS_MIRROR_DATABASE="${BUSINESS_MIRROR_DATABASE:-caiwu_business_mirror}"

case "$BUSINESS_MIRROR_DATABASE" in
    ''|*[!A-Za-z0-9_]* )
        echo 'BUSINESS_MIRROR_DATABASE contains unsupported characters' >&2
        exit 1
        ;;
esac

mariadb --protocol=socket -uroot -p"$MARIADB_ROOT_PASSWORD" <<SQL
CREATE DATABASE IF NOT EXISTS \`$BUSINESS_MIRROR_DATABASE\`
    CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON \`$BUSINESS_MIRROR_DATABASE\`.* TO \`$MARIADB_USER\`@'%';
ALTER USER \`$MARIADB_USER\`@'%' REQUIRE SSL;
FLUSH PRIVILEGES;
SQL