#!/bin/bash
# Check hash slugs
echo "=== HASH SLUG COUNT ==="
docker exec supabase-db psql -U supabase_admin -d sneakerpicks -c "SELECT COUNT(*) FROM products WHERE slug ~ '-[0-9a-f]{6,8}$';"

echo "=== HASH SLUG EXAMPLES ==="
docker exec supabase-db psql -U supabase_admin -d sneakerpicks -c "SELECT id, slug, name, brand FROM products WHERE slug ~ '-[0-9a-f]{6,8}$' LIMIT 15;"

echo "=== TOTAL PRODUCTS ==="
docker exec supabase-db psql -U supabase_admin -d sneakerpicks -c "SELECT COUNT(*) FROM products;"

echo "=== BLOG POSTS ==="
docker exec supabase-db psql -U supabase_admin -d sneakerpicks -c "SELECT id, title, slug FROM blog_posts LIMIT 10;" 2>&1 || echo "No blog_posts table"

echo "=== PRODUCT TABLE COLUMNS ==="
docker exec supabase-db psql -U supabase_admin -d sneakerpicks -c "\d products" 

echo "=== CHECK EXISTING REDIRECT TABLE ==="
docker exec supabase-db psql -U supabase_admin -d sneakerpicks -c "\d slug_redirects" 2>&1 || echo "No slug_redirects table"