#!/usr/bin/env bash
set -euo pipefail

ROOT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")/../.." && pwd)"
COMPOSE_FILE="${COMPOSE_FILE:-$ROOT_DIR/docker-compose.demo.yml}"
SERVICE_NAME="${POSTGRES_SERVICE_NAME:-postgres}"
CONTAINER_NAME="${POSTGRES_CONTAINER_NAME:-dbtool-cli-v1-postgres-1}"
POSTGRES_USER="${POSTGRES_USER:-postgres}"
POSTGRES_DB="${POSTGRES_DB:-dbtool_demo}"

if docker compose version >/dev/null 2>&1; then
  docker compose -f "$COMPOSE_FILE" exec -T "$SERVICE_NAME" \
    psql -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$POSTGRES_DB" \
    < "$ROOT_DIR/examples/fixtures/postgres/init.sql"
else
  docker exec -i "$CONTAINER_NAME" \
    psql -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$POSTGRES_DB" \
    < "$ROOT_DIR/examples/fixtures/postgres/init.sql"
fi

echo "PostgreSQL demo data seeded into $POSTGRES_DB."