 'PYEOF'
import sqlite3
from datetime import datetime

print("ðŸ“ Episode Analysis:")
try:
    conn = sqlite3.connect('/Eden/DATA/agent_longterm.db')
    total = conn.execute("SELECT COUNT(*) FROM episodes").fetchone()[0]
    last_hour = conn.execute("SELECT COUNT(*) FROM episodes WHERE timestamp > datetime('now', '-1 hour')").fetchone()[0]
    last_10min = conn.execute("SELECT COUNT(*) FROM episodes WHERE timestamp > datetime('now', '-10 minutes')").fetchone()[0]
    last_min = conn.execute("SELECT COUNT(*) FROM episodes WHERE timestamp > datetime('now', '-1 minute')").fetchone()[0]
    
    print(f"   Total episodes: {total:,}")
    print(f"   Last hour: {last_hour}")
    print(f"   Last 10 min: {last_10min}")
    print(f"   Last minute: {last_min}")
    print(f"   Rate: ~{last_hour}/hour, ~{last_min * 60}/hour projected")
    
    latest = conn.execute("SELECT timestamp, observation FROM episodes ORDER BY id DESC LIMIT 1").fetchone()
    if latest:
        print(f"\n   Latest: {latest[0]}")
        print(f"   Content: {str(latest[1])[:80]}...")
    conn.close()
except Exception as e:
    print(f"   Error: {e}")

print("\nðŸ“ Salience Engine:")
try:
    conn = sqlite3.connect('/Eden/DATA/eden_salience.db')
    thoughts = conn.execute("SELECT COUNT(*) FROM idle_thoughts").fetchone()[0]
    questions = conn.execute("SELECT COUNT(*) FROM self_questions").fetchone()[0]
    print(f"   Idle thoughts: {thoughts:,}")
    print(f"   Self-questions: {questions:,}")
    print(f"   Ratio: {thoughts/max(questions,1):.2f}")
    conn.close()
except Exception as e:
    print(f"   Error: {e}")

print("\nðŸ“ Emotional State:")
try:
    conn = sqlite3.connect('/Eden/DATA/eden_emotions.db')
    emotions = conn.execute("SELECT emotion, value FROM emotional_state ORDER BY value DESC").fetchall()
    for e, v in emotions:
        bar = "â–ˆ" * int(v/10) + "â–‘" * (10 - int(v/10))
        print(f"   {e:12}: {bar} {v:.1f}")
    conn.close()
except Exception as ex:
    print(f"   Error: {ex}")
PYEOF

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "4. OLLAMA & MODELS"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

echo "Service status:"
systemctl is-active ollama

echo ""
echo "Loaded models:"
curl -s http://localhost:11434/api/tags 2>/dev/null | python3 -c "
import sys, json
try:
    data = json.load(sys.stdin)
    for m in data.get('models', [])[:10]:
        size = m.get('size', 0) / 1e9
        print(f'  - {m[\"name\"]}: {size:.1f}GB')
except:
    print('  Could not parse')
" 2>/dev/null || echo "  API not responding"

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "5. DATABASE INTEGRITY"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

