clean.sh

#!/bin/bash
# Clean databases and cache for fresh start
set -e

echo "🧹 Cleaning databases..."

# Stop Neo4j
echo "Stopping Neo4j..."
neo4j stop 2>/dev/null || true
sleep 2

# Clear Neo4j data
echo "Clearing Neo4j data..."
rm -rf /var/lib/neo4j/data/databases/neo4j
rm -rf /var/lib/neo4j/data/transactions/neo4j

# Start Neo4j
echo "Starting Neo4j..."
neo4j start
sleep 5

# Clear ClickHouse
echo "Clearing ClickHouse..."
clickhouse-client --query "DROP DATABASE IF EXISTS default"
clickhouse-client --query "CREATE DATABASE default"

# Re-initialize schemas
echo "Initializing ClickHouse schemas..."
cd /workspace/apollo
clickhouse-client --multiquery < onchain.sql
clickhouse-client --multiquery < offchain.sql

# Clear downloaded data
echo "Clearing downloaded epoch data..."
rm -rf /workspace/apollo/data/pump_fun/epoch_*
rm -rf /workspace/apollo/data/pump_fun/socials

# Clear cache
echo "Clearing cache..."
rm -rf /workspace/apollo/data/cache/*

echo "✅ All clean! Ready for fresh ingest."