#!/bin/bash

set -eu
[ "$#" -eq 1 ] || (echo "Usage: $0 db_name"; exit 1)

# CHANGEME
cd /paas-bootstrap

docker pull postgres:9.5-alpine
db_hostname=$(
    aws s3 cp s3://gds-paas-${DEPLOY_ENV}-state/cf.tfstate - \
    | jq -r '.modules[].outputs["cf_db_address"].value' \
)

db_password=$(
    concourse/scripts/val_from_yaml.rb \
    secrets_cf_db_master_password \
    <(aws s3 cp s3://gds-paas-${DEPLOY_ENV}-state/cf-secrets.yml -) \
)

TUNNEL=5432:${db_hostname}:5432
export TUNNEL

make tunnel
trap 'make stop-tunnel' EXIT

docker run --rm -ti \
    -e PGPASSWORD="${db_password}" \
    postgres:9.5-alpine \
    psql \
        --host=docker.for.mac.localhost \
        --username=dbadmin \
        --dbname="$1"