#!/bin/bash
echo "With cutout:"
docker exec supabase-db psql -U postgres -d sneakerpicks -t -c "SELECT COUNT(*) FROM products WHERE cutout_image_url IS NOT NULL AND is_sneaker = true"
echo "Without cutout:"
docker exec supabase-db psql -U postgres -d sneakerpicks -t -c "SELECT COUNT(*) FROM products WHERE cutout_image_url IS NULL AND is_sneaker = true"
echo "Local files:"
ls /var/www/sneakerpicks/public/cutouts/*.png 2>/dev/null | wc -l