update-dump.sh

#!/bin/bash

PG_HOST_PORT=${1:-"6432"}
SPOKE_DB="spoke"

echo "Spinning up Postgres Docker container..."

# Start the container in the background
CONTAINER_ID=$(docker container run -d  \
  --cap-add SYS_RESOURCE \
  --platform linux/amd64 \
  -p $PG_HOST_PORT:5432  \
  -e ALLOW_NOSSL=true \
  -e POSTGRES_DB=postgres \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=zalando \
  registry.opensource.zalan.do/acid/spilo-14:2.1-p6)


retVal=$?
if [ $retVal -ne 0 ]; then
  echo "Failed to start container"
  exit $retVal
fi

# Crude wait for container to be ready
export DATABASE_URL=postgres://postgres:zalando@127.0.0.1:$PG_HOST_PORT/postgres
echo "Waiting for container to be ready..."
until psql --no-psqlrc $DATABASE_URL -c 'select 1' 2>/dev/null 1>/dev/null; do
  sleep 0.2
done
echo -e "Container is ready. Running migrations...\n"

psql --no-psqlrc $DATABASE_URL -c "create database $SPOKE_DB;";
export DATABASE_URL=postgres://postgres:zalando@127.0.0.1:$PG_HOST_PORT/$SPOKE_DB

# Run the migrations against the temporary Docker container
NODE_ENV=production yarn migrate:worker && NODE_ENV=production yarn knex migrate:latest

# Dump the schema using the pegged pg_dump version in the container
docker exec -e PGPASSWORD=zalando $CONTAINER_ID pg_dump -U postgres -d $SPOKE_DB --schema-only  \
  --schema public \
  > ./schema-dump.sql

docker kill $CONTAINER_ID 1>/dev/null