import asyncio
from asgiref.sync import sync_to_async
from django.http import JsonResponse
from django.db import connection
 
class AsyncDjangoView:
    async def get(self, request):
        results = await asyncio.gather(
            self.fetch_users(),
            self.fetch_products(),
            self.fetch_orders(),
            return_exceptions=True
        )
        return JsonResponse({
            'users': results[0],
            'products': results[1],
            'orders': results[2]
        })
 
    
    @sync_to_async
    def fetch_users(self):
        with connection.cursor() as cursor:
            cursor.execute('SELECT id, name FROM auth_user LIMIT 100')
            return cursor.fetchall()
    
    @sync_to_async
    def fetch_products(self):
        from myapp.models import Product
        return list(Product.objects.filter(is_active=True)[:100].values('id', 'name'))
    
    @sync_to_async
    def fetch_orders(self):
        from myapp.models import Order
        return list(Order.objects.select_related('user').only('id', 'total', 'user__name')[:100])