Spaces:
Sleeping
Sleeping
File size: 2,249 Bytes
e8510d3 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 | 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}")
|