#!/bin/zsh
# Usage: q.sh <outname> "<SELECT ...>"   -- read-only D1 query, JSON saved to raw/<outname>.json
set -e
A=${RPB_AUDIT_DIR}
case "$2" in
  [Ss][Ee][Ll][Ee][Cc][Tt]*|[Ww][Ii][Tt][Hh]*) ;;
  *) echo "refusing non-SELECT" >&2; exit 2;;
esac
cd ${PROJECT_ROOT}/worker
source ${CLOUDFLARE_ENV_SH} >/dev/null 2>&1
mkdir -p $A/raw
printf '%s\n' "$2" > $A/raw/$1.sql
npx wrangler d1 execute rp-bench-db --remote --json --command "$2" > $A/raw/$1.json 2> $A/raw/$1.err