import sqlite3
import json
import os

DB_PATH = r"d:\Anti Gravity\Tamil Study Bible\TamilStudy\data\bible_topics\torrey_topics.db"
JSON_PATH = r"d:\Anti Gravity\Tamil Study Bible\TamilStudy\data\bible_topics\torrey_topics.json"

def export():
    if not os.path.exists(DB_PATH):
        print("DB not found.")
        return

    conn = sqlite3.connect(DB_PATH)
    conn.row_factory = sqlite3.Row
    cursor = conn.cursor()

    topics = cursor.execute("SELECT * FROM topics").fetchall()
    data = []

    for t in topics:
        topic_id = t['id']
        name = t['name']
        url = t['url']
        
        entries = cursor.execute("SELECT point_text, verse_ref, verse_text FROM entries WHERE topic_id=?", (topic_id,)).fetchall()
        
        topic_data = {
            "name": name,
            "url": url,
            "entries": [dict(e) for e in entries]
        }
        data.append(topic_data)

    with open(JSON_PATH, 'w', encoding='utf-8') as f:
        json.dump(data, f, indent=2, ensure_ascii=False)

    print(f"Exported {len(data)} topics to JSON.")
    conn.close()

if __name__ == "__main__":
    export()