#!/bin/bash
# Quick fix script for property status
# Usage: ./fix-status-quick.sh

echo "🔍 Checking database connection..."
sudo -u postgres psql -d nre -c "
-- Check current invalid statuses
SELECT 'Current invalid statuses:' as info;
SELECT DISTINCT status FROM properties WHERE status NOT IN ('upcoming', 'ongoing', 'completed') OR status IS NULL;

-- Fix invalid statuses
UPDATE properties SET status = 'upcoming' WHERE status IS NULL OR status = '' OR status NOT IN ('upcoming', 'ongoing', 'completed');

-- Verify fix
SELECT 'After fix - all statuses:' as info;
SELECT DISTINCT status FROM properties;
"
echo "✅ Done! Refresh Strapi admin panel."