#!/usr/bin/env bash
# Refresh EMEA Q1 GM/CEO brief source queries.
# Usage:
#   export GOOGLE_APPLICATION_CREDENTIALS=/path/to/bigquery-service-account-key.json
#   export REGIONAL_SUPPORT_DSN='mysql://user:pass@host:4000/regional_support'
#   ./emea-q1-2026-gm-ceo-brief-refresh.sh

set -euo pipefail

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
SQL_FILE="${SCRIPT_DIR}/emea-q1-2026-gm-ceo-brief.sql"
OUT_DIR="${SCRIPT_DIR}/.brief-refresh-$(date +%Y%m%d)"

mkdir -p "$OUT_DIR"

if [[ -z "${GOOGLE_APPLICATION_CREDENTIALS:-}" ]]; then
  echo "Set GOOGLE_APPLICATION_CREDENTIALS to run BigQuery Part A." >&2
  exit 1
fi

echo "Running BigQuery Part A → ${OUT_DIR}/bq-a1-matrix.json"
# Extract first query block (A1) — run full file sections manually if needed.
sed -n '1,/^-- ── A2/p' "$SQL_FILE" | sed '/^-- ── A2/d' | \
  bq --project_id=gcp-martech-infra --location=us-west2 query \
    --use_legacy_sql=false --format=prettyjson > "${OUT_DIR}/bq-a1-matrix.json"

if [[ -n "${REGIONAL_SUPPORT_DSN:-}" ]]; then
  echo "Running TiDB Part B → ${OUT_DIR}/tidb-ops.txt"
  awk '/^-- PART B/{found=1} found && !/^-- PART B/' "$SQL_FILE" | \
    mysql "$REGIONAL_SUPPORT_DSN" > "${OUT_DIR}/tidb-ops.txt" 2>&1 || true
else
  echo "Skip TiDB: REGIONAL_SUPPORT_DSN not set."
fi

echo "Done. Outputs in ${OUT_DIR}"