start_postgres.sh

#!/bin/bash

# PostgreSQL Startup Script for Arrest Data Application

echo "=== PostgreSQL Startup Script ==="
echo ""

# Check if Docker is running
if ! docker info > /dev/null 2>&1; then
    echo "❌ Docker is not running. Please start Docker and try again."
    exit 1
fi

echo "✅ Docker is running"

# Check if docker-compose is available
if ! command -v docker-compose &> /dev/null; then
    echo "❌ docker-compose is not installed. Please install Docker Compose."
    exit 1
fi

echo "✅ Docker Compose is available"

# Start PostgreSQL container
echo ""
echo "🚀 Starting PostgreSQL container..."
docker-compose up -d postgres

# Wait for PostgreSQL to be ready
echo "⏳ Waiting for PostgreSQL to be ready..."
sleep 10

# Check if PostgreSQL is running
if docker-compose ps postgres | grep -q "Up"; then
    echo "✅ PostgreSQL container is running"
else
    echo "❌ PostgreSQL container failed to start"
    echo "Check logs with: docker-compose logs postgres"
    exit 1
fi

# Check if we can connect to PostgreSQL
echo "🔍 Testing PostgreSQL connection..."
if python -c "
import psycopg2
try:
    conn = psycopg2.connect(
        host='localhost',
        port=5432,
        database='arrest_data',
        user='arrest_user',
        password='arrest_password'
    )
    conn.close()
    print('✅ PostgreSQL connection successful')
except Exception as e:
    print(f'❌ PostgreSQL connection failed: {e}')
    exit(1)
"; then
    echo "✅ PostgreSQL is ready for connections"
else
    echo "❌ Cannot connect to PostgreSQL"
    exit 1
fi

echo ""
echo "🎉 Setup complete! You can now start your application:"
echo "   python run_server.py"
echo ""
echo "📊 To view PostgreSQL logs: docker-compose logs postgres"
echo "🛑 To stop PostgreSQL: docker-compose down"
echo "🔄 To restart PostgreSQL: docker-compose restart postgres"