prerequisites.sh

#!/bin/bash

# Check if the PostgreSQL container is already running
if [ ! "$(docker ps -q -f name=workflows-db)" ]; then
    if [ "$(docker ps -aq -f status=exited -f name=workflows-db)" ]; then
        # Cleanup
        echo "Removing existing PostgreSQL container..."
        docker rm workflows-db
    fi
    # Run the PostgreSQL container
    echo "Starting PostgreSQL container..."
    docker run --name workflows-db -e POSTGRES_PASSWORD=password123 -p 5435:5432 -d postgres:16
else
    echo "PostgreSQL container already running."
fi

# # Check if the Redis container is already running
# if [ ! "$(docker ps -q -f name=cape-fear-sis-redis)" ]; then
#     if [ "$(docker ps -aq -f status=exited -f name=cape-fear-sis-redis)" ]; then
#         # Cleanup
#         echo "Removing existing Redis container..."
#         docker rm cape-fear-sis-redis
#     fi
#     # Run the Redis container
#     echo "Starting Redis container..."
#     docker run --name cape-fear-sis-redis -p 6380:6379 -d redis redis-server --appendonly yes --requirepass super-secret-password
# else
#     echo "Redis container already running."
# fi

# Wait for PostgreSQL to start
sleep 5

# Check if the database exists, and create it if it doesn't
DB_EXISTS=$(docker exec workflows-db psql -U postgres -tc "SELECT 1 FROM pg_database WHERE datname = 'demo-controller-workflow_db'" | tr -d '[:space:]')
if [ "$DB_EXISTS" != "1" ]; then
    echo "Creating database demo-controller-workflow_db..."
    docker exec workflows-db psql -U postgres -c "CREATE DATABASE \"demo-controller-workflow_db\""
else
    echo "Database demo-controller-workflow_db already exists."
fi

echo "Database setup completed."