setup_sync_tool.sh

#!/bin/bash
# Cruise Logs Sync Tool - Setup Script
# This script sets up the sync tool in a new environment

set -e

# Configuration
TOOL_NAME="Cruise Logs Sync Tool"
REQUIRED_FILES=(
    "cruise_logs_sync.py"
    "sync_cruise_logs.sh"
    "sync_diagnostic.py"
    "find_sync_differences.py"
    "requirements_sync.txt"
    "SYNC_TOOL_FILES.md"
)

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

# Functions
print_banner() {
    echo -e "${BLUE}=====================================================${NC}"
    echo -e "${BLUE}🚢 CRUISE LOGS SYNC TOOL - SETUP SCRIPT 🚢${NC}"
    echo -e "${BLUE}=====================================================${NC}"
    echo ""
}

print_step() {
    echo -e "${BLUE}[STEP]${NC} $1"
}

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

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

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

check_requirements() {
    print_step "Checking system requirements..."

    # Check for Python 3
    if ! command -v python3 &> /dev/null; then
        print_error "Python 3 is required but not installed"
        echo "Please install Python 3.6 or later and try again"
        exit 1
    fi

    PYTHON_VERSION=$(python3 --version | cut -d' ' -f2)
    print_success "Python 3 found: $PYTHON_VERSION"

    # Check for pip
    if ! command -v pip3 &> /dev/null && ! command -v pip &> /dev/null; then
        print_error "pip is required but not installed"
        echo "Please install pip and try again"
        exit 1
    fi

    print_success "pip found"

    # Check for bash
    if ! command -v bash &> /dev/null; then
        print_error "bash is required but not installed"
        exit 1
    fi

    print_success "bash found"
}

check_files() {
    print_step "Checking for required files..."

    local missing_files=()

    for file in "${REQUIRED_FILES[@]}"; do
        if [[ -f "$file" ]]; then
            print_success "Found: $file"
        else
            print_warning "Missing: $file"
            missing_files+=("$file")
        fi
    done

    if [[ ${#missing_files[@]} -gt 0 ]]; then
        print_error "Missing ${#missing_files[@]} required files"
        echo "Please ensure all files are in the current directory:"
        for file in "${missing_files[@]}"; do
            echo "  - $file"
        done
        exit 1
    fi

    print_success "All required files found"
}

install_dependencies() {
    print_step "Installing Python dependencies..."

    if [[ -f "requirements_sync.txt" ]]; then
        if command -v pip3 &> /dev/null; then
            pip3 install -r requirements_sync.txt
        else
            pip install -r requirements_sync.txt
        fi
        print_success "Python dependencies installed"
    else
        print_warning "requirements_sync.txt not found, installing manually"
        if command -v pip3 &> /dev/null; then
            pip3 install pymysql
        else
            pip install pymysql
        fi
        print_success "pymysql installed"
    fi
}

setup_permissions() {
    print_step "Setting up file permissions..."

    # Make Python scripts executable
    chmod +x cruise_logs_sync.py 2>/dev/null || true
    chmod +x sync_cruise_logs.sh 2>/dev/null || true

    if [[ -f "sync_diagnostic.py" ]]; then
        chmod +x sync_diagnostic.py 2>/dev/null || true
    fi

    if [[ -f "find_sync_differences.py" ]]; then
        chmod +x find_sync_differences.py 2>/dev/null || true
    fi

    print_success "File permissions set"
}

check_databases() {
    print_step "Checking database access..."

    # Check SQLite database
    SQLITE_DB="$HOME/Github/Cruise_Logs/Cruise_Logs.db"
    if [[ -f "$SQLITE_DB" ]]; then
        print_success "SQLite database found: $SQLITE_DB"
    else
        print_warning "SQLite database not found: $SQLITE_DB"
        echo "Make sure the Cruise_Logs repository is cloned and the database exists"
    fi

    # Test MariaDB connectivity (optional)
    print_success "Database checks completed"
}

test_installation() {
    print_step "Testing installation..."

    # Test the shell launcher
    if [[ -f "sync_cruise_logs.sh" ]]; then
        if ./sync_cruise_logs.sh help &> /dev/null; then
            print_success "Shell launcher working"
        else
            print_warning "Shell launcher test failed"
        fi
    fi

    # Test Python imports
    if python3 -c "import pymysql, sqlite3, hashlib, json" 2>/dev/null; then
        print_success "Python dependencies working"
    else
        print_warning "Python dependency test failed"
    fi

    print_success "Installation test completed"
}

create_shortcut() {
    print_step "Creating convenience shortcuts..."

    # Create a simple wrapper script
    cat > cruise_sync << 'EOF'
#!/bin/bash
# Convenience wrapper for Cruise Logs Sync Tool
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
"$SCRIPT_DIR/sync_cruise_logs.sh" "$@"
EOF

    chmod +x cruise_sync
    print_success "Created 'cruise_sync' shortcut"
}

print_usage() {
    echo ""
    echo -e "${BLUE}🎉 SETUP COMPLETE!${NC}"
    echo ""
    echo "The Cruise Logs Sync Tool is now ready to use."
    echo ""
    echo -e "${YELLOW}Quick Start:${NC}"
    echo "  ./sync_cruise_logs.sh help      # Show help"
    echo "  ./sync_cruise_logs.sh status    # Check sync status"
    echo "  ./sync_cruise_logs.sh dry-run   # Preview changes"
    echo "  ./sync_cruise_logs.sh sync      # Perform sync"
    echo ""
    echo "Or use the convenience shortcut:"
    echo "  ./cruise_sync status"
    echo "  ./cruise_sync dry-run"
    echo "  ./cruise_sync sync"
    echo ""
    echo -e "${YELLOW}Diagnostics:${NC}"
    echo "  python3 sync_diagnostic.py [table]"
    echo "  python3 find_sync_differences.py [table]"
    echo ""
    echo -e "${YELLOW}Documentation:${NC}"
    echo "  cat SYNC_TOOL_FILES.md"
    echo ""
    echo -e "${GREEN}Happy syncing! 🌊${NC}"
}

# Main execution
main() {
    print_banner

    # Parse command line arguments
    while [[ $# -gt 0 ]]; do
        case $1 in
            --skip-deps)
                SKIP_DEPS=1
                shift
                ;;
            --help)
                echo "Usage: $0 [--skip-deps] [--help]"
                echo "  --skip-deps    Skip Python dependency installation"
                echo "  --help         Show this help message"
                exit 0
                ;;
            *)
                print_error "Unknown option: $1"
                echo "Use --help for usage information"
                exit 1
                ;;
        esac
    done

    # Run setup steps
    check_requirements
    check_files

    if [[ -z "$SKIP_DEPS" ]]; then
        install_dependencies
    else
        print_warning "Skipping dependency installation (--skip-deps)"
    fi

    setup_permissions
    check_databases
    test_installation
    create_shortcut

    print_usage
}

# Run main function
main "$@"