#!/bin/bash
set -euo pipefail

ACTION="${1:-}"
if [ "$#" -ne 1 ]; then
  echo '{"error":"expected exactly one action"}' >&2
  exit 64
fi

ROLE='protect_access_log_migration'
PSQL='/usr/bin/psql'
RUNUSER='/usr/sbin/runuser'
SYSTEMCTL='/bin/systemctl'
PG_DROPCLUSTER='/usr/bin/pg_dropcluster'
READLINK='/usr/bin/readlink'
STAT='/usr/bin/stat'
TR='/usr/bin/tr'
ACCESS_CLUSTER_CONFIG='/etc/postgresql/14/access'
ACCESS_CLUSTER_DATA='/srv/postgresql/14/access'

run_psql() {
  local port="$1"
  local database="$2"
  local sql="$3"
  "$RUNUSER" -u postgres -- "$PSQL" --no-psqlrc -X -v ON_ERROR_STOP=1 -p "$port" -d "$database" -c 'SET statement_timeout = 15000' -c "$sql"
}

prepare_source() {
  local port="$1"
  local database="$2"
  if ! run_psql "$port" "$database" "SELECT 1" >/dev/null 2>&1; then
    return 1
  fi
  run_psql "$port" "$database" "DO \$\$ BEGIN IF NOT EXISTS (SELECT 1 FROM pg_roles WHERE rolname = '$ROLE') THEN CREATE ROLE $ROLE LOGIN NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT NOREPLICATION; END IF; END \$\$; GRANT CONNECT ON DATABASE \"$database\" TO $ROLE; GRANT USAGE ON SCHEMA public TO $ROLE; GRANT SELECT ON TABLE public.json_systemlog TO $ROLE" >/dev/null
}

remove_source() {
  local port="$1"
  local database="$2"
  run_psql "$port" "$database" "REVOKE ALL PRIVILEGES ON TABLE public.json_systemlog FROM $ROLE; REVOKE USAGE ON SCHEMA public FROM $ROLE; REVOKE CONNECT ON DATABASE \"$database\" FROM $ROLE" >/dev/null 2>&1 || true
}

validate_fixed_directory() {
  local directory="$1"
  local label="$2"
  local resolved
  local owner
  if [ -L "$directory" ] || [ ! -d "$directory" ]; then
    echo "{\"error\":\"fixed Access $label directory is missing or is a symlink\"}" >&2
    exit 1
  fi
  resolved="$("$READLINK" -f -- "$directory")"
  if [ "$resolved" != "$directory" ]; then
    echo "{\"error\":\"fixed Access $label directory resolves outside its expected path\"}" >&2
    exit 1
  fi
  owner="$("$STAT" -c '%U:%G' -- "$directory")"
  if [ "$owner" != 'root:root' ] && [ "$owner" != 'postgres:postgres' ]; then
    echo "{\"error\":\"fixed Access $label directory has unexpected ownership\"}" >&2
    exit 1
  fi
}

validate_access_cluster_paths() {
  local running_data_directory
  validate_fixed_directory "$ACCESS_CLUSTER_CONFIG" 'configuration'
  validate_fixed_directory "$ACCESS_CLUSTER_DATA" 'data'
  running_data_directory="$("$RUNUSER" -u postgres -- "$PSQL" --no-psqlrc -X -v ON_ERROR_STOP=1 -p 5435 -d postgres -tAc 'SHOW data_directory' | "$TR" -d '[:space:]')"
  if [ "$running_data_directory" != "$ACCESS_CLUSTER_DATA" ]; then
    echo '{"error":"port 5435 uses an unexpected PostgreSQL data directory"}' >&2
    exit 1
  fi
}

cleanup_retained_access() {
  # An absent cluster is the idempotent success case. If its fixed config still exists,
  # require the fixed port to answer before deleting anything so a stopped/broken retained
  # source is never mistaken for an already-cleaned source.
  if [ ! -d "$ACCESS_CLUSTER_CONFIG" ]; then
    if run_psql 5435 postgres "SELECT 1" >/dev/null 2>&1; then
      echo '{"error":"port 5435 is active without the fixed Access cluster config"}' >&2
      exit 1
    fi
    echo '{"accessExternal":"absent","cluster":"absent"}'
    return
  fi
  if ! run_psql 5435 postgres "SELECT 1" >/dev/null 2>&1; then
    "$SYSTEMCTL" start postgresql-cluster@14-access.service >/dev/null 2>&1
  fi
  run_psql 5435 postgres "DO \$\$ BEGIN IF current_setting('port') <> '5435' THEN RAISE EXCEPTION 'unexpected PostgreSQL port'; END IF; END \$\$" >/dev/null
  validate_access_cluster_paths
  remove_source 5435 access_syslog
  run_psql 5435 postgres "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'access_syslog' AND pid <> pg_backend_pid()" >/dev/null
  run_psql 5435 postgres 'DROP DATABASE IF EXISTS "access_syslog"' >/dev/null
  run_psql 5435 postgres "DROP ROLE IF EXISTS access_syslog; DROP ROLE IF EXISTS $ROLE" >/dev/null
  "$SYSTEMCTL" stop postgresql-cluster@14-access.service >/dev/null 2>&1 || true
  validate_fixed_directory "$ACCESS_CLUSTER_CONFIG" 'configuration'
  validate_fixed_directory "$ACCESS_CLUSTER_DATA" 'data'
  "$PG_DROPCLUSTER" --stop 14 access >/dev/null
  echo '{"accessExternal":"removed","cluster":"retired"}'
}

case "$ACTION" in
  prepare-read-access)
    prepare_source 5432 ulp-go-syslog || { echo '{"ulp":"unreadable"}'; exit 1; }
    if prepare_source 5435 access_syslog; then echo '{"ulp":"available","accessExternal":"available"}'; else echo '{"ulp":"available","accessExternal":"absent"}'; fi
    ;;
  remove-read-role)
    remove_source 5432 ulp-go-syslog
    remove_source 5435 access_syslog
    run_psql 5432 postgres "DROP ROLE IF EXISTS $ROLE" >/dev/null 2>&1 || true
    run_psql 5435 postgres "DROP ROLE IF EXISTS $ROLE" >/dev/null 2>&1 || true
    echo '{"removed":true}'
    ;;
  cleanup-retained-access)
    cleanup_retained_access
    ;;
  *) echo '{"error":"unsupported action"}' >&2; exit 64 ;;
esac
