#!/bin/bash
source "$(dirname "${BASH_SOURCE[0]}")/common.sh"

../ci-pg-restore \
  --cache-name="mycache" \
  --deps-files-cmd="find . -name '*.sql'" \
  --cache-db-max-age=60 \
  --restore-db-max-age=60 \
  --dbname=ci_mydb1 \
  psql -tA -f fixtures/dump2.sql 2>&1 | prefix_tee 1 /tmp/ci_mydb1.log &

sleep 1

../ci-pg-restore \
  --cache-name="mycache" \
  --deps-files-cmd="find . -name '*.sql'" \
  --cache-db-max-age=60 \
  --restore-db-max-age=60 \
  --dbname=ci_mydb2 \
  psql -tA -f fixtures/dump2.sql 2>&1 | prefix_tee 2 /tmp/ci_mydb2.log &

wait

grep -qE "CREATE TABLE" /tmp/ci_mydb1.log
grep -qE "Someone else" /tmp/ci_mydb2.log

psql ci_mydb1 -c "SELECT * FROM abc" | grep -q myname
psql ci_mydb2 -c "SELECT * FROM abc" | grep -q myname