Django 4.1 - implementing Async Database Queries Using Async ORM in a View
I'm prototyping a solution and I'm trying to implement asynchronous database queries in my Django 4.1 application using the new async ORM capabilities. However, I'm working with a `RuntimeError: Working outside of request context` when I attempt to run the async function. My view is defined as an async function, but it seems that the database connection isn't properly managed. Here's a simplified version of my code: ```python from django.http import JsonResponse from django.views import View from .models import MyModel class MyAsyncView(View): async def get(self, request): data = await self.get_data() return JsonResponse(data) async def get_data(self): return await MyModel.objects.all().values() ``` I've tried using `database_sync_to_async` to wrap my query like this: ```python from channels.db import database_sync_to_async async def get_data(self): return await database_sync_to_async(MyModel.objects.all().values)() ``` But this approach throws `TypeError: 'coroutine' object is not subscriptable`. I also checked that my database settings in `settings.py` are correctly configured for async: ```python DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql', 'NAME': 'mydatabase', 'USER': 'myuser', 'PASSWORD': 'mypassword', 'HOST': 'localhost', 'PORT': '5432', } } ``` I'm using PostgreSQL 14 and Django 4.1. What steps can I take to resolve this scenario and successfully make async queries in my Django view? This is my first time working with Python 3.10. Any suggestions would be helpful. Thanks in advance!