| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 |
- #!/bin/bash
- set -e
- image="$1"
- testDir="$(readlink -f "$(dirname "$BASH_SOURCE")")"
- export POSTGRES_USER='my cool postgres user'
- export POSTGRES_PASSWORD='my cool postgres password'
- export POSTGRES_DB='my cool postgres database'
- cname="postgres-container-$RANDOM-$RANDOM"
- cid="$(
- docker run -d \
- -e POSTGRES_USER \
- -e POSTGRES_PASSWORD \
- -e POSTGRES_DB \
- --name "$cname" \
- -v "$testDir/initdb.sql:/docker-entrypoint-initdb.d/test.sql":ro \
- "$image"
- )"
- trap "docker rm -vf $cid > /dev/null" EXIT
- psql() {
- docker run --rm -i \
- --link "$cname":postgres \
- --entrypoint psql \
- -e PGPASSWORD="$POSTGRES_PASSWORD" \
- "$image" \
- --host postgres \
- --username "$POSTGRES_USER" \
- --dbname "$POSTGRES_DB" \
- --quiet --no-align --tuples-only \
- "$@"
- }
- : ${POSTGRES_TEST_TRIES:=10}
- : ${POSTGRES_TEST_SLEEP:=2}
- tries="$POSTGRES_TEST_TRIES"
- while ! echo 'SELECT 1' | psql &> /dev/null; do
- (( tries-- ))
- if [ $tries -le 0 ]; then
- echo >&2 'postgres failed to accept connections in a reasonable amount of time!'
- echo 'SELECT 1' | psql # to hopefully get a useful error message
- false
- fi
- echo >&2 -n .
- sleep "${POSTGRES_TEST_SLEEP}"
- done
- [ "$(echo 'SELECT COUNT(*) FROM test' | psql)" = 1 ]
- [ "$(echo 'SELECT c FROM test' | psql)" = 'goodbye!' ]
|