1#!/bin/sh
 2# PGHOST/PGDATABASE/PGUSER and PGPASSWORD configure read-only access.
 3set -eu
 4if [ "$#" -ne 1 ]; then echo 'usage: scripts/export-jellystat.sh input/history.jsonl' >&2; exit 1; fi
 5: "${PGPASSWORD:?Set PGPASSWORD in .env or export it before running this script}"
 6export PGPASSWORD
 7umask 077
 8reel_export_tmp=$(mktemp "${1}.tmp.XXXXXX")
 9trap 'rm -f "$reel_export_tmp"' EXIT HUP INT TERM
10# Disable interactive prompts; psql still reads the password from PGPASSWORD.
11psql --no-password -XqAt -v ON_ERROR_STOP=1 -f "$(dirname "$0")/jellystat-export.sql" > "$reel_export_tmp"
12mv "$reel_export_tmp" "$1"