#!/bin/bash
# ------------------------------------------------------------------
# OPERATION WHITE LABEL: DATA SANITIZATION PROTOCOL
# Formål: Klargør 'full_schema.sql' til WidgeTDC ved at fjerne forbudte navne.
# ------------------------------------------------------------------

SOURCE_FILE="./data/full_schema.sql"  # Filen fra din uploadede pakke
TARGET_DIR="./data/civic_schema"
TARGET_FILE="$TARGET_DIR/init.sql"

echo "🧹 [Scrubber] Initializing White Label Protocol..."

# 1. Opret sikker mappe til den rensede database-fil
mkdir -p "$TARGET_DIR"

if [ -f "$SOURCE_FILE" ]; then
    # 2. Udfør Scrubbing (Søg & Erstat)
    # - Erstatter 'cia_user' med 'civic_reader' (Din nye DB bruger)
    # - Erstatter 'cia' database navnet med 'civic_vault'
    # - Fjerner 'Citizen Intelligence Agency' branding
    
    sed -e 's/cia_user/civic_reader/g' \
        -e 's/cia/civic_vault/g' \
        -e 's/Citizen Intelligence Agency/Civic Insight Node/g' \
        "$SOURCE_FILE" > "$TARGET_FILE"

    echo "✅ [Scrubber] Sanitization Complete. Forbidden references removed."
    echo "📂 [Scrubber] Clean schema ready at: $TARGET_FILE"
else
    echo "⚠️ [Scrubber] SOURCE FILE NOT FOUND. Please place 'full_schema.sql' in ./data/"
fi