#!/bin/sh
# Seed для теста миграции 006 (idempotent: 001 содержит DROP TABLE)
set -e
cd /root/vector
for f in backend/migrations/001_create_cases_table.sql backend/migrations/002_add_detailed_fields.sql backend/migrations/003_create_users_and_analysis_log.sql; do
  docker exec -i vec-mig-pg psql -U postgres -d vector_mchs < "$f" 2>&1 | grep -i "error" && exit 1 || true
done
docker exec vec-mig-pg psql -U postgres -d vector_mchs <<'SQL'
INSERT INTO cases (id, age_years, status, analysis_log) VALUES
 ('11111111-1111-4111-8111-000000000001', 10, 'active', '{"primary_zones": [{"priority": 1, "name": "З"}], "urgency": "высокая", "max_distance_km": 5.4}'::jsonb),
 ('11111111-1111-4111-8111-000000000002', 12, 'new', '[{"legacy": true}]'::jsonb),
 ('11111111-1111-4111-8111-000000000003', 8, 'active', NULL);
SQL
echo "--- cases seeded:"
docker exec vec-mig-pg psql -U postgres -d vector_mchs -t -c "SELECT count(*) FROM cases;"
echo "--- analysis_log types:"
docker exec vec-mig-pg psql -U postgres -d vector_mchs -t -c "SELECT id, jsonb_typeof(analysis_log) FROM cases;"