#!/bin/bash
# Installazione DB Morse sul Raspberry (una tantum)
# Uso: cd /var/www/miosito/morse && sudo bash install_db.sh

set -e
DIR="$(cd "$(dirname "$0")" && pwd)"
cd "$DIR"

echo "=== Creazione database morse e utenti ==="
sudo mariadb < setup_db.sql

echo "=== Verifica connessione morseuser ==="
mariadb -u morseuser -p'Gnappognappo232!!!morse' morse -e "SELECT 'OK morseuser' AS status;"

echo "=== Verifica connessione writeuser ==="
mariadb -u writeuser -p'Gnappognappo232!!!d' morse -e "SELECT 'OK writeuser' AS status;" 2>/dev/null || echo "(writeuser: salta se password diversa)"

echo ""
echo "Fatto. Apri nel browser:"
echo "  http://$(hostname -I | awk '{print $1}')/morse/migrate.php?key=mig_morse_2026"