-- Script para verificar os dados reais dos establishments
-- Execute: sudo -u postgres psql -d maktubia_points -f deploy/check-establishment-data.sql

\echo '📋 Verificando dados dos establishments (primeiros 5 registros):'
\echo ''

SELECT 
    establishment_id,
    est_id,
    name,
    type,
    image_url,
    image_secondary,
    address,
    phone,
    email,
    qr_code,
    color,
    is_active,
    created_at,
    updated_at
FROM establishments 
ORDER BY created_at DESC
LIMIT 5;

\echo ''
\echo '📊 Estatísticas dos campos:'
\echo ''

SELECT 
    'image_url' as campo,
    COUNT(*) as total,
    COUNT(image_url) as nao_null,
    COUNT(*) - COUNT(image_url) as null_count
FROM establishments
UNION ALL
SELECT 
    'image_secondary',
    COUNT(*),
    COUNT(image_secondary),
    COUNT(*) - COUNT(image_secondary)
FROM establishments
UNION ALL
SELECT 
    'address',
    COUNT(*),
    COUNT(address),
    COUNT(*) - COUNT(address)
FROM establishments
UNION ALL
SELECT 
    'phone',
    COUNT(*),
    COUNT(phone),
    COUNT(*) - COUNT(phone)
FROM establishments
UNION ALL
SELECT 
    'email',
    COUNT(*),
    COUNT(email),
    COUNT(*) - COUNT(email)
FROM establishments
UNION ALL
SELECT 
    'color',
    COUNT(*),
    COUNT(color),
    COUNT(*) - COUNT(color)
FROM establishments;

\echo ''
\echo '✅ Verificação concluída!'