import sqlite3
import json

# Connect to the daily_psalm cache
try:
    with sqlite3.connect('/run/media/julian/ML2/Python/bos-network/daily_psalm/els_cache.db') as conn:
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM els_cache WHERE query_hash = 'b7cff58644c289780b4a75524e5d16f29538baf5434db79a571cb8547476f05d'")
        result = cursor.fetchone()
        if result:
            print("Daily psalm query result:")
            for i, col in enumerate(result):
                print(f"Column {i}: {col}")
            if result[4]:  # Assuming results are in column 4
                try:
                    results = json.loads(result[4])
                    print("\nParsed results:")
                    for i, res in enumerate(results):
                        print(f"Result {i}:")
                        for k, v in res.items():
                            print(f"  {k}: {v}")
                except json.JSONDecodeError as e:
                    print(f"Error decoding JSON: {e}")
        else:
            print("No result found in daily_psalm cache")
except Exception as e:
    print(f"Error connecting to daily_psalm cache: {e}")

print("\n----------------\n")

# Connect to the API cache
try:
    with sqlite3.connect('els_cache.db') as conn:
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM els_cache WHERE query_hash = 'b7cff58644c289780b4a75524e5d16f29538baf5434db79a571cb8547476f05d'")
        result = cursor.fetchone()
        if result:
            print("API query result:")
            for i, col in enumerate(result):
                print(f"Column {i}: {col}")
            if result[4]:  # Assuming results are in column 4
                try:
                    results = json.loads(result[4])
                    print("\nParsed results:")
                    for i, res in enumerate(results):
                        print(f"Result {i}:")
                        for k, v in res.items():
                            print(f"  {k}: {v}")
                except json.JSONDecodeError as e:
                    print(f"Error decoding JSON: {e}")
        else:
            print("No result found in API cache")
except Exception as e:
    print(f"Error connecting to API cache: {e}")