#!/usr/bin/env bash
# Runs ON ax42 (read-only): one usage event per library model an OMU app build vendored (.forge/library-manifest.json, written by the
# Engine's library_vendor step). Prints JSONL on stdout. usage: ssh ax42 'bash -s' < tools/usage_omu_query.sh
for m in /srv/forge/sandboxes/*/sandbox/.forge/library-manifest.json; do
  [ -f "$m" ] || continue
  slug=$(basename "$(dirname "$(dirname "$(dirname "$m")")")")
  ts=$(date -u -r "$m" +%Y-%m-%dT%H:%M:%SZ)
  python3 -c 'import json,sys
slug,ts,p=sys.argv[1:4]
try: rows=json.load(open(p))
except Exception: sys.exit(0)
for r in rows if isinstance(rows,list) else []:
    if isinstance(r,dict) and r.get("id"):
        print(json.dumps({"asset_id":r["id"],"version":r.get("version"),"release":r.get("release"),"user":slug,"platform":"omu","source":"engine-library-manifest","ts":ts},sort_keys=True))' "$slug" "$ts" "$m"
done