#!/usr/bin/env bash
# Real demos for P142 "How to Fix PostgreSQL 'Could Not Connect to Server'". Made on the Mac (Docker Desktop).
# An ice rink's small network: containers on a private Docker network with reserved RFC 1918 addresses:
#   rink-db     192.168.71.10  the rink's database server: Ubuntu 24.04's own PostgreSQL 16 (lab/Dockerfile, db)
#   rink-web    192.168.71.20  the booking website (lab/rink/app.py) and psql (lab/Dockerfile, web); its page is
#                              published on the Mac's 127.0.0.1:18142 for the browser captures
#   old-laptop  192.168.71.30  Ubuntu 20.04 with psql 12, for the older wording of the same error (lab/old)
# Every command shown is typed into a real interactive bash in a pty, one window per machine (demo_driver.py);
# every error and log line is real. SETUP_ONLY=1 builds and starts the lab and leaves it running.
set -euo pipefail
cd "$(dirname "$0")"
P=ce-p142
cleanup() {
  for b in rink-db rink-web old-laptop; do docker rm -f -v $P-$b >/dev/null 2>&1 || true; done
  docker network rm $P >/dev/null 2>&1 || true
}
cleanup
[ -n "${KEEP:-}${SETUP_ONLY:-}" ] || trap cleanup EXIT
docker build -q --target db -t $P-db lab >/dev/null
docker build -q --target web -t $P-web lab >/dev/null
docker build -q -t $P-old lab/old >/dev/null
docker network create --subnet 192.168.71.0/24 --gateway 192.168.71.254 $P >/dev/null
box() {  # box NAME IP IMAGE [extra docker args]
  local n=$1 ip=$2 img=$3; shift 3
  docker run -d --name $P-$n --hostname $n --network $P --ip $ip --privileged --cgroupns=private \
    --sysctl net.ipv6.conf.all.disable_ipv6=1 --tmpfs /run --tmpfs /run/lock "$@" $img >/dev/null
}
box rink-db 192.168.71.10 $P-db
box rink-web 192.168.71.20 $P-web -p 127.0.0.1:18142:8080
docker run -d --name $P-old-laptop --hostname old-laptop --network $P --ip 192.168.71.30 $P-old >/dev/null
for b in rink-db rink-web; do
  for i in $(seq 60); do docker exec $P-$b systemctl is-system-running 2>/dev/null | grep -qE 'running|degraded' && break; sleep 1; done
done
[ -n "${SETUP_ONLY:-}" ] && exit 0
python3 demo_driver.py $P
