webapp/_inspect_db.py

import sqlite3

conn = sqlite3.connect(r"f:\_Ai\Tipitaka-AI-Expert\RAG\tipitaka_mcu.db")
cursor = conn.cursor()

# Volumes
print("=== VOLUMES ===")
cursor.execute("SELECT * FROM volumes ORDER BY volume_number LIMIT 5")
for row in cursor.fetchall():
    print(f"  id={row[0]}, vol={row[1]}, title={row[2]}, pitaka={row[3]}, pages={row[4]}")

cursor.execute("SELECT COUNT(*) FROM volumes")
print(f"\nTotal volumes: {cursor.fetchone()[0]}")

# Pages sample
print("\n=== PAGES (sample vol_id=1) ===")
cursor.execute("SELECT id, volume_id, page_number, LENGTH(content_text), LENGTH(content_html) FROM pages WHERE volume_id=1 LIMIT 3")
for row in cursor.fetchall():
    print(f"  id={row[0]}, vol_id={row[1]}, page={row[2]}, text_len={row[3]}, html_len={row[4]}")

cursor.execute("SELECT COUNT(*) FROM pages")
print(f"Total pages: {cursor.fetchone()[0]}")

# Contents (TOC)
print("\n=== CONTENTS/TOC (sample vol_id=1) ===")
cursor.execute("SELECT * FROM contents WHERE volume_id=1 ORDER BY page_number LIMIT 5")
for row in cursor.fetchall():
    print(f"  id={row[0]}, vol_id={row[1]}, title={row[2][:60]}, page={row[3]}, level={row[4]}")

cursor.execute("SELECT COUNT(*) FROM contents")
print(f"Total TOC entries: {cursor.fetchone()[0]}")

# Pitaka distribution
print("\n=== PITAKA DISTRIBUTION ===")
cursor.execute("SELECT pitaka, COUNT(*), SUM(total_pages) FROM volumes GROUP BY pitaka")
for row in cursor.fetchall():
    print(f"  {row[0]}: {row[1]} volumes, {row[2]} pages")

conn.close()