#!/bin/bash
# NEMS Linux Database Initialization & Repair Engine

set -e

DB_DIR="/usr/local/share/nems/database"
SCHEMA_DIR="/usr/share/nems-ncc/schema"
RESET=0

# Parse optional CLI flags
for arg in "$@"; do
    case $arg in
        --reset|--force)
            RESET=1
            shift
            ;;
        --help|-h)
            echo "Usage: nems-db-init [--reset]"
            echo "  --reset   Wipes and re-initializes databases to factory defaults."
            exit 0
            ;;
    esac
done

echo "===> NEMS Linux Database Manager <==="

# Ensure database directory exists
if [ ! -d "$DB_DIR" ]; then
    mkdir -p "$DB_DIR"
fi

# Correct early file location of NCC History database if needed
if [ -f /usr/local/share/nems/ncc/ncc_history.db ] && [ ! -L /usr/local/share/nems/ncc/ncc_history.db ]; then
    if [ ! -f "$DB_DIR/ncc_history.db" ]; then
        echo "[+] Migrating legacy ncc_history.db and sidecars to $DB_DIR..."
        /usr/bin/systemctl stop nems-ncc 2>/dev/null || true

        # Move main db AND any active WAL/SHM files to the new folder
        mv /usr/local/share/nems/ncc/ncc_history.db* "$DB_DIR/" 2>/dev/null || true

        # Symlink ONLY the main database file back to the old location
        ln -s "$DB_DIR/ncc_history.db" /usr/local/share/nems/ncc/ncc_history.db

        /usr/bin/systemctl start nems-ncc 2>/dev/null || true
    fi
fi

# Handle --reset flag
if [ "$RESET" -eq 1 ]; then
    echo "[!] WARNING: --reset flag passed. Removing existing SQLite databases..."
    rm -f "$DB_DIR"/nems_config.db* "$DB_DIR"/nems_audit.db*
fi

# Initialize Configurator Database (nems_config.db)
if [ ! -f "$DB_DIR/nems_config.db" ]; then
    echo "[+] Initializing nems_config.db..."
    if ! (
        sqlite3 "$DB_DIR/nems_config.db" < "$SCHEMA_DIR/nems_config.sql" && \
        { [ ! -f "$SCHEMA_DIR/base.sql" ] || sqlite3 "$DB_DIR/nems_config.db" < "$SCHEMA_DIR/base.sql"; } && \
        sqlite3 "$DB_DIR/nems_config.db" "PRAGMA journal_mode=WAL;"
    ); then
        echo "[-] ERROR: Failed to initialize nems_config.db! Cleaning up incomplete files..." >&2
        rm -f "$DB_DIR"/nems_config.db*
        exit 1
    fi
    echo "[+] nems_config.db initialized successfully."
else
    echo "[*] nems_config.db already exists. Skipping creation."
fi

# Initialize Audit Log Database (nems_audit.db)
if [ ! -f "$DB_DIR/nems_audit.db" ]; then
    echo "[+] Initializing nems_audit.db..."
    if ! (
        sqlite3 "$DB_DIR/nems_audit.db" < "$SCHEMA_DIR/nems_audit.sql" && \
        sqlite3 "$DB_DIR/nems_audit.db" "PRAGMA journal_mode=WAL;"
    ); then
        echo "[-] ERROR: Failed to initialize nems_audit.db! Cleaning up incomplete files..." >&2
        rm -f "$DB_DIR"/nems_audit.db*
        exit 1
    fi
    echo "[+] nems_audit.db initialized successfully."
else
    echo "[*] nems_audit.db already exists. Skipping creation."
fi

# Apply permissions across all database files
chown -R www-data:www-data "$DB_DIR"
chmod 775 "$DB_DIR"
chmod 664 "$DB_DIR"/*.db* 2>/dev/null || true

echo "[+] Database check completed successfully!"
exit 0
