from pathlib import Path
import sqlite3

BASE = Path(__file__).resolve().parent.parent
VIDEOS_DB = BASE / "temp" / "videos.db"
MEDIA_DIR = BASE / "temp" / "media"

print(f"VIDEOS_DB: {VIDEOS_DB} (exists={VIDEOS_DB.exists()})")
if VIDEOS_DB.exists():
    conn = sqlite3.connect(str(VIDEOS_DB))
    conn.row_factory = sqlite3.Row
    cur = conn.cursor()
    try:
        # Llistar només les columnes que ens interessen ara mateix
        cur.execute("SELECT video_name, sha1sum FROM videos")
        rows = cur.fetchall()
        print("\n[VIDEOS.DB] Registres (video_name, sha1sum):")
        for r in rows:
            print(f"  - video_name={r['video_name']!r}, sha1sum={r['sha1sum']!r}")
    except Exception as e:
        print("Error llegint videos.db:", e)
    finally:
        conn.close()
else:
    print("videos.db no existeix")

print(f"\nMEDIA_DIR: {MEDIA_DIR} (exists={MEDIA_DIR.exists()})")
if MEDIA_DIR.exists():
    subdirs = [p.name for p in sorted(MEDIA_DIR.iterdir()) if p.is_dir()]
    print("[MEDIA] Subcarpetes a demo/temp/media:")
    for name in subdirs:
        print("  -", name)
else:
    print("Directori media no existeix")