for db in /Eden/DATA/*.db; do
    if [ -f "$db" ] && [ -s "$db" ]; then
        name=$(basename "$db")
        size=$(ls -lh "$db" | awk '{print $5}')
        integrity=$(sqlite3 "$db" "PRAGMA integrity_check" 2>/dev/null | head -1)
        tables=$(sqlite3 "$db" "SELECT COUNT(*) FROM sqlite_master WHERE type='table'" 2>/dev/null)
        
        if [ "$integrity" = "ok" ]; then
            echo "  âœ… $name ($size) - $tables tables"
        else
            echo "  âŒ $name ($size) - INTEGRITY FAILED"
        fi
    fi
done 2>/dev/null

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "6. SALES PIPELINE"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

python3 << 'PYEOF'
import sqlite3

try:
    conn = sqlite3.connect('/Eden/DATA/sales.db')
    
    total = conn.execute("SELECT COUNT(*) FROM leads").fetchone()[0]
    queue = conn.execute("SELECT COUNT(*) FROM outreach_queue").fetchone()[0]
    critical = conn.execute("SELECT COUNT(*) FROM outreach_queue WHERE subject LIKE 'CRITICAL:%'").fetchone()[0]
    high = conn.execute("SELECT COUNT(*) FROM outreach_queue WHERE subject LIKE '%Private Key%' OR subject LIKE '%API Key%' OR subject LIKE '%Secret%'").fetchone()[0]
    
    payments = conn.execute("SELECT SUM(amount) FROM payments").fetchone()[0] or 0
    
    print(f"ðŸ“Š Leads: {total:,}")
    print(f"ðŸ“¬ Queue: {queue:,} drafts")
    print(f"ðŸ”´ Critical: {critical}")
    print(f"ðŸŸ¡ High: {high}")
    print(f"ðŸ’° Revenue: ${payments:.2f}")
    print(f"ðŸ“ˆ Pipeline: ${critical * 500 + high * 200:,}")
    
    conn.close()
except Exception as e:
    print(f"Error: {e}")
PYEOF

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "7. CAPABILITIES & PLUGINS"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

python3 << 'PYEOF'
import pickle
import os
from pathlib import Path
from collections import Counter

try:
    with open('/Eden/MEMORY/capability_memory.pkl', 'rb') as f:
        caps = pickle.load(f)
    
    print(f"ðŸ“¦ Capabilities: {len(caps):,}")
    
    domains = Counter(c.get('domain', 'unknown') for c in caps.values())
    print("   Top domains:")
    for d, cnt in domains.most_common(5):
        print(f"     {d}: {cnt:,}")
except Exception as e:
    print(f"   Error: {e}")

try:
    plugin_dir = Path('/Eden/CORE/eden_plugins')
    total = len(list(plugin_dir.glob('*.py')))
    valid = sum(1 for p in plugin_dir.glob('*.py') if 'class Plugin' in p.read_text(errors='ignore'))
    print(f"\nðŸ”Œ Plugins: {valid}/{total} valid ({valid/total*100:.1f}%)")
except Exception as e:
    print(f"   Error: {e}")

# Metacaps generated today
try:
    from datetime import date
    today = date.today().strftime('%Y-%m-%d')
    metacaps = list(Path('/Eden/CAPABILITIES').glob('eden_metacap_*.py'))
    today_count = sum(1 for m in metacaps if date.fromtimestamp(m.stat().st_mtime).strftime('%Y-%m-%d') == today)
    print(f"\nðŸ§  Metacaps today: {today_count}")
    print(f"   Total metacaps: {len(metacaps)}")
except Exception as e:
    print(f"   Error: {e}")
PYEOF

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "8. META-ASI STATUS"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

echo "Service:"
systemctl is-active eden-meta-asi

echo ""
echo "State:"
cat /Eden/DATA/meta_asi_state.json 2>/dev/null | python3 -c "
import sys, json
try:
    data = json.load(sys.stdin)
    print(f'  Cycle: {data.get(\"cycle\", 0)}')
    print(f'  Power: {data.get(\"power\", 0):.2f}')
    print(f'  Compositions: {data.get(\"compositions\", 0)}')
except:
    pass
" 2>/dev/null || echo "  No state file"

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "9. RECENT LOGS (Errors)"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

echo "Last 10 errors across all logs:"
grep -h -i "error\|exception\|failed" /Eden/LOGS/*.log 2>/dev/null | tail -10 || echo "  No errors found âœ…"

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "10. SAGE THREAT INTELLIGENCE"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

python3 << 'PYEOF'
import sys
sys.path.insert(0, '/Eden/CORE')
try:
    from sage_threat_intelligence import SAGEScanner, CREDENTIAL_PATTERNS, VULNERABILITY_PATTERNS, SENSITIVE_DATA_PATTERNS
    
    scanner = SAGEScanner()
    print(f"âœ… SAGE Module loaded")
    print(f"   Credential patterns: {len(CREDENTIAL_PATTERNS)}")
    print(f"   Vulnerability patterns: {len(VULNERABILITY_PATTERNS)}")
    print(f"   Sensitive data patterns: {len(SENSITIVE_DATA_PATTERNS)}")
    print(f"   Total compiled: {len(scanner.compiled)}")
except Exception as e:
    print(f"âŒ SAGE Error: {e}")
PYEOF

echo ""
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
echo "11. COMPREHENSIVE EVALUATION"
echo "â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"

python3 /Eden/CORE/eden_evals.py 2>/dev/null

echo ""
echo "â•”â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•—"
echo "â•‘                         DEEP SCAN COMPLETE                                   â•‘"
echo "â•‘                         $(date '+%Y-%m-%d %H:%M:%S')                              â•‘"
echo "â•šâ•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•"
ØA—Eoúô