#!/usr/bin/env bash
# Corre las 4 RPCs de carga de Programa de obra contra Postgres local.
set -euo pipefail
ROOT="$(cd "$(dirname "$0")/.." && pwd)"
PSQL="${PSQL:-psql}"
URL="${1:-}"

if [[ -z "$URL" ]]; then
  echo "uso: $0 postgresql://user@host:port/db" >&2
  exit 2
fi

TMP="$(mktemp /tmp/wp-load-XXXXXX.sql)"
{
  cat "$ROOT/scripts/verify-work-program-load.sql"
  sed -n '/^CREATE OR REPLACE FUNCTION core.fn_work_program_list_concepts/,/^\$\$;$/p' \
    "$ROOT/db/core/changesets/030-rpc-work-program.sql"
  sed -n '/^CREATE OR REPLACE FUNCTION core.fn_work_program_list_partidas/,/^\$\$;$/p' \
    "$ROOT/db/core/changesets/030-rpc-work-program.sql"
  sed -n '/^CREATE OR REPLACE FUNCTION core.fn_work_program_get/,/^\$\$;$/p' \
    "$ROOT/db/core/changesets/037-fn-work-program-get-curve-vrow.sql"
  sed -n '/^CREATE OR REPLACE FUNCTION core.fn_work_program_vs_cost/,/^\$\$;$/p' \
    "$ROOT/db/core/changesets/038-fn-work-program-vs-cost.sql"
  cat "$ROOT/scripts/verify-work-program-load-seed.sql"
} > "$TMP"
chmod 644 "$TMP"

"$PSQL" "$URL" -v ON_ERROR_STOP=1 -f "$TMP"
rm -f "$TMP"
echo "verify-work-program-load: OK"