#!/bin/bash
# probe 후 indoor_pose_guide / indoor_pose_underlay capture 행 검증.
EID="fbf15266-989c-4cc8-8d82-699ea5f628aa"
echo "=== indoor pose capture rows (role count) ==="
PGPASSWORD=theroad_dev_2026 psql -h localhost -U theroad -d theroad -c "
SELECT pipeline_role, disposition, is_intermediate, count(*)
FROM image_asset
WHERE episode_id='$EID' AND pipeline_role IN ('indoor_pose_guide','indoor_pose_underlay')
GROUP BY pipeline_role, disposition, is_intermediate ORDER BY pipeline_role;"

echo "=== lineage (input_image_ids) + unresolved ==="
PGPASSWORD=theroad_dev_2026 psql -h localhost -U theroad -d theroad -c "
SELECT pipeline_role, id, input_image_ids, pipeline_metadata_json->>'group_id' AS grp,
       pipeline_metadata_json->'unresolved_inputs' AS unresolved
FROM image_asset
WHERE episode_id='$EID' AND pipeline_role IN ('indoor_pose_guide','indoor_pose_underlay')
ORDER BY pipeline_role LIMIT 12;"

echo "=== input_image_ids dangling check (가리키는 asset 존재?) ==="
PGPASSWORD=theroad_dev_2026 psql -h localhost -U theroad -d theroad -c "
SELECT a.pipeline_role, u.uid,
       (SELECT count(*) FROM image_asset b WHERE b.id = u.uid::uuid) AS resolved
FROM image_asset a, jsonb_array_elements_text(a.input_image_ids) AS u(uid)
WHERE a.episode_id='$EID' AND a.pipeline_role IN ('indoor_pose_guide','indoor_pose_underlay')
LIMIT 12;"