"""Debug script to check metadata entries."""
from app.core.database import db_manager

db_manager.connect()
db_manager.build_metadata_index()

print(f"Total metadata entries: {len(db_manager.metadata)}")
print(f"Unique symbols: {len(db_manager.symbols)}")

# Show unique sources
sources = set(m["source"] for m in db_manager.metadata)
print(f"Sources found: {sources}")

# Show EURUSD 1hr entries
eurusd = [m for m in db_manager.metadata if m["symbol"] == "EURUSD" and m["timeframe"] == "1hr"]
print(f"\nEURUSD 1hr entries: {len(eurusd)}")
for m in eurusd:
    print(f"  source={m['source']}  path={m['relative_path']}")

# Show a few sample paths  
print("\nFirst 5 paths:")
for m in db_manager.metadata[:5]:
    print(f"  {m['relative_path']}")