1 files changed, 36 insertions, 0 deletions
diff --git a/squashr-tags-export b/squashr-tags-export
new file mode 100755
index 0000000..ef6c899
--- /dev/null
+++ b/squashr-tags-export
@@ -0,0 +1,36 @@
+#!/usr/bin/env python3
+"""squashr-tags-export — Export MedMan tags for squashr container inclusion."""
+import argparse, json, os, sys, sqlite3
+from datetime import datetime, timezone
+
+def main():
+    p = argparse.ArgumentParser(description="Export MedMan tags for squashr")
+    p.add_argument("--db", required=True, help="Path to medman.db")
+    p.add_argument("--dat", required=True, help="Comma-separated data dirs")
+    p.add_argument("--manifest", help="Path to squashr manifest file")
+    p.add_argument("--output", required=True, help="Output JSON path")
+    p.add_argument("--pretty", action="store_true")
+    a = p.parse_args()
+
+    if not os.path.isfile(a.db): print(f"Error: {a.db} not found", file=sys.stderr); sys.exit(1)
+
+    mf: set|None = None
+    if a.manifest:
+        with open(a.manifest) as f: mf = {l.strip() for l in f if l.strip()}
+
+    db = sqlite3.connect(a.db); db.row_factory = sqlite3.Row
+    rows = db.execute("""SELECT ft.hash,f.didx,f.rel,t.name AS tn FROM ftags ft JOIN tags t ON t.id=ft.tid JOIN files f ON f.hash=ft.hash ORDER BY ft.hash,t.name""").fetchall()
+    atags = db.execute("SELECT id,name FROM tags ORDER BY name").fetchall()
+    db.close()
+
+    ft = {}
+    for r in rows:
+        h = r["hash"]
+        if mf is not None and h not in mf: continue
+        ft.setdefault(h, {"didx":r["didx"],"tags":[]})["tags"].append(r["tn"])
+
+    exp = {"ts":datetime.now(timezone.utc).isoformat(),"tags":[dict(t) for t in atags],"files":ft}
+    with open(a.output,"w") as f: json.dump(exp, f, indent=2 if a.pretty else None)
+    print(f"Exported {len(ft)} files to {a.output}")
+
+if __name__ == "__main__": main()