#!/usr/bin/env bash
set -euo pipefail
DB="${FIYAT_RADAR_DB:-/var/lib/fiyat-radar/fiyat-radar.sqlite}"
echo '=== VARYANT ONAY KUYRUGU ==='
sqlite3 -header -column "$DB" "
SELECT
  vp.id,
  pf.id AS family_id,
  COALESCE(pf.name,vp.name) AS family_name,
  vp.capacity_gb,
  vp.proposed_color AS color,
  ROUND(COALESCE(vp.confidence,0)*100,1) AS confidence_pct,
  vp.evidence_count,
  vp.evidence_type,
  vp.status,
  vp.created_at,
  substr(vp.source_url,1,100) AS source_url
FROM variant_proposals vp
LEFT JOIN product_families pf
  ON pf.family_key=vp.family_key
 AND pf.condition_type=vp.condition_type
ORDER BY CASE vp.status WHEN 'pending' THEN 0 WHEN 'approved' THEN 1 ELSE 2 END,
         vp.confidence DESC,vp.id DESC
LIMIT 100;
"
echo
echo '=== SAYACLAR ==='
sqlite3 -header -column "$DB" "SELECT status,COUNT(*) AS count FROM variant_proposals GROUP BY status ORDER BY status;"