debug_export.py

import requests
import sqlite3
import json
import os

DB_PATH = "data/db/mediavault.db"
API_URL = "http://localhost:8001/api" # Try 8001 as per history

def check_db_json():
    print(f"--- Checking DB {DB_PATH} ---")
    conn = sqlite3.connect(DB_PATH)
    cursor = conn.cursor()
    
    # Check dataset items
    cursor.execute("SELECT id, annotations FROM dataset_items LIMIT 5")
    rows = cursor.fetchall()
    print(f"Found {len(rows)} items sample:")
    for row in rows:
        print(f"ID: {row[0]}, Ann: {row[1]}")
    
    # Check json_each support
    try:
        cursor.execute("SELECT DISTINCT key FROM dataset_items, json_each(dataset_items.annotations)")
        keys = cursor.fetchall()
        print(f"Direct SQL JSON keys: {keys}")
    except Exception as e:
        print(f"SQL JSON Error: {e}")
        
    conn.close()

def check_api():
    print(f"\n--- Checking API {API_URL} ---")
    try:
        # List datasets
        r = requests.get(f"{API_URL}/datasets/")
        if r.status_code != 200:
            print(f"List Datasets failed: {r.status_code}")
            return
            
        data = r.json()
        datasets = data.get("datasets", [])
        if not datasets:
            print("No datasets found via API")
            return
            
        ds_id = datasets[0]["id"]
        print(f"Testing Dataset ID: {ds_id} ({datasets[0]['name']})")
        
        # Get fields
        r = requests.get(f"{API_URL}/datasets/export-fields?dataset_id={ds_id}")
        print(f"Export Fields Response ({r.status_code}): {r.text}")
        
    except Exception as e:
        print(f"API Error: {e}")

if __name__ == "__main__":
    check_db_json()
    check_api()