import os
import requests
from dotenv import load_dotenv

load_dotenv()

# ArcadeDB connection settings
ARCADE_USER = os.getenv("ARCADE_USER", "root")
ARCADE_PASS = os.getenv("ARCADE_PASSWORD")
ARCADE_DB = os.getenv("ARCADE_DB", "BhashyamDB")
ARCADE_HOST = os.getenv("ARCADE_HOST")
ARCADE_URL = f"http://{ARCADE_HOST}:2480/api/v1/command/{ARCADE_DB}"
AUTH = (ARCADE_USER, ARCADE_PASS)

def run_cypher(query: str):
    payload = {
        "language": "opencypher",
        "command": query
    }
    response = requests.post(ARCADE_URL, json=payload, auth=AUTH)
    if response.status_code == 200:
        return response.json().get("result", [])
    else:
        print(f"Error: {response.text}")
        return []

if __name__ == "__main__":
    print(f"📚 Scriptures in ArcadeDB ({ARCADE_DB}):")
    query = "MATCH (s:Scripture) RETURN s.name, s.title ORDER BY s.name"
    scriptures = run_cypher(query)
    
    if not scriptures:
        print("⚠️ No scriptures found.")
    else:
        for s in scriptures:
            print(f" - {s.get('s.name')} ({s.get('s.title')})")