#!/bin/bash
# Extract all kiwifruit companies from global database

cd /Users/max/.openclaw/workspace/postharvest

echo "Extracting kiwifruit companies from all country databases..."

# Create output file with header
echo "Company Name,Website,Country,State/Region,Primary Fruit,CA Storage,Notes,Source" > kiwifruit-companies-global.csv

# Search all CSVs for kiwifruit mentions
for csv in *.csv; do
  if [ "$csv" != "kiwifruit-companies-global.csv" ]; then
    grep -i "kiwifruit\|kiwi fruit" "$csv" 2>/dev/null >> kiwifruit-companies-global.csv || true
  fi
done

# Get unique companies (deduplicate)
sort kiwifruit-companies-global.csv | uniq > kiwifruit-companies-unique.csv

echo "Found $(wc -l < kiwifruit-companies-unique.csv) unique kiwifruit companies"
echo "Saved to: kiwifruit-companies-unique.csv"

# Show breakdown by country
echo ""
echo "Breakdown by country:"
awk -F',' '{print $3}' kiwifruit-companies-unique.csv | sort | uniq -c | sort -rn | head -15