#!/bin/bash
set -euo pipefail

if [[ -f .env ]]; then
    source .env
else
    echo "ERROR: .env file not found."
    exit 1
fi

DB_CONTAINER="outline_db"
DB_USER="${POSTGRES_USER:-outline}"
DB_NAME="${POSTGRES_DB:-outline}"

echo "[INFO] Removing invitation-related events..."
docker exec -i "$DB_CONTAINER" psql -U "$DB_USER" -d "$DB_NAME" \
  -c "DELETE FROM events WHERE \"userId\" IN (SELECT id FROM users WHERE \"invitedById\" IS NOT NULL AND \"lastActiveAt\" IS NULL);"

echo "[INFO] Removing all pending invitations..."
docker exec -i "$DB_CONTAINER" psql -U "$DB_USER" -d "$DB_NAME" \
  -c "DELETE FROM users WHERE \"invitedById\" IS NOT NULL AND \"lastActiveAt\" IS NULL;"

echo "[INFO] Restarting Outline service..."
docker compose restart outline
echo "[INFO] Done. All pending invitations have been removed."