Admin

name	type	size	perms	modified	actions
[parent directory]
bump-version.mjs	file	2,638 B	0664	2025-08-13 01:43:33	edit
check-missing-translations.js	file	13,868 B	0664	2025-08-18 11:04:10	edit
clean-json-duplicates.js	file	3,084 B	0664	2025-08-10 10:10:29	edit
db-manage.sh	file	6,456 B	0775	2025-08-10 10:10:29	edit
merge-duplicate-keys.js	file	8,462 B	0775	2025-08-10 10:10:29	edit
overall-check.mjs	file	3,738 B	0664	2025-08-18 11:04:10	edit
scan-untranslated-jsx.cjs	file	5,509 B	0664	2025-08-11 08:17:34	edit
setup-pgadmin.sh	file	3,111 B	0775	2025-08-10 10:10:29	edit
setup-postgres.sh	file	2,116 B	0775	2025-08-10 10:10:29	edit
verify-setup.sh	file	4,816 B	0775	2025-08-10 10:10:29	edit

editing: setup-pgadmin.sh

#!/bin/bash

# Setup pgAdmin for Half Deen Series PostgreSQL
set -e

# Colors for output
RED='\033[0;31m'
GREEN='\033[0;32m'
YELLOW='\033[1;33m'
BLUE='\033[0;34m'
NC='\033[0m' # No Color

print_status() {
    echo -e "${GREEN}✅ $1${NC}"
}

print_info() {
    echo -e "${BLUE}ℹ️  $1${NC}"
}

print_warning() {
    echo -e "${YELLOW}⚠️  $1${NC}"
}

print_error() {
    echo -e "${RED}❌ $1${NC}"
}

echo "🔧 Setting up pgAdmin for Half Deen Series PostgreSQL..."
echo ""

# Check if Docker is running
if ! docker info > /dev/null 2>&1; then
    print_error "Docker is not running. Please start Docker first."
    exit 1
fi

# Start PostgreSQL if not running
if ! docker-compose ps postgres | grep -q "Up"; then
    print_info "Starting PostgreSQL container..."
    docker-compose up -d postgres
    
    # Wait for PostgreSQL to be ready
    print_info "Waiting for PostgreSQL to be ready..."
    timeout=60
    counter=0
    
    while ! docker-compose exec postgres pg_isready -U hds_user -d hds_ticketing > /dev/null 2>&1; do
        if [ $counter -ge $timeout ]; then
            print_error "PostgreSQL failed to start within $timeout seconds"
            exit 1
        fi
        echo "   Waiting... ($counter/$timeout)"
        sleep 2
        counter=$((counter + 2))
    done
    
    print_status "PostgreSQL is ready!"
else
    print_status "PostgreSQL is already running"
fi

# Start pgAdmin
print_info "Starting pgAdmin container..."
docker-compose up -d pgadmin

# Wait for pgAdmin to be ready
print_info "Waiting for pgAdmin to be ready..."
timeout=60
counter=0

while ! curl -s http://localhost:5050 > /dev/null 2>&1; do
    if [ $counter -ge $timeout ]; then
        print_error "pgAdmin failed to start within $timeout seconds"
        exit 1
    fi
    echo "   Waiting... ($counter/$timeout)"
    sleep 2
    counter=$((counter + 2))
done

print_status "pgAdmin is ready!"

echo ""
echo "🎉 pgAdmin setup completed successfully!"
echo ""
echo "📊 Access Information:"
echo "   pgAdmin URL: http://localhost:5050"
echo "   Login Email: admin@halfdeen.com"
echo "   Login Password: admin123"
echo ""
echo "🔗 PostgreSQL Connection Details:"
echo "   Server Name: HDS PostgreSQL"
echo "   Host: postgres"
echo "   Port: 5432"
echo "   Database: hds_ticketing"
echo "   Username: hds_user"
echo "   Password: hds_password"
echo ""
echo "📋 Setup Steps:"
echo "1. Open http://localhost:5050 in your browser"
echo "2. Login with admin@halfdeen.com / admin123"
echo "3. Right-click 'Servers' → Register → Server"
echo "4. General Tab: Name = 'HDS PostgreSQL'"
echo "5. Connection Tab: Use the connection details above"
echo "6. Click Save"
echo ""

# Try to open pgAdmin in browser
if command -v open &> /dev/null; then
    print_info "Opening pgAdmin in browser..."
    open http://localhost:5050
elif command -v xdg-open &> /dev/null; then
    print_info "Opening pgAdmin in browser..."
    xdg-open http://localhost:5050
else
    print_info "Please open http://localhost:5050 in your browser"
fi

echo ""
print_info "Container Status:"
docker-compose ps postgres pgadmin

cancel