#!/bin/bash

# Start the container (if not already running)
docker start socialize-postgres 2>/dev/null || docker run \
  --cap-add SYS_PTRACE \
  -e POSTGRES_USER=sa \
  -e POSTGRES_PASSWORD='P@ssword123!' \
  -p 5433:5432 \
  --name socialize-postgres \
  -d postgres:latest

# Wait until Postgres is ready
echo "Waiting for Postgres to be ready..."
until docker exec socialize-postgres pg_isready -U sa >/dev/null 2>&1; do
  sleep 1
done

# Create databases if they don't exist
echo "Ensuring development databases exist..."

docker exec -e PGPASSWORD='P@ssword123!' socialize-postgres \
  sh -lc "psql -U sa -d postgres -tAc \"SELECT 1 FROM pg_database WHERE datname='socialize'\" | grep -q 1 || createdb -U sa socialize"

echo "✅ Done."