"""
Initialize Oracle Database - Creates tables and loads embedding model.
Run once before starting FastAPI server.
"""

import sys
from pathlib import Path

# Ensure we can import oracle_service
sys.path.insert(0, str(Path(__file__).parent))

from oracle_service import ScriptureOracle

print("=" * 60)
print("Bible-Companion: Initializing Oracle Database")
print("=" * 60)

try:
    oracle = ScriptureOracle()

    print(f"\n✅ Oracle initialized successfully")
    print(f"   Database: {oracle.db_path}")
    print(f"   Data directory: {oracle.data_dir}")
    print(f"\n✅ Database tables created (if first run):")
    print(f"   - verses (Scripture passages)")
    print(f"   - oracle_facts (Doctrinal statements)")
    print(f"   - doctrinal_xrefs (OT/NT cross-references)")
    print(f"\n✅ Embedding model loaded: all-MiniLM-L6-v2")
    print(f"   Ready for semantic Scripture search")
    print(f"\n✅ In-memory index initialized and loaded from DB")
    print(f"\nNext step: Run seed_doctrinal_facts.py to populate initial facts")

except Exception as e:
    print(f"\n❌ ERROR initializing Oracle: {e}")
    import traceback
    traceback.print_exc()
    sys.exit(1)

print("=" * 60)