import os
import django
import sys

# Setup Django environment
sys.path.append(os.getcwd())
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'hotelfinder.settings')
django.setup()

from restaurant.models import Restaurant, MenuItem

print(f"Total Restaurants: {Restaurant.objects.count()}")
print(f"Total Menu Items: {MenuItem.objects.count()}")

for r in Restaurant.objects.all():
    count = MenuItem.objects.filter(restaurant=r).count()
    print(f"Restaurant: {r.name} (ID: {r.id}) - Menu Items: {count}")
    if count > 0:
        items = MenuItem.objects.filter(restaurant=r)[:3]
        for item in items:
            print(f"  - {item.name}: Category={item.category}, Available={item.is_available}")

print("-" * 20)
print("Global Trending Items (Random 5):")
try:
    global_items = MenuItem.objects.filter(is_available=True, restaurant__is_active=True).order_by('?')[:5]
    for item in global_items:
        print(f"  - {item.name} from {item.restaurant.name}")
except Exception as e:
    print(f"Error fetching global items: {e}")