import-sql.sh

#!/bin/bash
set -e

echo "🚀 Starting PostgreSQL container..."
docker compose up -d db

echo "⏳ Waiting for PostgreSQL to be ready..."
until docker exec $(docker compose ps -q db) pg_isready -U postgres > /dev/null 2>&1; do
  sleep 1
done

echo "✅ PostgreSQL is ready."

echo "📦 Creating database..."
echo "🔍 Checking if database 'workflow_realm00000' exists..."
if docker exec -i $(docker compose ps -q db) psql -U postgres -tAc "SELECT 1 FROM pg_database WHERE datname = 'workflow_realm00000'" | grep -q 1; then
  echo "✅ Database 'workflow_realm00000' already exists."
else
  echo "➕ Creating database 'workflow_realm00000'..."
  docker exec -i $(docker compose ps -q db) psql -U postgres -c "CREATE DATABASE workflow_realm00000;"
fi

echo "🚚 Importing from data from dump"
docker exec -i $(docker compose ps -q db) psql -U postgres -d workflow_realm00000 < ./workflow.sql

docker compose down
echo "✅ Done!"