setup.sh

#!/bin/bash

set -e

echo "╔════════════════════════════════════════════════════════════╗"
echo "║          SQLive - Setup & Installation                     ║"
echo "╚════════════════════════════════════════════════════════════╝"
echo ""

# Detect OS
if [[ "$OSTYPE" == "linux-gnu"* ]]; then
    OS="linux"
elif [[ "$OSTYPE" == "darwin"* ]]; then
    OS="macos"
else
    echo "❌ Unsupported OS: $OSTYPE"
    echo "SQLive currently requires Linux (or Linux via Multipass on macOS)"
    exit 1
fi

echo "📍 Detected: $OS"
echo ""

# Install dependencies
if [ "$OS" = "linux" ]; then
    echo "📦 Installing dependencies..."
    
    # Detect Linux distro
    if command -v apt-get &> /dev/null; then
        echo "   Using apt (Ubuntu/Debian)"
        sudo apt-get update
        sudo apt-get install -y build-essential curl git bpftrace rustup
    elif command -v dnf &> /dev/null; then
        echo "   Using dnf (Fedora)"
        sudo dnf install -y gcc make curl git bpftrace rustup
    elif command -v pacman &> /dev/null; then
        echo "   Using pacman (Arch)"
        sudo pacman -S base-devel curl git bpftrace rustup
    else
        echo "❌ Unsupported package manager"
        echo "Please install manually: build tools, curl, git, bpftrace, rustup"
        exit 1
    fi
fi

echo ""
echo "🦀 Setting up Rust..."
rustup default stable
rustup update

echo ""
echo "🔨 Building SQLive..."
cd "$(dirname "$0")"
cargo build --release

echo ""
echo "📍 Installing binary..."
BINARY_PATH="$(pwd)/target/release/sqlive"

if [ "$OS" = "linux" ]; then
    sudo cp "$BINARY_PATH" /usr/local/bin/sqlive
    sudo chmod +x /usr/local/bin/sqlive
    INSTALL_PATH="/usr/local/bin/sqlive"
elif [ "$OS" = "macos" ]; then
    # On macOS, just leave it in the repo
    INSTALL_PATH="$BINARY_PATH"
    echo "⚠️  macOS detected. You'll need to run SQLive inside a Linux VM (Multipass recommended)"
    echo "   On macOS: sqlive is at $INSTALL_PATH"
fi

echo ""
echo "✓ Checking bpftrace..."
if ! command -v bpftrace &> /dev/null; then
    echo "❌ bpftrace not found!"
    echo "Please install bpftrace manually"
    exit 1
fi
echo "✓ bpftrace found: $(which bpftrace)"

echo ""
echo "✓ Checking sudo access..."
if ! sudo -n true 2>/dev/null; then
    echo "⚠️  You'll be prompted for your password when using sqlive"
fi

echo ""
echo "╔════════════════════════════════════════════════════════════╗"
echo "║          ✓ Setup Complete!                                ║"
echo "╚════════════════════════════════════════════════════════════╝"
echo ""
echo "🚀 Next steps:"
echo ""
echo "1. Compile your program with debug symbols:"
echo "   gcc -g -o myapp myapp.c"
echo ""
echo "2. Start your program:"
echo "   ./myapp &"
echo ""
echo "3. Run SQLive:"
echo "   sqlive ./myapp --functions 'function_name1,function_name2'"
echo ""
echo "4. Write SQL queries:"
echo "   sql> SELECT function, COUNT(*) FROM calls GROUP BY function;"
echo "   sql> SELECT * FROM calls LIMIT 10;"
echo ""
echo "📖 For more info: https://github.com/yourusername/sqlive"
echo ""